| From: | Anj Adu <fotographs(at)gmail(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andy Colson <andy(at)squeakycode(dot)net>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: slow query performance |
| Date: | 2010-06-10 15:32:43 |
| Message-ID: | AANLkTikb6ap3kMKVoatB3nT5xQeir61sA920NicU2AGm@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Attached
Thank you
On Thu, Jun 10, 2010 at 6:28 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Wed, Jun 9, 2010 at 11:17 PM, Anj Adu <fotographs(at)gmail(dot)com> wrote:
>> The plan is unaltered . There is a separate index on theDate as well
>> as one on node_id
>>
>> I have not specifically disabled sequential scans.
>
> Please do "SHOW ALL" and attach the results as a text file.
>
>> This query performs much better on 8.1.9 on a similar sized
>> table.(althought the random_page_cost=4 on 8.1.9 and 2 on 8.4.0 )
>
> Well that could certainly matter...
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise Postgres Company
>
| Attachment | Content-Type | Size |
|---|---|---|
| showall.txt | text/plain | 19.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Max Williams | 2010-06-10 15:40:06 | Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? |
| Previous Message | Heikki Linnakangas | 2010-06-10 15:27:16 | Re: Autovaccum settings while Bulk Loading data |