Re: [PERFORM] Maximum Possible Insert Performance?

2003-11-28 Thread Suchandra Thapa
he maximum. For things like > heap storage or swap it's awful as you can get hot spots that get written to > thousands of times before the rest of the space is used. I could be wrong, but I was under the impression that most of the newer flash disks tended to spread writes out over the

Re: [PERFORM] performance optimzations

2003-11-12 Thread Suchandra Thapa
irly > cheap compared to ongoing maintenance of the 30+ drive system required > to get decent throughput. The current file system holding the user and email information indicates the current data has about 64GB (70K accounts, I'm not sure how many are active but 50% might be good gues

Re: [PERFORM] performance optimzations

2003-11-12 Thread Suchandra Thapa
On Wed, 2003-11-12 at 16:29, Neil Conway wrote: > Suchandra Thapa <[EMAIL PROTECTED]> writes: > > I was thinking using about using a raid 1+0 array to hold the > > database but since I can use different array types, would it be > > better to use 1+0 for the wal logs an

Re: [PERFORM] performance optimzations

2003-11-12 Thread Suchandra Thapa
On Wed, 2003-11-12 at 12:23, Rod Taylor wrote: > On Wed, 2003-11-12 at 12:34, Suchandra Thapa wrote: > > I'm moving a webmail service over to use a postgresql database for > > storage and wanted to get any tips for optimizing performance. The > > machine will be a mul

[PERFORM] performance optimzations

2003-11-12 Thread Suchandra Thapa
in in regards to the system's layout as well as how the applications will interact with the database since I'm writing the code. -- Suchandra Thapa <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part