X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 90C809F9CAA for ; Tue, 13 Jun 2006 03:37:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 36304-06 for ; Tue, 13 Jun 2006 03:37:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.rentalia.net (mail.rentalia.com [213.192.209.8]) by postgresql.org (Postfix) with ESMTP id CA65B9F9316 for ; Tue, 13 Jun 2006 03:37:48 -0300 (ADT) Received: (qmail 15391 invoked by uid 514); 13 Jun 2006 08:37:46 +0200 Received: from 62.37.216.115 by rigodon (envelope-from , uid 512) with qmail-scanner-1.25-st-qms (clamdscan: 0.88/1284. spamassassin: 3.0.2. perlscan: 1.25-st-qms. Clear:RC:0(62.37.216.115):SA:0(-2.2/5.0):. Processed in 4.731492 secs); 13 Jun 2006 06:37:46 -0000 X-Antivirus-MYDOMAIN-Mail-From: ruben@rentalia.com via rigodon X-Antivirus-MYDOMAIN: 1.25-st-qms (Clear:RC:0(62.37.216.115):SA:0(-2.2/5.0):. Processed in 4.731492 secs Process 15373) Received: from 62-37-216-115.mad1.adsl.uni2.es (HELO ?192.168.2.28?) (ruben@rentalia.com@62.37.216.115) by mail.rentalia.net with SMTP; 13 Jun 2006 08:37:41 +0200 Message-ID: <448E5D30.6010600@rentalia.com> Date: Tue, 13 Jun 2006 08:37:36 +0200 From: Ruben Rubio Rey User-Agent: Mozilla Thunderbird 1.0.8 (X11/20060503) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Jim C. Nasby" , pgsql-performance@postgresql.org Subject: Re: Posrgres speed problem References: <448D7C81.1000108@rentalia.com> <20060612150506.GA50764@winnie.fuhr.org> <20060612152354.GT34196@pervasive.com> In-Reply-To: <20060612152354.GT34196@pervasive.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/165 X-Sequence-Number: 19522 Jim C. Nasby wrote: >On Mon, Jun 12, 2006 at 09:05:06AM -0600, Michael Fuhr wrote: > > >>On Mon, Jun 12, 2006 at 04:38:57PM +0200, Ruben Rubio Rey wrote: >> >> >>>I have two similar servers, one in production and another for testing >>>purposes. >>>Databases are equal (with a difference of some hours) >>> >>>In the testing server, an sql sentence takes arround 1 sec. >>>In production server (low server load) takes arround 50 secs, and uses >>>too much resources. >>> >>>Explain analyze takes too much load, i had to cancel it! >>> >>> >>The EXPLAIN ANALYZE output would be helpful, but if you don't want >>to run it to completion then please post the output of EXPLAIN >>ANALYZE for the fast system and EXPLAIN (without ANALYZE) for the >>slow one. >> >>As someone else asked, are you running ANALYZE regularly? What >>about VACUUM? >> >> > >For the next vacuum, can you add the -v (verbose) switch and email the >last few lines of output? > >INFO: free space map contains 39 pages in 56 relations >DETAIL: A total of 896 page slots are in use (including overhead). >896 page slots are required to track all free space. >Current limits are: 20000 page slots, 1000 relations, using 223 KB. >VACUUM > > INFO: free space map contains 1624 pages in 137 relations DETAIL: A total of 3200 page slots are in use (including overhead). 3200 page slots are required to track all free space. Current limits are: 20000 page slots, 1000 relations, using 182 KB.