Typically my problem is that the large queries are simply CPU bound.. do you
have a sar/top output that you see. I'm currently setting up two FusionIO DUO
@640GB in a lvm stripe to do some testing with, I will publish the results
after I'm done.
If anyone has some tests/suggestions they would
How can you tell when your indexes are starting to get bloated and when you
need to rebuild them. I haven't seen a quick way to tell and not sure if it's
being tracked.
___
| John
6:09 AM
To: Scott Marlowe
Cc: Benjamin Krajmalnik; John W Strange; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Hardware recommendations
On Thu, Dec 9, 2010 at 04:28, Scott Marlowe wrote:
> On Wed, Dec 8, 2010 at 5:03 PM, Benjamin Krajmalnik
> wrote:
>> My biggest concern wi
Ben,
It would help if you could tell us a bit more about the read/write mix and
transaction requirements. *IF* you are heavy writes I would suggest moving off
the RAID1 configuration to a RAID10 setup. I would highly suggest looking at
SLC based solid state drives or if your budget has legs, l
