Attached
Thank you
On Thu, Jun 10, 2010 at 6:28 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Wed, Jun 9, 2010 at 11:17 PM, Anj Adu <fotographs@gmail.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
>