| 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 |