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

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

Postgres Database Patch

PostgreSQL Database startup / shutdown /restart

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

PostgreSQL Pgbadger Installation On Linux