4 ms·
I think the form of the blog post (pretty much just short bullet points) makes it rather difficult to get an idea of what's the intended takeaway. I do share y
by pgaddict 11y ago
I think the form of the blog post (pretty much just short bullet points) makes it rather difficult to get an idea of what's the intended takeaway.
I do share your conclusion that SSDs are very good value for workloads that need to do a lot of random I/O.
Regarding the best config for PostgreSQL, it really depends on the hardware. If you really want to use boxes with just 2GB of RAM, use smaller shared buffers and let the page cache do the rest.
If you need more help with tuning PostgreSQL for the benchmark later, either ping me at tomas(at)pgaddict.com or join pgsql-performance@postgresql.org (I do occasionally lurk there, but others will surely help too).
- jgord 11y agoyeah.. I started with bullets as a draft, intending to expand into prose, but it seemed borderline readable, so I thought Id leave it as an exercise in blogging. awesome, thanks Thomas - Ill check out your blog too.