Re: [GENERAL] Weird performance hit

2005-08-18 Thread Steve Crawford
On Thursday 18 August 2005 12:03 am, WireSpot wrote: > 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

Re: [GENERAL] Weird performance hit

2005-08-18 Thread Michael Fuhr
On Thu, Aug 18, 2005 at 06:26:41AM -0600, Michael Fuhr wrote: > On Thu, Aug 18, 2005 at 10:03:38AM +0300, WireSpot wrote: > > 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 on

Re: [GENERAL] Weird performance hit

2005-08-18 Thread Michael Fuhr
On Thu, Aug 18, 2005 at 10:03:38AM +0300, WireSpot wrote: > 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.

[GENERAL] Weird performance hit

2005-08-18 Thread WireSpot
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 syst