Re: does wal archiving block the current client connection?

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: does wal archiving block the current client connection?
Дата
Msg-id Pine.LNX.4.64.0605180750580.5387@discord.home.frostconsultingllc.com
обсуждение исходный текст
Ответ на Re: does wal archiving block the current client connection?  (Simon Riggs <simon@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: does wal archiving block the current client connection?
Следующее
От: Warren Little
Дата:
Сообщение: query optimization - mysql vs postgresql