Re: [PERFORM] ideal storage configuration

2010-06-30 Thread Greg Smith
Samuel Gendler wrote: 6 internal drives on battery backed raid (I don't know what RAID level - is there a way to discover this?), all in a single filesystem, so WAL and data are on the same filesystem. I don't believe that we are taking advantage of the battery backed controller, since I only se

Re: [PERFORM] ideal storage configuration

2010-06-30 Thread Matthew Wakeling
On Tue, 29 Jun 2010, Samuel Gendler wrote: The copy statements execute in a small fraction of the minute in which they occur. I'm going to ask a silly question here. If the system is already coping quite well with the load, then why are you changing it? All old data gets removed by dropping

Re: [PERFORM] ideal storage configuration

2010-06-29 Thread Kevin Grittner
Samuel Gendler wrote: > queries are definitely taking longer than we'd like them to > Database currently occupies 91GB on disk. > I get no resistance when I suggest going to 64GB of RAM. One thing that jumps out at me is that with a 91GB database, and no pushback on buying 64GB of RAM, it

[PERFORM] ideal storage configuration

2010-06-29 Thread Samuel Gendler
I've been reading this list for a couple of weeks, so I've got some sense of what you folks are likely to recommend, but I'm curious what is considered an ideal storage solution if building a database system from scratch. I just got an exploratory call from my boss, asking what my preference would