Re: atrocious update performance

Поиск
Список
Период
Сортировка
От Rosser Schwarz
Тема Re: atrocious update performance
Дата
Msg-id 003c01c410f1$0192d7e0$2500fa0a@CardServices.TCI.com
обсуждение исходный текст
Ответ на Re: atrocious update performance  (Greg Spiegelberg <gspiegelberg@cranel.com>)
Ответы Re: atrocious update performance  (Greg Spiegelberg <gspiegelberg@cranel.com>)
Список pgsql-performance
Greg Spiegelberg wrote:

> I've been following this thread closely as I have the same problem
> with an UPDATE.  Everything is identical here right down to the
> strace output.

> Has anyone found a workaround or resolved the problem?  If not,
> I have test systems here which I can use to help up test and explore.

I'm still gathering data.  The explain analyze I'd expected to finish
Thursday afternoon hasn't yet.  I'm going to kill it and try a few
smaller runs, increasing in size, until the behavior manifests.

Will advise.

/rls


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Optimisation of INTERSECT expressions
Следующее
От: "Phil Endecott"
Дата:
Сообщение: Re: Optimisation of INTERSECT expressions