Re: Strange explain on partitioned tables

Список
Период
Сортировка
От Gerald Fontenay
Тема Re: Strange explain on partitioned tables
Дата
Msg-id 4C4DFD95.4000901@lbl.gov
обсуждение исходный текст
Ответ на Re: Strange explain on partitioned tables  ("Joshua D. Drake")
Ответы Re: Strange explain on partitioned tables  (Robert Haas)
Список 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", )
Joshua D. Drake wrote:
On Fri, 2010-07-23 at 15:03 -0700, Gerald Fontenay wrote: 
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...   
It is variable based on workload and as I recall has to do with the
planning time. As the number of children increases, so does the planning
time.

Joshua D. Drake

 
Thank you for your response. So if I query only my target child table, this should be "just like" any other single table wrt planning right? I have thousands of these tables. (I suppose that I'm only using inheritance for the sake of organization in this situation...)

Thanks!
Gerald

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Testing Sandforce SSD
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...