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

Re: sloooow query

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: <marie(dot)tuite(at)edisonaffiliates(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: sloooow query
Date: 2002-10-07 20:12:21
Message-ID: 200210071312.21476.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
Marie,

> 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.

That's a pretty brutal query.  

From the comparison between the two queries, it looks like you have a lot of 
discarded rows cluttering up the original database, just like I did.  

What happens if you run VACUUM FULL VERBOSE on the Bad database?  Does it 
report lots of rows taken up?

-- 
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology 	josh(at)agliodbs(dot)com
    and data management solutions 	(415) 565-7293
   for law firms, small businesses 	 fax 621-2533
    and non-profit organizations. 	San Francisco


In response to

Responses

pgsql-performance by date

Next:From: Justin CliftDate: 2002-10-07 20:15:35
Subject: Re: sloooow query
Previous:From: Marie G. TuiteDate: 2002-10-07 19:53:35
Subject: Re: sloooow query

pgsql-general by date

Next:From: Justin CliftDate: 2002-10-07 20:15:35
Subject: Re: sloooow query
Previous:From: Roberto (SmartBit)Date: 2002-10-07 20:08:49
Subject: firstest doubts...

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