Skip site navigation (1) Skip section navigation (2)

Re: Postgresql 8.1.4 - performance issues for select on view using max

From: Dimitri Fontaine <dim(at)dalibo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Ioana Danes <ioanasoftware(at)yahoo(dot)ca>
Subject: Re: Postgresql 8.1.4 - performance issues for select on view using max
Date: 2006-10-18 21:19:39
Message-ID: 200610182319.41920.dim@dalibo.com (view raw or flat)
Thread:
Lists: pgsql-performance
Le mercredi 18 octobre 2006 23:02, Ioana Danes a écrit :
> I tried the partitioning scenario but I've got into
> the same problem. The max function is not using the
> indexes on the two partitioned tables...
>
> Any other thoughts?

Did you make sure your test included table inheritance?
I'm not sure the planner benefits from constraint_exclusion without selecting 
the empty parent table (instead of your own union based view).

-- 
Dimitri Fontaine
http://www.dalibo.com/

In response to

Responses

pgsql-performance by date

Next:From: Jeff DavisDate: 2006-10-18 21:33:49
Subject: Re: Postgresql 8.1.4 - performance issues for select on
Previous:From: Jim C. NasbyDate: 2006-10-18 21:19:29
Subject: Re: UDF and cache

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group