From: | Benjamin Arai <benjamin(at)araisoft(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Shoaib Mir <shoaibmir(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [GENERAL] OUTER JOIN IS SLOW |
Date: | 2006-12-24 02:32:59 |
Message-ID: | 458DE6DB.2060609@araisoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Hi,
I did a vacuum with -z and it fixed the issue. I was not aware that
vacuumdb didn't ANALYZE by default. Thanks everybody for all of the help!
Benjamin
Tom Lane wrote:
> Benjamin Arai <benjamin(at)araisoft(dot)com> writes:
>
>> -> Index Scan using mutualfd_weekday_qbid_pkey_idx on
>> mutualfd_weekday_qbid (cost=0.00..6.01 rows=1 width=19) (actual
>> time=34.579..8510.801 rows=253 loops=1)
>> Index Cond: ((pkey >= '2005-12-15'::date) AND (pkey <=
>> '2006-12-15'::date))
>> Filter: (cusip = '92193920'::text)
>>
>
> Hm, so how many rows in mutualfd_weekday_qbid for that date?
> And how many satisfy the cusip condition? (I suppose 253,
> but it looks like that must be a very small fraction of all
> the rows for that date.)
>
> The selectivity estimators are not great about dealing with
> zero-width intervals like this one (in fact, if you look at the
> code you'll find it doesn't even bother to distinguish '>' from '>='
> ... something we should probably try to improve sometime).
>
> You'd probably have better luck if you could fold the WHERE condition
> down to "pkey = '2005-12-15'". Dunno how feasible that is for your
> application.
>
> regards, tom lane
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah | 2006-12-24 10:18:27 | psql does not save contents into file at end of command. |
Previous Message | Tom Lane | 2006-12-24 01:55:55 | Re: [GENERAL] OUTER JOIN IS SLOW |
From | Date | Subject | |
---|---|---|---|
Next Message | postgresql.org | 2006-12-24 03:49:14 | Re: Problem with index in OR'd expression |
Previous Message | Christopher Browne | 2006-12-24 02:23:14 | Re: Clustering & Load Balancing & Replication |