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 an

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

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 bi

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