2 ms·
As far as I know Neon has no filesystem cache, which is the most important performance enhancer for Postgres. As here are many using Neon already in production:
by WuxiFingerHold 3y ago
As far as I know Neon has no filesystem cache, which is the most important performance enhancer for Postgres. As here are many using Neon already in production: Does anyone can comment on the performance for large databases (a couple of tables with around 100 million rows) compared to RDS / Supabase / other hosted service? I can imagine that it is substantially slower. But would be happy to be surprised, if not. Or to learn how Neon compensates the missing filesystem cache.
- sakras 3y agoNeon engineer here. We implemented our own local cache between the pageserver and Postgres (called LFC). It compensates for the lack of a normal file system cache, and scales up with the rest of the autoscaling infrastructure.