Re: Strange explain on partitioned tables

Список
Период
Сортировка
От Gerald Fontenay
Тема Re: Strange explain on partitioned tables
Дата
Msg-id 4C4A11CB.6040800@lbl.gov
обсуждение исходный текст
Ответ на Re: Strange explain on partitioned tables  (Greg Smith)
Ответы Re: Strange explain on partitioned tables  ("Joshua D. Drake")
Re: Strange explain on partitioned tables  (Greg Smith)
Re: Strange explain on partitioned tables  ("Joshua D. Drake")
Список pgsql-performance
Дерево обсуждения
Strange explain on partitioned tables  (Philippe Rimbault, )
 Re: Strange explain on partitioned tables  (Philippe Rimbault, )
  Re: Strange explain on partitioned tables  (Philippe Rimbault, )
 Re: Strange explain on partitioned tables  (Greg Smith, )
  Re: Strange explain on partitioned tables  (Philippe Rimbault, )
  Re: Strange explain on partitioned tables  (Gerald Fontenay, )
   Re: Strange explain on partitioned tables  ("Joshua D. Drake", )
    Re: Strange explain on partitioned tables  (Gerald Fontenay, )
    Re: Strange explain on partitioned tables  (Gerald Fontenay, )
     Re: Strange explain on partitioned tables  (Robert Haas, )
   Re: Strange explain on partitioned tables  (Greg Smith, )
   Re: Strange explain on partitioned tables  ("Joshua D. Drake", )
> The PostgreSQL partitioning system is aimed to support perhaps a
> hundred inherited tables.  You can expect to get poor performance on
> queries if you create 1000 of them.

Hi,

Why is that you would expect poor performance for say 1000 or more? I
have a ~1000 inherited tables and I don't see any significant slowdowns.
I only ever access a single inherited table at a time though in this
situation. I suppose I am using inheritance only for organization in
this case...

Thanks,
Gerald





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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Pooling in Core WAS: Need help in performance tuning.
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Strange explain on partitioned tables