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

PostgreSQL Index

VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

How to CreateYour Own AWS Account Alias?

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

PostgreSQL ALTER TABLE ... SET LOGGED / UNLOGGED