From: Dave Dutcher <dave@tridecap.com>
To: 'Ruben Rubio Rey' <ruben@rentalia.com>
To: pgsql-performance@postgresql.org
Subject: Re: Posrgres speed problem
Date: Mon, 12 Jun 2006 09:45:23 -0500
Message-ID: <024c01c68e2e$d7441180$8300a8c0@tridecap.com> (raw)
In-Reply-To: <448D7C81.1000108@rentalia.com>
Do you run analyze on the production server regularly?
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of
> Ruben Rubio Rey
> Sent: Monday, June 12, 2006 9:39 AM
> To: pgsql-performance@postgresql.org
> Subject: [PERFORM] Posrgres speed problem
>
>
>
> Hi,
>
> Im having a problem with postgres 8.1.3 on a Fedora Core 3 (kernel
> 2.6.9-1.667smp)
>
> 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!
>
> Could it be a it a bug?
> Any ideas?
>
> Thanks in advance
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
http://www.postgresql.org/docs/faq
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dave@tridecap.com, ruben@rentalia.com
Subject: Re: Posrgres speed problem
In-Reply-To: <024c01c68e2e$d7441180$8300a8c0@tridecap.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox