From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Optimizer Question/Suggestion |
Date: | 2002-11-03 11:05:03 |
Message-ID: | 1036321504.12252.8.camel@rh72.home.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Philip Warner kirjutas P, 03.11.2002 kell 15:41:
> At 03:25 PM 3/11/2002 +0500, Hannu Krosing wrote:
> >a separate backend in a loop that
> >kept doing VACUUM TABLE with only 5 seconds sleep between
>
> Good grief! I thought 5 minutes was bad enough. Can't wait for b/g vacuum.
> Thanks for the input; I'll wait for a day or so to get some figures as you
> suggest.
The 5 sec number was for case when tens of worker threads were updating
as fast as they could a table with just a few of hundreds of rows. I
guess your case is not _that_ intensive, so you can probably use much
bigger intervals.
-------
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2002-11-03 11:49:59 | Compile problem on FreeBSD/Alpha |
Previous Message | Philip Warner | 2002-11-03 10:41:57 | Re: Optimizer Question/Suggestion |