Re: table partioning performance

Поиск
Список
Период
Сортировка
От Steven Flatt
Тема Re: table partioning performance
Дата
Msg-id 357fa7590701101300m2812545k1487ca58e97970ed@mail.gmail.com
обсуждение исходный текст
Ответ на Re: table partioning performance  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: table partioning performance
Список pgsql-performance
On 1/9/07, Simon Riggs <simon@2ndquadrant.com> wrote:
If you are doing date range partitioning it should be fairly simple to
load data into the latest table directly. That was the way I originally
intended for it to be used. The rules approach isn't something I'd
recommend as a bulk loading option and its a lot more complex anyway.
The problem we have with blindly loading all data into the latest table is that some data (< 5%, possibly even much less) is actually delivered "late" and belongs in earlier partitions.  So we still needed the ability to send data to an arbitrary partition.
 
Steve
 

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Performance of PostgreSQL on Windows vs Linux
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Partitioning