Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackers-win32pgsql-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: pg_autovacuum.c.diff
Description: application/octet-stream (795 bytes)

Responses

pgsql-patches by date

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

pgsql-hackers-win32 by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group