Skip site navigation (1) Skip section navigation (2)

Re: does wal archiving block the current client connection?

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Jeff Frost <jeff(at)frostconsultingllc(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:28:29
Message-ID: 1148246910.2755.70.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
On Sun, 2006-05-21 at 14:16 -0700, Jeff Frost wrote:
> 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.

So the chances of the original problem being archiver related are
receding...

-- 
  Simon Riggs
  EnterpriseDB          http://www.enterprisedb.com


In response to

Responses

pgsql-hackers by date

Next:From: Jeff FrostDate: 2006-05-21 21:39:06
Subject: Re: does wal archiving block the current client connection?
Previous:From: Jeff FrostDate: 2006-05-21 21:16:15
Subject: Re: does wal archiving block the current client connection?

pgsql-admin by date

Next:From: Jeff FrostDate: 2006-05-21 21:39:06
Subject: Re: does wal archiving block the current client connection?
Previous:From: Jeff FrostDate: 2006-05-21 21:16:15
Subject: Re: does wal archiving block the current client connection?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group