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 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 only options

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.conf.