Обсуждение: Re: [pgsql-hackers-win32] 300 seconds in less than 1 second with pg_autovacuum

> -----Original Message-----
> From: pgsql-hackers-win32-owner@postgresql.org
> [mailto:pgsql-hackers-win32-owner@postgresql.org] On Behalf
> Of Dave Page
> Sent: 21 January 2005 13:20
> To: Harald Massa; pgsql-hackers-win32@postgresql.org
> Subject: Re: [pgsql-hackers-win32] 300 seconds in less than 1
> second with pg_autovacuum
>
>
>
> > -----Original Message-----
> > From: pgsql-hackers-win32-owner@postgresql.org
> > [mailto:pgsql-hackers-win32-owner@postgresql.org] On Behalf
> > Of Harald Massa
> > Sent: 21 January 2005 12:55
> > To: pgsql-hackers-win32@postgresql.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

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