Josh,

Thanks for your feedback, I appreciate it.

Check what I have to say at http://www.powerpostgresql.com/PerfList


Will do.

They're currently on a two-disk Adaptec RAID1 with Postgresql 7.4.2.



And you've not upgraded to 7.4.6 because .... ?



Because the proprietary application running the business has not certified on it. Unfortunately, I am at the mercy of their support in case something goes wrong.

The drive array is a 7-disk fibre channel on a Qlogic 2100 controller. I
am currently testing RAID5 (sw).



In general, RAID 5 is not so great for databases. See the article for more.



Okay, thanks. Even with 7-disks? I trust that. So, RAID 1+0 (sw) is probably the best option. I've run sw RAID personally for years without issue. I am a bit hesitant in doing sw RAID for a production server for a database --- probably because its not my server. Any thoughts on sw RAID for Postgresql?

The main reason of moving to a drive array is the high level of context
switches we get during the day (>30K for 20 mins per hour). The OS and
database exist on the same disk but seperate parition (which probably
makes little difference)



Unfortunately, the context switches are probably due to a known issue in PostgreSQL, and changing the drive array won't help this issue (it may help other issues though). Search the archives of this list, and pgsql-hackers, for "Context Switch Bug".


For the CS bug, the only workaround right now is to avoid the query structures that trigger it.


Okay. Darn. While I don't write the queries for the application, I do interact with the company frequently. Their considering moving the queries into the database with PL/pgSQL. Currently their queries are done through ProvIV development using ODBC. Will context switching be minimized here by using PL/pgSQL?



Server Info:
Centos 3.3 (RHEL 3.x equivelent)
4GB RAM
Adaptec 2100S RAID
Qlogic QLA2100 Fibre



CPU?


Dual Xeon 2.8 CPUs with HT turned off.


Thanks again.

Steve Poe

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to