News for hackers. Stuff that matters.
Re:Neon – Serverless Postgres by madelyn on Saturday May 28, 2022 @10:41AM (#31540711)
This is really interesting. Are there restrictions or limitations on the PageServer + Safekeeper design when running OLAP queries on larger datasets?

Phrased another way, would a query that needs to access a relatively large amount of data (10-100 GB) ever need to read from s3, incurring extra latency?

Re:Neon – Serverless Postgres by mattashii on Saturday May 28, 2022 @10:56AM (#31540825)
In general, all data of live clusters will also be stored locally at a PageServer.

Only in recovery scenarios will a PageServer not hold the data that is needed to serve the requests of a compute node - but that would recover quickly as the local cache of the PageServer is repopulated with data from S3.

Re:Neon – Serverless Postgres by madelyn on Saturday May 28, 2022 @10:59AM (#31540836)
Awesome, thank you!