Re: Tweaking PG (again)

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Tweaking PG (again)
Дата
Msg-id dcc563d10811131110g574d1079vaa5757d8efa6031@mail.gmail.com
обсуждение исходный текст
Ответ на Tweaking PG (again)  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Ответы Re: Tweaking PG (again)  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Список pgsql-general
On Thu, Nov 13, 2008 at 11:59 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
> Hi.
>
> I had tweaked my PG 8.2.6 with the very kind help of this list a
> couple years ago. It has been working fine, until recently. Not sure
> if it is after the update to 8.3 or because my DB has been growing,
> but the db is very slow now and the cache doesn't seem enough.

Everything you posted looks pretty normal.  I'd find the slowest
queries and post explain analyze to see what's happening.

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

Предыдущее
От: "Phoenix Kiula"
Дата:
Сообщение: Tweaking PG (again)
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: still gin index creation takes forever