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