Re: [PERFORM] Partitioning: INSERT 0 0 but want INSERT 0 1

2008-05-12 Thread Neil Peter Braggio
I have the same problem in PG 8.2 To resolve this issue I had to create a new table with the same structure than the partitioned table with a trigger for insert and update. All the operations the application have to do are directed to this new table. When a new record is inserted in the new

[PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Francisco Reyes
Inheritted a number of servers and I am starting to look into the hardware. So far what I know from a few of the servers Redhat servers. 15K rpm disks, 12GB to 32GB of RAM. Adaptec 2120 SCSI controller (64MB of cache). The servers have mostly have 12 drives in RAID 10. We are going to redo one

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Joshua D. Drake
On Mon, 12 May 2008 22:04:03 -0400 Francisco Reyes [EMAIL PROTECTED] wrote: Inheritted a number of servers and I am starting to look into the hardware. So far what I know from a few of the servers Redhat servers. 15K rpm disks, 12GB to 32GB of RAM. Adaptec 2120 SCSI controller (64MB of

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Chris Ruprecht
Joshua, did you try to run the 345 on an IBM ServeRAID 6i? I have one in mine, but I never actually ran any speed test. Do you have any benchmarks that I could run and compare? best regards, chris -- chris ruprecht database grunt and bit pusher extraordinaíre On May 12, 2008, at 22:11,

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Joshua D. Drake
Chris Ruprecht wrote: Joshua, did you try to run the 345 on an IBM ServeRAID 6i? No the only controllers I had at the time were the 2120 and the LSI on board that is limited to RAID 1. I put the drives on the LSI in JBOD and used Linux software raid. The key identifier for me was using a

Re: [PERFORM] RAID controllers for Postgresql on large setups

2008-05-12 Thread Joshua D. Drake
Francisco Reyes wrote: Joshua D. Drake writes: Any PCI controller you have had good experience with? I don't have any PCI test data. How any other PCI-X/PCI-e controller that you have had good results?