On 17-Oct-06, at 3:05 PM, Behl, Rohit ((Infosys)) wrote: HiWe are facing performance problems in postgres while executing a query. When I execute this query on the server it takes 5-10 seconds. Also I get good performance while executing this query from my code in java with the hard codes values.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:pgsql-performance-
[EMAIL PROTECTED] On Behalf Of Joshua D. Drake
Sent: Friday, October 20, 2006 2:52 PM
To: Ben Suffolk
Cc: Dave Cramer; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] New hardware thoughts
Ben Suffolk
On 20-10-2006 16:58 Dave Cramer wrote:
Ben,
My option in disks is either 5 x 15K rpm disks or 8 x 10K rpm disks
(all SAS), or if I pick a different server I can have 6 x 15K rpm or 8
x 10K rpm (again SAS). In each case controlled by a PERC 5/i (which I
think is an LSI Mega Raid SAS 8408E
Does the one that ships in the installer not work?//Magnusit does work.*putting ashes on my head*Googled around and only found pgbench.c; never looked in program directory. Sorry, my mistake.
Harald-- GHUM Harald Massa
persuadere et programmareHarald Armin MassaReinsburgstraße 202b70197
Hello friends,
I am responsible for maintaining a high volume website using
postgresql
8.1.4. Given the amount of reads and writes, I vacuum full
the server a
few times a week around 1, 2 AM shutting down the site for a few
minutes. The next day morning around 10 - 11 AM the server
If I get the offshelf LSI Megaraid withe the same configuration? You
don't want to know... it will just make you want to cry at the fact
that
you bought a Dell.
I agree there's better platforms out there than Dell, but the above is
simply not true for the 2950. Raid 5, dd, on 6 disks, I get