postgresperf

7 ms·

1. 1.▲
   by postgresperf 1mo ago

   When I got early access to pgrust my first question was whether it had been tested for building read-only standby analytics questions. The problem has goals beyond that, but having a real analytics node available just by playing WAL data f
2. 2.▲
   by postgresperf 1mo ago

   Optimizing a multi-layer cache system is a Complex System task with no subset you can reduce to a simpler version of the problem. PG has a 3 layer cache--database, OS, storage--and when you combine that with concurrency and locality, you h
3. 3.▲
   by postgresperf 1mo ago

   The pgrust team asked me to look at their results on a review system, and I confirmed the ClickBench speedup there. Regular PostgreSQL is really terrible at some of these queries. Unfortunately fixing that is hard to do in core itself bec
4. 4.▲
   by postgresperf 2y ago

   There's a whole talk about it we had in our conference: https://www.youtube.com/watch?v=TG28lRoailE Short version is GIS indexes are notably smaller and build faster in PG15 than earlier versions. It's a major ve
5. 5.▲
   by postgresperf 2y ago

   Contributor to the PG bulk loading docs you referenced here. Good survey of the techniques here. I've done a good bit of this trying to speed up loading the Open Street Map database. Presentation at https://www.youtube.co