| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Status of autovacuum and the sporadic stats failures ? |
| Date: | 2007-02-06 21:52:32 |
| Message-ID: | 45C8F8A0.4010605@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> I'm tempted to propose replacing the fixed sleep with a short plpgsql
> function that sleeps for a second, checks to see if the stats have
> changed, repeats if not; giving up only after perhaps 30 seconds.
>
> It'd be interesting to try to gather stats on the length of the delay
> taken, but I don't see a good way to do that within the current
> regression-test infrastructure.
>
>
>
Have it log something that will appear on the postmaster log but not the
client log? Buildfarm members mostly post their complete postmaster
logs, and we could postprocess those.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2007-02-06 21:54:20 | proposed todo: use insert/update returning anywhere a table is allowed |
| Previous Message | Bruce Momjian | 2007-02-06 21:43:06 | Re: Re: [COMMITTERS] pgsql: Add documentation for Windows on how to set an environment |