Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL BRIN index

create table foo as select bar::integer from generate_series(1,1e5) bar; create index foo_btree on foo using btree(bar); create index foo_gist on foo using gist(bar); 
create index foo_brin on foo using brin(bar);

100000 rows affected

SELECT relname, pg_size_pretty(pg_relation_size(C.oid)) "size" FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname = current_schema ORDER BY pg_relation_size(C.oid) DESC;

relname         size
foo_gist 4392 kB
foo         3544 kB
foo_btree 2208 kB
foo_brin 24 kB

Comments

Popular posts from this blog

Script to find sessions that are blocking other sessions in PostgreSQL

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL pgBadger

How to Return a Result Set from a PostgreSQL Stored Procedure