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 jaequery on Tuesday November 13, 2012 @12:39PM (#4779292)
sad thing is, most people don't realize how slow they are. once they move off to dedicated w/ SSD, their site starts to run blazing fast (plus at a fraction of the cost) and say to themselves why they haven't done this sooner.
[ Parent | on HN ]
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 ]
Re:How Lanyrd moved from AWS to SoftLayer and MySQL to Postg... by gsibble on Tuesday November 13, 2012 @01:09PM (#4779495)
Indeed. Most companies don't have the operational experience to optimize for speed until they are later stage. Also, they will develop on something like Heroku and get addicted to the ease of use.
[ Parent | on HN ]