On Mon, 2010-08-09 at 09:49 -0700, Scott Carey wrote:
> Also, the amount of data at risk in a power loss varies between
> drives. For Intel's drives, its a small chunk of data ( < 256K). For
> some other drives, the cache can be over 30MB of outstanding writes.
> For some workloads this is accept
On Aug 7, 2010, at 11:49 PM, Michael March wrote:
SSD's actually vary quite a bit with typical postgres benchmark workloads.
You mean various SSDs from different vendors? Or are you saying the same SSD
model might vary in performance from drive to drive?
Model to model (more specifically, con
Sean Chen wrote:
> Now from what you mentioned below, do you know what's the cost of
> postgres requesting new disk space from OS?
Depending on your OS and its version, your file system, your mount
options, and your disk subsystem (and its firmware revision), there
could be various effects --