Re: [PERFORM] Reliability recommendations

2006-02-25 Thread Ron
At 11:41 PM 2/24/2006, Luke Lonergan wrote: Dan, On 2/24/06 4:47 PM, "Dan Gorman" <[EMAIL PROTECTED]> wrote: > Was that sequential reads? If so, yeah you'll get 110MB/s? How big > was the datafile size? 8MB? Yeah, you'll get 110MB/s. 2GB? No, they > can't sustain that. There are so many details

Re: [PERFORM] Reliability recommendations

2006-02-25 Thread Ron
At 01:22 AM 2/25/2006, Luke Lonergan wrote: Mark, On 2/24/06 10:10 PM, "Mark Kirkwood" <[EMAIL PROTECTED]> wrote: > Well, since this is always fun (2G memory, 3Ware 7506, 4xPATA), writing: > > $ dd if=/dev/zero of=/data0/dump/bigfile bs=8k count=50 > 50 records in > 50 records out >

Re: [PERFORM] Reliability recommendations

2006-02-25 Thread Luke Lonergan
Ron, On 2/25/06 3:24 AM, "Ron" <[EMAIL PROTECTED]> wrote: >> These are each RAID5 arrays of 8 internal SATA disks on 3Ware HW RAID >> controllers. > > Impressive IO rates. A more detailed HW list would help put them in context. > > Which 3Ware? The 9550SX? How much cache on it (AFAIK, the on

Re: [PERFORM] Schema vs Independant Databases, ACLS,Overhead,pg_hba.conf

2006-02-25 Thread Alvaro Herrera
Eric Lauzon wrote: Hi, > Now that the issue is that we can't implement a per connection user/ACL > pair , would it be a good idea to implement > Schema ACLS and mabey pg_hba.conf Schema acls This is certainly possible to do using GRANT and REVOKE on the schemas; no need to fool with pg_hba.con