- Postgres query dramatically slow on prod, but very fast on local laptop
- Postgresql: How is index scan cost calculated in execution plan?
- Different query plan for GROUP BY DISTINCT query on 2 distinct machines
- Postgres slow query (slow index scan)
- What are the best values for Postgresql.conf for better performance
- Re: Consider low startup cost in add_partial_path
- Planner chose a much slower plan in hashjoin, using a large table as the inner table.
- Re: A wrong index choose issue because of inaccurate statistics
- Re: Disk-based hash aggregate's cost model
- Re: Make the qual cost on index Filter slightly higher than qual cost on index Cond.