Re: [PERFORM] Multiple insert performance trick or performance misunderstanding?

2005-09-24 Thread Tom Lane
Ron Mayer <[EMAIL PROTECTED]> writes: > Is it expected that I'd be better off sending big > concatenated strings like >"insert into tbl (c1,c2) values (v1,v2);insert into tbl (c1,c2) values > (v3,v4);..." > instead of sending them one at a time? It's certainly possible, if the network round t

[PERFORM] Multiple insert performance trick or performance misunderstanding?

2005-09-24 Thread Ron Mayer
When I need to insert a few hundred or thousand things in a table from a 3-tier application, it seems I'm much better off creating a big string of semicolon separated insert statements rather than sending them one at a time - even when I use the obvious things like wrapping the statements in a tra

Re: [PERFORM] Advice on RAID card

2005-09-24 Thread PFC
It looks like a rebranded low end Adaptec 64MB PCI-X <-> SATA RAID card. Looks like the 64MB buffer is not upgradable. Looks like it's SATA, not SATA II Yeah, that's exactly what it is. I can get one for 150 Euro, the Areca is at least 600. This is for a budget server so while it would be n

Re: [PERFORM] Advice on RAID card

2005-09-24 Thread Ron Peacetree
It looks like a rebranded low end Adaptec 64MB PCI-X <-> SATA RAID card. Looks like the 64MB buffer is not upgradable. Looks like it's SATA, not SATA II There are much better ways to spend your money. These are the products with the current best price/performance ratio: http://www.areca.us/produc

Re: [HACKERS] [PERFORM] Releasing memory during External sorting?

2005-09-24 Thread Ron Peacetree
From: Dann Corbit <[EMAIL PROTECTED]> Sent: Sep 23, 2005 5:38 PM Subject: RE: [HACKERS] [PERFORM] Releasing memory during External sorting? >_C Unleashed_ also explains how to use a callback function to perform >arbitrary radix sorts (you simply need a method that returns the >[bucketsize] most si

[PERFORM] Advice on RAID card

2005-09-24 Thread PFC
Hello fellow Postgresql'ers. I've been stumbled on this RAID card which looks nice. It is a PCI-X SATA Raid card with 6 channels, and does RAID 0,1,5,10,50. It is a HP card with an Adaptec chip on it, and 64 MB cache. HP Part # : 372953-B21 Adaptec Part # :