[PERFORM] Optimizing a VIEW

2008-08-15 Thread Madison Kelly
Hi all, I've got a simple table with a lot of data in it: CREATE TABLE customer_data ( cd_id int primary key default(nextval('cd_seq')), cd_cust_id int not null, cd_variable textnot

Re: [PERFORM] file system and raid performance

2008-08-15 Thread Bruce Momjian
Mark Wong wrote: On Mon, Aug 4, 2008 at 10:04 PM, [EMAIL PROTECTED] wrote: On Mon, 4 Aug 2008, Mark Wong wrote: Hi all, We've thrown together some results from simple i/o tests on Linux comparing various file systems, hardware and software raid with a little bit of volume

Re: [PERFORM] file system and raid performance

2008-08-15 Thread Mark Wong
On Fri, Aug 15, 2008 at 12:22 PM, Bruce Momjian [EMAIL PROTECTED] wrote: Mark Wong wrote: On Mon, Aug 4, 2008 at 10:04 PM, [EMAIL PROTECTED] wrote: On Mon, 4 Aug 2008, Mark Wong wrote: Hi all, We've thrown together some results from simple i/o tests on Linux comparing various file

Re: [PERFORM] file system and raid performance

2008-08-15 Thread Greg Smith
On Fri, 15 Aug 2008, Bruce Momjian wrote: 'data=writeback' is the recommended mount method for that file system, though I see that is not mentioned in our official documentation. While writeback has good performance characteristics, I don't know that I'd go so far as to support making that