Re: Poor Performance on Postgres 8.0 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Poor Performance on Postgres 8.0
Date
Msg-id 22896.1106941715@sss.pgh.pa.us
Whole thread Raw
In response to Re: Poor Performance on Postgres 8.0  (Pallav Kalva <pkalva@deg.cc>)
Responses Re: Poor Performance on Postgres 8.0  (Pallav Kalva <pkalva@deg.cc>)
List pgsql-performance
Pallav Kalva <pkalva@deg.cc> writes:
> still doesnt make use of the index on common.attribute table .

What do you get from just plain

explain analyze select * from common.string text1_
where text1_.value='squareFeet';

I get the impression that it must think this will yield a lot of rows.

            regards, tom lane

pgsql-performance by date:

Previous
From: Alexandre Leclerc
Date:
Subject: Re: Flattening a kind of 'dynamic' table
Next
From: Pallav Kalva
Date:
Subject: Re: Poor Performance on Postgres 8.0