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

Re: Optimizer seems to be way off, why?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: John A Meinel <john(at)arbash-meinel(dot)com>
Cc: lutzeb(at)aeccom(dot)com, Richard Huxton <dev(at)archonet(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimizer seems to be way off, why?
Date: 2005-07-21 16:40:17
Message-ID: 87vf34cdu6.fsf@stark.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-performance
John A Meinel <john(at)arbash-meinel(dot)com> writes:

> Now if you created the index on b(r,c), then it would have a much better
> idea of how selective that would be. At the very least, it could index
> on (r,c) rather than indexing on (r) and filtering by (c).

There has been some discussion of adding functionality like this but afaik no
version of Postgres actually does this yet.

Adding the index may still help though.



-- 
greg


In response to

pgsql-performance by date

Next:From: Frank WosczynaDate: 2005-07-21 18:26:04
Subject: Re: What is best way to stream terabytes of data into
Previous:From: Jeffrey TennyDate: 2005-07-21 15:58:57
Subject: What is best way to stream terabytes of data into postgresql?

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