Posrgres speed problem

From: Ruben Rubio Rey <ruben(at)rentalia(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Posrgres speed problem
Date: 2006-06-12 14:38:57
Message-ID: 448D7C81.1000108@rentalia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Dutcher 2006-06-12 14:45:23 Re: Posrgres speed problem
Previous Message Sven Geisler 2006-06-12 11:21:05 Re: scaling up postgres