Re: [PERFORM] Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD

2010-08-09 Thread Jeff Davis
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

Re: [PERFORM] Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD

2010-08-09 Thread Scott Carey
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

Re: [PERFORM] vacuum performance on insert

2010-08-09 Thread Kevin Grittner
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 --