Re: 300 seconds in less than 1 second with pg_autovacuum

 

> -----Original Message-----
> From: [email protected] 
> [mailto:[email protected]] On Behalf 
> Of Harald Massa
> Sent: 21 January 2005 12:55
> To: [email protected]
> 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....

/D

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match