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

2005-01-21 Thread Dave Page
 

> -Original Message-
> From: Andrew Dunstan [mailto:[EMAIL PROTECTED] 
> Sent: 21 January 2005 14:01
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; 
> pgsql-patches@postgresql.org
> Subject: Re: [PATCHES] [pgsql-hackers-win32] 300 seconds in 
> less than 1 second with pg_autovacuum
> 
>
> 
> We should not be using either of these, should we? 
> pg_usleep() is platform
> independent.

True. Attached.

Regards, Dave.


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

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


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

2005-01-21 Thread 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


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

2005-01-21 Thread 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