Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine - Mailing list pgsql-performance

From Tom Lane
Subject Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine
Date
Msg-id 16088.1271362441@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-performance
Alvaro Herrera <alvherre@commandprompt.com> writes:
> We don't call pollsys anywhere.  Something in Solaris must be doing it
> under the hood.

pg_usleep calls select(), and some googling indicates that select() is
implemented as pollsys() on recent Solaris versions.  So Josh's
assumption that those are delay calls seems plausible.  But it shouldn't
be sleeping after each page with normal cost_delay parameters, should it?

            regards, tom lane

pgsql-performance by date:

Previous
From: Dave Crooke
Date:
Subject: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine