Do you run analyze on the production server regularly?
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster