Re: [PERFORM] extremly bad select performance on huge table

Hi, with a cursor the behaviour is the same. So I would like to ask a more general question: My client needs to receive data from a huge join. The time the client waits for being able to fetch the first row is very long. When the retrieval starts after about 10 mins, the client itself is I/O

[PERFORM] Checkpoints tuning

I have saved data from pg_stat_bgwriter view following Greg Smith's advice from his book: select now(),* from pg_stat_bgwriter; and then aggregated the data with query from his book as well. checkpoint segments was first 30 and next day I have increased it to 200, and results has changed: