Re: [GENERAL] Intel SSD

2009-02-11 Thread Merlin Moncure
On Tue, Feb 10, 2009 at 9:24 PM, Sebastian Böhm wrote: > I consider buying one of these Intel SSDs for my Database (MLC). > > I have a few questions regarding this, maybe some of you already have some > experience with that. > > - which files should not be put onto the SSD (pg_clog ? pg_xlog ? ) t

Re: [GENERAL] Intel SSD

2009-02-10 Thread Scott Marlowe
On Tue, Feb 10, 2009 at 11:55 PM, John R Pierce wrote: > Sebastian Böhm wrote: >> >> I consider buying one of these Intel SSDs for my Database (MLC). >> . >> currently I have a lot of small random reads/writes causing heavy iowait. > > how many r/s and w/s in `iostat -x 5` while your database

Re: [GENERAL] Intel SSD

2009-02-10 Thread John R Pierce
Sebastian Böhm wrote: I consider buying one of these Intel SSDs for my Database (MLC). . currently I have a lot of small random reads/writes causing heavy iowait. how many r/s and w/s in `iostat -x 5` while your database is humming are you seeing now?Thats the single key performance fa

[GENERAL] Intel SSD

2009-02-10 Thread Sebastian Böhm
Hi, I consider buying one of these Intel SSDs for my Database (MLC). I have a few questions regarding this, maybe some of you already have some experience with that. - which files should not be put onto the SSD (pg_clog ? pg_xlog ? ) to reduce wear (which may be an issue with the MLC varia