Re: [PERFORM] Poor performance on HP Package Cluster

2005-09-04 Thread Ernst Einstein
Hi ! Sorry, for my late answer. I was unavailable for a few days... Yes, I'm using the build-in HP Smart Array Controller. Both, the internal disks, and the external storrage are using the controller. Can you send me your test results? I'm interested in it. I've done some testing now. I've

Re: [PERFORM] poor VACUUM performance on large tables

2005-09-04 Thread Thomas F. O'Connell
On Sep 4, 2005, at 1:16 AM, Jan Peterson wrote: Hello, We have been experiencing poor performance of VACUUM in our production database. Relevant details of our implementation are as follows: 1. We have a database that grows to about 100GB. 2. The database is a mixture of large and small ta

Re: [PERFORM] Poor performance on HP Package Cluster

2005-09-04 Thread Luke Lonergan
Title: Re: [PERFORM] Poor performance on HP Package Cluster Sure – I posted the excel spreadsheet to the list right after my message, but I think it blocks attachments.  I’ll send it to you now privately. I recommend switching to software RAID 10 or 5 using simple SCSI U320 adapter(s) from LSI

Re: [PERFORM] poor VACUUM performance on large tables

2005-09-04 Thread Tom Lane
Jan Peterson <[EMAIL PROTECTED]> writes: > We have been experiencing poor performance of VACUUM in our production > database. Which PG version, exactly? > Everything works great until our rolling delete kicks in. Of course, > we are doing periodic VACUUMS on all tables, with frequent VACUUMs on