Re: Seeing context switch storm with 10/13 snapshot of

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Robert Creager <Robert(dot)Creager(at)sun(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Seeing context switch storm with 10/13 snapshot of
Date: 2005-10-18 23:26:06
Message-ID: 200510181626.06674.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Satoshi Nagayasu 2005-10-19 00:33:32 Re: sort_mem statistics ...
Previous Message Marc G. Fournier 2005-10-18 23:07:05 Re: sort_mem statistics ...