On 2008-04-02 09:30, mark wrote: > Based on what Tomasz suggested a day ago, I had changed settings to > checkpoint_segments = 16 > checkpoint_timeout = 20min > checkpoint_completion_target = 0.8 > but i still do get statements that take over 2 or 3 seconds to execute > sometimes... should I increase checkpoint_segments to 30 now?
Go for it. Even 64 (I like round numbers) would not be too much. This would make 1GB of data in WALs. > Should I change checkpoint_timeout & checkpoint_completion_target too?? I'd recommend not. Too much and your recovery time would be in hours. And too big checkpoint_completion_target could make your original problem even worse. Regards Tometzky -- ...although Eating Honey was a very good thing to do, there was a moment just before you began to eat it which was better than when you were... Winnie the Pooh -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general