Skip site navigation (1) Skip section navigation (2)

Re: sloooow query

From: "Marie G(dot) Tuite" <marie(dot)tuite(at)edisonaffiliates(dot)com>
To: "Pgsql-Performance(at)Postgresql(dot) Org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: sloooow query
Date: 2002-10-07 22:12:41
Message-ID: IGELKLINGDMODABPOOFEEEBJCJAA.marie.tuite@edisonaffiliates.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
> 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.



In response to

pgsql-performance by date

Next:From: Martijn van OosterhoutDate: 2002-10-08 00:03:08
Subject: Re: sloooow query
Previous:From: Marie G. TuiteDate: 2002-10-07 22:09:46
Subject: Re: sloooow query

pgsql-general by date

Next:From: Roberto (SmartBit)Date: 2002-10-07 22:13:01
Subject: Re: Postgres for Windows
Previous:From: Marie G. TuiteDate: 2002-10-07 22:09:46
Subject: Re: sloooow query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group