Re: [PERFORM] Posrgres speed problem - solved!

2006-06-13 Thread Guido Neitzer
On 13.06.2006, at 12:33 Uhr, Ruben Rubio Rey wrote: Seems autovacumm is working fine. Logs are reporting that is being useful. But server load is high. Is out there any way to stop "autovacumm" if server load is very high? Look at the cost settings for vacuum and autovacuum. From the manu

Re: [PERFORM] Posrgres speed problem - solved!

2006-06-13 Thread Ruben Rubio Rey
Seems autovacumm is working fine. Logs are reporting that is being useful. But server load is high. Is out there any way to stop "autovacumm" if server load is very high? Thanks everyone!!! ---(end of broadcast)--- TIP 3: Have you checked our e

Re: [PERFORM] Posrgres speed problem - solved?

2006-06-13 Thread Ruben Rubio Rey
Guido Neitzer wrote: On 13.06.2006, at 8:44 Uhr, Ruben Rubio Rey wrote: Tonight database has been vacumm full and reindex (all nights database do it) Now its working fine. Speed is as spected. I ll be watching that sql ... Maybe the problem exists when database is busy, or maybe its sol

Re: [PERFORM] Posrgres speed problem - solved?

2006-06-13 Thread Guido Neitzer
On 13.06.2006, at 8:44 Uhr, Ruben Rubio Rey wrote: Tonight database has been vacumm full and reindex (all nights database do it) Now its working fine. Speed is as spected. I ll be watching that sql ... Maybe the problem exists when database is busy, or maybe its solved ... Depending on

Re: [PERFORM] Posrgres speed problem - solved?

2006-06-12 Thread Ruben Rubio Rey
Tonight database has been vacumm full and reindex (all nights database do it) Now its working fine. Speed is as spected. I ll be watching that sql ... Maybe the problem exists when database is busy, or maybe its solved ... ---(end of broadcast)---