Thanks..I'll try this. Should I also rebuild the contrib modules..or
just the core postgres database?
On Sat, Jun 5, 2010 at 2:38 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Fri, Jun 4, 2010 at 12:21 PM, Anj Adu <fotographs(at)gmail(dot)com> wrote:
>> The behaviour is different in postgres 8.1.9 (much faster) (the table
>> has 9 million rows instead of 25 million..but the query comes back
>> very fast (8 seconds)..
>>
>> Wonder if this is very specific to 8.4.0
>
> You should really be running 8.4.4.
>