Re: does wal archiving block the current client connection?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: does wal archiving block the current client connection?
Date: 2006-05-18 03:24:45
Message-ID: 7583.1147922685@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

Jeff Frost <jeff(at)frostconsultingllc(dot)com> writes:
> Was the 3,000 transactions per minute helpful? What other evidence should I
> be looking for?

Did you try generating a test case using a long sleep() as a replacement
for the archive_command script? If there is a PG bug here it shouldn't
be that hard to expose it in a simple test case. I'm up to my armpits
in other stuff and don't have time to try it myself...

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2006-05-18 04:39:40 Re: does wal archiving block the current client connection?
Previous Message Jim C. Nasby 2006-05-17 22:24:45 Re: autovacuum for large periodic deletes

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2006-05-18 04:08:21 Desperately Seeking Mentors -- Right Now!
Previous Message Tom Lane 2006-05-18 02:33:47 Re: PL/pgSQL 'i = i + 1' Syntax