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

Re: sloooow query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: marie(dot)tuite(at)edisonaffiliates(dot)com
Cc: josh(at)agliodbs(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: sloooow query
Date: 2002-10-07 20:57:40
Message-ID: 26239.1034024260@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
"Marie G. Tuite" <marie(dot)tuite(at)edisonaffiliates(dot)com> writes:
> I pg_dumped the first database having performance problems and reloaded it
> into a new database on the same server.  The query ran normally when I
> reloaded it.  There is no difference in hardware, schema or anything else.

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.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Justin CliftDate: 2002-10-07 21:00:57
Subject: Re: sloooow query
Previous:From: Robert TreatDate: 2002-10-07 20:52:16
Subject: Re: sloooow query

pgsql-general by date

Next:From: Justin CliftDate: 2002-10-07 21:00:57
Subject: Re: sloooow query
Previous:From: Robert TreatDate: 2002-10-07 20:52:16
Subject: Re: sloooow query

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