Andrew,

Andrew Sullivan wrote:
> Is it exactly half an hour?  What changes at the time that happens
> (i.e. what else happens on the machine?).  Is this a time, for
> example, when logrotate is killing your I/O with file moves?

No, it's not exactly half an hour. It's just that it slows down for some time (10, 20, 30 minutes) and then it's OK again. It happens several times per day. I checked if there are other processes running when we have this slow down but it's not the case. There's not really a difference between when it's OK or not (apart from the number of connections because the db is too slow): load is still at 4 or 5, iowait is still at 0%, there's still cpu idle and we still have free memory. I can't find what is the limit and why there is cpu idle.

I forgot to give our non default postgresql.conf parameters:
shared_buffers = 28800
sort_mem = 32768
vacuum_mem = 32768
max_fsm_pages = 350000
max_fsm_relations = 2000
checkpoint_segments = 16
effective_cache_size = 270000
random_page_cost = 2

Thanks for your help

--
Guillaume

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to