[PERFORM] Implementatiion of Inheritance in Postgres

2004-07-07 Thread Ioannis Theoharis
I would like to ask you where i can find information about the implementation of the inheritance relationship in Postgres. There are several ways to store and to retrieve instances contained in an hierarchie. Which clustering and buffer replacement policy implements Postgres? There is a system

[PERFORM] Page Miss Hits

2004-08-02 Thread Ioannis Theoharis
Hi, i would like to answer if there is any way in postgres to find the page miss hits caused during a query execution. Is there something like explain analyze with the page miss hits??? ---(end of broadcast)--- TIP 3: if posting/reading through U

Re: [PERFORM] inheritance performance

2005-01-21 Thread Ioannis Theoharis
On Fri, 21 Jan 2005, Greg Stark wrote: > There's also a slight performance hit because there's an optimization that the > planner does normally for simple queries that isn't currently done for either > UNION ALL or inherited tables. I think it's planned to fix that soon. Can you explain me in m