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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Fri, 21 Jan 2005 13:36:07 -0000
  • Message-id: <E7F85A1B5FF8D44C8A1AF6885BC9A0E45285AA(at)ratbert(dot)vale-housing(dot)co(dot)uk>

 

> -----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: pg_autovacuum.c.diff



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group