| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Daniel Ferreira de Lima <dfl(dot)man(at)gmail(dot)com> |
| Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem |
| Date: | 2010-07-19 14:38:21 |
| Message-ID: | 4C44635D.7080601@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Daniel Ferreira de Lima wrote:
>
>
>
> > **Both with Linux Kernel 2 .4.37.9 and Postgresql 7.2**
>
> Wow. You really need to upgrade.
>
>
> Yes, but unfortunately, actually it's impossible and economically
> inviable...
Generally, getting good performance out of PostgreSQL 7.2 is also
impossible and economically inviable. You can either put resources
toward upgrading to a newer version, which will fix many of the
performance issues here, or toward changes to the old version that are
not guaranteed to actually improve anything.
That said, a look into the write-caching+BBU policy on your controller
is worthwhile. If you're running this application successfully on some
hardware but not others, that could be a source for the difference.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Voras | 2010-07-19 15:09:32 | Big field, limiting and ordering |
| Previous Message | Daniel Ferreira de Lima | 2010-07-19 14:20:17 | Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem |