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