Re: [PERFORM] performance issue with a specific query

2006-07-28 Thread Eliott
Hi!thanks for the quick helpi managed to reduce the response time from seemingly taking infinity to a tolerable level, which is by the way a huge improvement. What helped was the functional index on date_trunc('day',yourfieldhere) as Scott suggested. I tried to disable the geqo, but it didn't make

Re: [PERFORM] performance issue with a specific query

2006-07-27 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Joshua D. Drake wrote: >> Enterprises are not going to compile. They are going to accept the >> latest support by vendor release. >> >> Redhat has a tendency to be incredibly stupid about this particular >> area of their packaging. > Stupid how? Re

Re: [PERFORM] performance issue with a specific query

2006-07-27 Thread Alvaro Herrera
Joshua D. Drake wrote: > >> > > > >try turning off genetic query optimization. regarding the rhel4 > >issue...does rhel not come with a c compiler? :) > > Enterprises are not going to compile. They are going to accept the > latest support by vendor release. > > Redhat has a tendency to be incr

Re: [PERFORM] performance issue with a specific query

2006-07-27 Thread Joshua D. Drake
try turning off genetic query optimization. regarding the rhel4 issue...does rhel not come with a c compiler? :) Enterprises are not going to compile. They are going to accept the latest support by vendor release. Redhat has a tendency to be incredibly stupid about this particular area

Re: [PERFORM] performance issue with a specific query

2006-07-27 Thread Merlin Moncure
On 7/27/06, Eliott <[EMAIL PROTECTED]> wrote: Hi! I hope I'm sending my question to the right list, please don't flame if it's the wrong one. I have noticed that while a query runs in about 1.5seconds on a 8.xx version postgresql server on our 7.4.13 it takes around 15-20 minutes. Since we are

Re: [PERFORM] performance issue with a specific query

2006-07-27 Thread Scott Marlowe
On Thu, 2006-07-27 at 09:23, Eliott wrote: > Hi! > > I hope I'm sending my question to the right list, please don't flame > if it's the wrong one. > > I have noticed that while a query runs in about 1.5seconds on a 8.xx > version postgresql server on our 7.4.13 it takes around 15-20 minutes. > Si

[PERFORM] performance issue with a specific query

2006-07-27 Thread Eliott
Hi!I hope I'm sending my question to the right list, please don't flame if it's the wrong one.I have noticed that while a query runs in about 1.5seconds on a 8.xx version postgresql server on our 7.4.13 it takes around 15-20 minutes. Since we are using RHEL4 on our server we are stuck with 7.4.13.