3 ms·
SQLite3 only has b-trees for files and indices. PostgreSQL only has heaps for tables, and various other data structures for indices, with b-tree being the defa
by cryptonector 1y ago
SQLite3 only has b-trees for files and indices.
PostgreSQL only has heaps for tables, and various other data structures for indices, with b-tree being the default for indices.
There are many cases where having b-trees for tables would make performance better.
GP is basically poking fun at PG for still having nothing but heaps for tables.