Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeing context switch storm with 10/13 snapshot of - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Seeing context switch storm with 10/13 snapshot of
Date
Msg-id 200510181626.06674.josh@agliodbs.com
Whole thread Raw
In response to Re: Seeing context switch storm with 10/13 snapshot of  (Robert Creager <Robert.Creager@Sun.com>)
List pgsql-hackers
Tree view 
Robert,

> Anyone know of a script that can replay a PostgreSQL log file?  Then I
> could log all queries, wait till the problem hits, and then replay to
> see if that reproduces it...

log_statement=true in your postgresql.conf file.  The trick is weeding out 
all the other non-query stuff.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Character Conversions Handling
Next
From: "Marc G. Fournier"
Date:
Subject: Re: sort_mem statistics ...