Tom Lane wrote:
> I noticed today on my own machine several strange pauses while running
> the serial regression tests --- the machine didn't seem to be hitting
> the disk nor sucking lots of CPU, it just sat there for several seconds
> and then picked up again. I wonder if that's related. It sure seems it
> must be due to autovac being on now.
The only pauses I see are are in the "stats" and the "prepared_xacts"
tests. The latter is due to a test that uses statement_timeout to
detect a lock, and the stat test does a pg_sleep(2.0) call.
Do those explain what you are seeing?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.