Re: 300 seconds in less than 1 second with pg_autovacuum

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Harald Massa" <ghum(at)gmx(dot)net>, <pgsql-hackers-win32(at)postgresql(dot)org>
Cc: "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: 300 seconds in less than 1 second with pg_autovacuum
Date: 2005-01-21 13:36:07
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E45285AA@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32 pgsql-patches

> -----Original Message-----
> From: pgsql-hackers-win32-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-win32-owner(at)postgresql(dot)org] On Behalf
> Of Dave Page
> Sent: 21 January 2005 13:20
> To: Harald Massa; pgsql-hackers-win32(at)postgresql(dot)org
> Subject: Re: [pgsql-hackers-win32] 300 seconds in less than 1
> second with pg_autovacuum
>
>
>
> > -----Original Message-----
> > From: pgsql-hackers-win32-owner(at)postgresql(dot)org
> > [mailto:pgsql-hackers-win32-owner(at)postgresql(dot)org] On Behalf
> > Of Harald Massa
> > Sent: 21 January 2005 12:55
> > To: pgsql-hackers-win32(at)postgresql(dot)org
> > Subject: [pgsql-hackers-win32] 300 seconds in less than 1
> > second with pg_autovacuum
> >
> > What is going wrong? I did not fiddle with the
> > "Sleep-Period", just left it
> > on default.
> >
>
> Hmm:
>
> Windows:
>
> VOID Sleep(DWORD dwMilliseconds);
>
> Unix:
>
> unsigned int sleep(unsigned int seconds);
>
> D'oh!
>
> Patch coming up....

Patch attached... Harald, do you want another exe to try?

Regards, Dave

Attachment Content-Type Size
pg_autovacuum.c.diff application/octet-stream 795 bytes

Responses

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Andrew Dunstan 2005-01-21 14:00:32 Re: [PATCHES] 300 seconds in less than 1 second with pg_autovacuum
Previous Message Dave Page 2005-01-21 13:20:06 Re: 300 seconds in less than 1 second with pg_autovacuum

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2005-01-21 14:00:32 Re: [PATCHES] 300 seconds in less than 1 second with pg_autovacuum
Previous Message Harald Massa 2005-01-21 10:36:51 Re: [PATCHES] pg_autovacuum fails to start - 8.0 Release