I wanna buy one of this solid state drive and run only postgres on it.
I read that ssd have read/write limits... so the question is... should I buy it?

bump

I'm not a SSD expert, but then again, no one is yet - not the manufacturers, not any software or OS developers, no database experts, no one. There's still a lot of bugs and unknowns regarding performance, reliability, and the lifetime of them. Some of what is completely known, is that there is still a big gap between the theoretical performance and the actual real life performance, and that the cost per gig is very high compared to other alternatives.

Personally, I would spend the money on a hardware raid controller and several decent (Western Digital or Seagate) hard drives, giving you a ton of space, redundant backup, and proven performance gains across the board.

ty

A VelociRaptor can have higher WRITE speeds, but the SDD drive wins on:
-access time (0.1 ms vs 10 ms)
-read speeds
-I/O operations / s (the Intel X25-E is the big I/O winner of ALL SSDs, unfortunately that one is REALLY expensive)

And those three things just happen to have the biggest performance increase on a postgres database. If your database is small enough to fit on the (relatively expensive in price / GB) SSDs, buy one!

The only thing that stop me from buying one is the longevity... I read that sdd can support only few times (thousands) of write/rewrite process...

Anyway I found this

http://blogs.sun.com/jkshah/resource/pgeast_ssd.pdf