Weird performance hit

From: WireSpot <wirespot(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Weird performance hit
Date: 2005-08-18 07:03:38
Message-ID: b2d4b038050818000343a37fdc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have two practically identical Debian-testing systems installed on
two harddrives on the same machine. I've compiled Postgres 8.0.3 with
exactly the same options on both. Both HDD use the same kernel, have
DMA enabled and so on. I have the same database and web applications
installed in both systems.

However, one application is for some weird reason taking a serious
performance hit on certain pages. There are some intensive joins and
selects there, but somehow one install manages a couple of seconds and
the other takes about 10.

Any ideas? I've tried copying Postgres and the repository over from
the good install, it does the same thing. Does this suggest that it's
not a Postgres issue?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marko Kreen 2005-08-18 08:10:54 Re: Adding contrib modules
Previous Message Nikola Milutinovic 2005-08-18 05:57:59 Re: How to secure PostgreSQL Data for distribute?