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" <jd@commandprompt.com>) |
Ответы |
Re: Strange explain on partitioned tables
|
Список | pgsql-performance |
Joshua D. Drake wrote:
Thanks!
Gerald
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...)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
Thanks!
Gerald
В списке pgsql-performance по дате отправления: