Re: [EXTERNAL] Re: Inserts and bad performance

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: [EXTERNAL] Re: Inserts and bad performance
Дата
Msg-id CAHOFxGoqdDyKqJDHN1vAjvRJGkFhcr98-gdfF_jkXah3AP9Z8w@mail.gmail.com
обсуждение исходный текст
Ответ на RE: [EXTERNAL] Re: Inserts and bad performance  ("Godfrin, Philippe E" <Philippe.Godfrin@nov.com>)
Список pgsql-general
How many partitions? How many rows do they have when performance is slowing considerably? Does this table get many updates or is it insert only? What version of PostgreSQL? Are the inserts randomly distributed among the partitions or targeting one or a few partitions? Are you able to capture an example and run it in a transaction with explain (analyze, buffers, verbose) and then rollback?


Michael Lewis  |  Database Engineer
Entrata

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

Предыдущее
От: "Godfrin, Philippe E"
Дата:
Сообщение: RE: [EXTERNAL] Re: Inserts and bad performance
Следующее
От: David Rowley
Дата:
Сообщение: Re: [EXTERNAL] Re: Inserts and bad performance