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
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
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