Re: Rapidly decaying performance repopulating a large table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Rapidly decaying performance repopulating a large table
Дата
Msg-id 3109.1208932182@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Rapidly decaying performance repopulating a large table  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-general
Greg Smith <gsmith@gregsmith.com> writes:
> ...This is a bit out of my area, but after reading the rest of this thread I
> wonder whether raising the default_statistics_target parameter a bit might
> reduce the instances of bad plans showing up.

On the evidence so far, it doesn't seem that David's problem has
anything to do with bad plans --- I suspected that at first, but the
theory's been shot down.  I'm now thinking it's an I/O bottleneck in
some form ...

            regards, tom lane

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Rapidly decaying performance repopulating a large table
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Postgres Encoding conversion problem