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

Re: sloooow query

From: "Marie G(dot) Tuite" <marie(dot)tuite(at)edisonaffiliates(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <josh(at)agliodbs(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: sloooow query
Date: 2002-10-07 22:04:09
Message-ID: IGELKLINGDMODABPOOFEMEBHCJAA.marie.tuite@edisonaffiliates.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
I have analyzed, vacuumed and reindexed.

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Monday, October 07, 2002 3:58 PM
> To: marie(dot)tuite(at)edisonaffiliates(dot)com
> Cc: josh(at)agliodbs(dot)com; pgsql-performance(at)postgresql(dot)org
> Subject: Re: [pgsql-performance] sloooow query 
> 
> 
> "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

pgsql-performance by date

Next:From: Marie G. TuiteDate: 2002-10-07 22:05:41
Subject: Re: sloooow query
Previous:From: Justin CliftDate: 2002-10-07 21:00:57
Subject: Re: sloooow query

pgsql-general by date

Next:From: Marie G. TuiteDate: 2002-10-07 22:05:41
Subject: Re: sloooow query
Previous:From: Justin CliftDate: 2002-10-07 21:00:57
Subject: Re: sloooow query

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