Re: tables with 300+ partitions

Поиск
Список
Период
Сортировка
От Steven Flatt
Тема Re: tables with 300+ partitions
Дата
Msg-id 357fa7590710301400x3a05796dle6bae219a1a25fc@mail.gmail.com
обсуждение исходный текст
Ответ на tables with 300+ partitions  (Pablo Alcaraz <pabloa@laotraesquina.com.ar>)
Ответы Re: tables with 300+ partitions  (Pablo Alcaraz <pabloa@laotraesquina.com.ar>)
Список pgsql-performance
On 10/30/07, Pablo Alcaraz <pabloa@laotraesquina.com.ar> wrote:
I did some testing. I created a 300 partitioned empty table. Then, I
inserted some rows on it and the perfomance was SLOW too.
 
Is the problem with inserting to the partitioned table or selecting from it?  It sounds like inserting is the problem in which case I ask: how are you redirecting inserts to the appropriate partition?  If you're using rules, then insert performance will quickly degrade with number of partitions as *every* rule needs to be evaluated for *every* row inserted to the base table.  Using a trigger which you can modify according to some schedule is much faster, or better yet, use some application-level logic to insert directly to the desired partition.
 
Steve
 

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Optimizing PostgreSQL for Windows
Следующее
От: cluster
Дата:
Сообщение: Two fast queries get slow when combined