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

Re: partitioned table performance

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Andreas Kostyrka" <andreas(at)kostyrka(dot)org>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: partitioned table performance
Date: 2006-10-30 22:46:43
Message-ID: 1162248403.11568.370.camel@silverbirch.site (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, 2006-10-30 at 22:58 +0100, Andreas Kostyrka wrote:
> Am Montag, den 30.10.2006, 08:18 +0000 schrieb Simon Riggs:
> > On Sun, 2006-10-29 at 00:28 +0200, Andreas Kostyrka wrote:
> > 
> > > Any ideas how to make the optimizer handle partitioned tables more
> > > sensible? 
> > 
> > Yes, those are known inefficiencies in the current implementation which
> > we expect to address for 8.3.
> 
> Any ideas to force the current optimizer to do something sensible?

Brute force & ignorance: PL/pgSQL

Perhaps some other domain knowledge might help you shorten the search?

Thats all for now. It's not a minor fixup and nobody had time to fix
that for 8.2 since other fish were bigger.

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com



In response to

pgsql-performance by date

Next:From: Leif MortensonDate: 2006-10-31 04:04:12
Subject: Index ignored on column containing mostly 0 values
Previous:From: Andreas KostyrkaDate: 2006-10-30 21:58:15
Subject: Re: partitioned table performance

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