Postgres Pro
Downloads
Home   >   mailing lists

Re: sloooow query - Mailing list pgsql-performance

From Marie G. Tuite
Subject Re: sloooow query
Date
Msg-id IGELKLINGDMODABPOOFEEEBJCJAA.marie.tuite@edisonaffiliates.com
Whole thread Raw
In response to Re: sloooow query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
> Have you done an ANALYZE or VACUUM ANALYZE in either database?  The
> statistics the planner is working from seem to be quite different
> in the two plans.

I have vacuumed, analysed and reindexed.

pgsql-performance by date:

Previous
From: "Marie G. Tuite"
Date:
Subject: Re: sloooow query
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [GENERAL] sloooow query