postgres
postgres copied to clipboard
PostgreSQL in Neon
See https://github.com/neondatabase/neon/issues/6211
See https://github.com/neondatabase/neon/issues/6211
See https://github.com/neondatabase/neon/issues/6211
Introduce an SMGR API to PostgreSQL that Neon could plug into. Anastasia started a thread on that here: https://www.postgresql.org/message-id/CAP4vRV6JKXyFfEOf%3Dn%2Bv5RGsZywAQ3CTM8ESWvgq%2BS87Tmgx_g%40mail.gmail.com New Redux thread[^1] in commitfest[^2] [^1]: https://www.postgresql.org/message-id/flat/CAEze2WgMySu2suO_TLvFyGY3URa4mAx22WeoEicnK=PCNWEMrA@mail.gmail.com [^2]: https://commitfest.postgresql.org/43/4428/
Some Postgres indexes (GIN,GIST,SPGIST...) are using two-phase build: at first phase relation pages are constructed and at second phase - all relation is wal-logged. It doesn't work with Neon because...
Statistic is saved in local file and so lost on compute restart. Persist in in page server using the same AUX file mechanism used for replication slots See more about...
Neon architecture is very sensitive to fast prewarming of shared buffers, because it can not rely on file system cache. Prewarming can be done using pg_prewarm extension. But it requires...
use $(INSTALL_DATA) to copy header files, similar to in more recent v15 branch. this helps with unnecessary rebuilds of postgres_ffi in neon. Cc: https://github.com/neondatabase/neon/issues/1873