News for hackers. Stuff that matters.
Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by cryptonector on Wednesday May 07, 2025 @07:53PM (#43921660)
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.

There are no comments on this comment yet.