Posrgres speed problem - Mailing list pgsql-performance

From Ruben Rubio Rey
Subject Posrgres speed problem
Date
Msg-id 448D7C81.1000108@rentalia.com
Whole thread Raw
Responses Re: Posrgres speed problem
Re: Posrgres speed problem
Re: Posrgres speed problem
List pgsql-performance
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



pgsql-performance by date:

Previous
From: Sven Geisler
Date:
Subject: Re: scaling up postgres
Next
From: "Dave Dutcher"
Date:
Subject: Re: Posrgres speed problem