Re: slow query performance

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Anj Adu <fotographs(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 13:28:23
Message-ID: AANLkTilaSzbOcehwuWtA3FPunLgGwqHZUh9bu5VBuuBX@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2010-06-10 13:29:41 Re: [PERFORM] No hash join across partitioned tables?
Previous Message AI Rumman 2010-06-10 13:17:25 Re: query hangs