Re: does wal archiving block the current client connection?

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

On Fri, 19 May 2006, Simon Riggs wrote:

>> Now I can run my same pg_bench, or do you guys
>> have any other suggestions on attempting to reproduce the problem?
>
> No. We're back on track to try to reproduce the original error.

I've been futzing with trying to reproduce the original problem for a few days
and so far postgres seems to be just fine with a long delay on archiving, so
now I'm rather at a loss. In fact, I currently have 1,234 xlog files in
pg_xlog, but the archiver is happily archiving one every 5 minutes. Perhaps
I'll try a long delay followed by a failure to see if that could be it.

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2006-05-21 21:28:29 Re: does wal archiving block the current client connection?
Previous Message Ben K. 2006-05-20 16:02:59 Re: find out all users under specific user

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2006-05-21 21:28:29 Re: does wal archiving block the current client connection?
Previous Message Magnus Hagander 2006-05-21 20:59:40 FW: iDefense Q2 2006 Vulnerability Challenge