Re: Partitioning by status?

Поиск
Список
Период
Сортировка
От alexandre - aldeia digital
Тема Re: Partitioning by status?
Дата
Msg-id 4F1D976B.4040108@gmail.com
обсуждение исходный текст
Ответ на Re: Partitioning by status?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Em 13-01-2012 17:05, Josh Berkus escreveu:
> On 1/13/12 2:44 AM, alexandre - aldeia digital wrote:
>>>
>>> Also, (2) only really works if you're going to obsolesce (remove)
>>> archive records after a certain period of time.  Otherwise the
>>> sub-partitioning hurts performance.
>>>
>>
>> Is there any moves to include the "easy" table partitioning in the 9.2
>> version ?
>
> Nobody has been submitting patches.
>

I'm sorry hear this. Table partitioning is a very good helper in a large
number of performance issues. If there was a bounty to help anyone to
make this, I would be a happy contributor. :)

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: spikes in pgbench read-only results
Следующее
От: alexandre - aldeia digital
Дата:
Сообщение: Re: Discovering the most searched values for a field