Re: [PERFORM] crosstab speed

2008-11-13 Thread Joe Conway
Jeremiah Elliott wrote: ok, I have an application that I am trying to speed up. Its a reporting application that makes heavy use of the crosstab function. here is an example query The crostab function is taking between 5 and 15 seconds to return. Please run the two embedded queries ind

Re: [PERFORM] crosstab speed

2008-11-13 Thread Scott Marlowe
On Thu, Nov 13, 2008 at 1:42 PM, Jeremiah Elliott <[EMAIL PROTECTED]> wrote: > ok, I have an application that I am trying to speed up. Its a reporting > application that makes heavy use of the crosstab function. > > Here is some of the setup / configuration details: > Postgres 8.3.3 > RedHat Enterp

[PERFORM] crosstab speed

2008-11-13 Thread Jeremiah Elliott
ok, I have an application that I am trying to speed up. Its a reporting application that makes heavy use of the crosstab function. Here is some of the setup / configuration details: Postgres 8.3.3 RedHat Enterprise 5.2 (2.6.18 kernel) sun x4600, 8 dual core opteron 8218 processors, 32BG, StorageT