Re: Strange explain on partitioned tables - Mailing list pgsql-performance

From Robert Haas
Subject Re: Strange explain on partitioned tables
Date
Msg-id AANLkTi=7cPTu2sVDf17e5haF0vpf2Gh33qYqsKSOAkJE@mail.gmail.com
Whole thread Raw
In response to Re: Strange explain on partitioned tables  (Gerald Fontenay <gvfontenay@lbl.gov>)
List pgsql-performance
On Mon, Jul 26, 2010 at 5:26 PM, Gerald Fontenay <gvfontenay@lbl.gov> wrote:
> 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...)

Yeah, I wouldn't expect planning time to be affected by whether a
table has parents; only whether it has children.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Questions on query planner, join types, and work_mem
Next
From: "Kevin Grittner"
Date:
Subject: Re: Questions on query planner, join types, and work_mem