News for hackers. Stuff that matters.

A comment on How Lanyrd moved from AWS to SoftLayer and MySQL to PostgreSQL with no downtime. Parent comment

Re:How Lanyrd moved from AWS to SoftLayer and MySQL to Postg... by joevandyk on Tuesday November 13, 2012 @05:09PM (#4780921)
Do SSDs improve performance with PostgreSQL if most of your data fits in ram?

I guess it depends on the type of workload (reads vs writes).

[ Parent | on HN ]
Re:How Lanyrd moved from AWS to SoftLayer and MySQL to Postg... by X-Istence on Tuesday November 13, 2012 @06:02PM (#4781130)
Yes, it improves performance because PostgreSQL wants to write data out to disk before returning.
[ Parent | on HN ]