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


Popular posts from this blog

PostgreSQL pgBadger

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

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

PostgreSQL Pgbadger Installation On Linux

PostgreSQL Database startup / shutdown /restart