Re: Large database help

Поиск
Список
Период
Сортировка
От Ragnar Kjørstad
Тема Re: Large database help
Дата
Msg-id 20010424023130.D7572@vestdata.no
обсуждение исходный текст
Ответ на Re: Large database help  (xbdelacour@yahoo.com)
Список pgsql-admin
On Mon, Apr 23, 2001 at 08:15:05PM -0400, xbdelacour@yahoo.com wrote:
> Then, please correct me if I'm wrong: I should be able to test your
> hypothesis by creating a small DB (of say 2MB) and setting up at least a
> dozen backends to tag it. If I get the same symptoms w/ respect to disk
> activity/performance then we could say that the problem is not related to
> shared memory/the amount of data/swapping.

I'm no expert, but I guess so.

> What log files are output from postgres? I was under the impression that
> postmaster's stdout/stderr were the only output. I've been postmaster
> xyz >& log.txt'ing it. I'll check into this.

There is a transaction log named pg_log. I'm not sure exactly under what
conditions postgres writes to that file, and what - others will be able
to answer that.


--
Ragnar Kjørstad

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: createdb failing
Следующее
От: "Andrzej Kwiatkowski"
Дата:
Сообщение: error compiling 7.1 on Solaris 8 x86 (long)