Re: does wal archiving block the current client connection? - Mailing list pgsql-admin

From Jeff Frost
Subject Re: does wal archiving block the current client connection?
Date
Msg-id Pine.LNX.4.64.0605180750580.5387@discord.home.frostconsultingllc.com
Whole thread Raw
In response to Re: does wal archiving block the current client connection?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-admin
On Thu, 18 May 2006, Simon Riggs wrote:

> Seems so.
>
> Can you post the full test, plus full execution log.
>
> [You don't need to "cat" you could just do "ls" instead FWIW]
>
> Are you doing *anything* with pg_xlog directory or below? I understand
> your saying No to that question and pg_xlog has not been moved, its just
> underneath data directory, which is on normal disk?

I did a fresh compile of 8.1.3 with --prefix=/usr/local/pgsql-8.1.3.  On this
particular system, this is actually located on / which is /dev/md1 (a mirror).
I'll try and start a brand new version of the test so I can capture the
logging to syslog for you guys as well as the stdout on the pg_ctl console.

More later.

Unfortunately, I'm not really sure this is related to the problems we saw
before.  (i.e. the system doesn't get unusually slow or anything, nor do the
connections seems to block)

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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: does wal archiving block the current client connection?
Next
From: Warren Little
Date:
Subject: query optimization - mysql vs postgresql