Re: [PATCHES] [pgsql-hackers-win32] 300 seconds in less than 1 second with pg_autovacuum

[Dave Page]

 

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf 
 Of Dave Page
 Sent: 21 January 2005 13:20
 To: Harald Massa; [EMAIL PROTECTED]
 Subject: Re: [pgsql-hackers-win32] 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

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

Regards, Dave


pg_autovacuum.c.diff
Description: pg_autovacuum.c.diff

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [PATCHES] [pgsql-hackers-win32] 300 seconds in less than 1 second with pg_autovacuum

[Andrew Dunstan]

Dave Page said:



 Hmm:

 Windows:

 VOID Sleep(DWORD dwMilliseconds);

 Unix:

 unsigned int sleep(unsigned int seconds);

 D'oh!

 Patch coming up


We should not be using either of these, should we? pg_usleep() is platform
independent.

cheers

andrew



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster