| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | 赖文豫 <xiaolai913(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: By now, why PostgreSQL 9.2 don't support SSDs? |
| Date: | 2013-03-30 14:31:12 |
| Message-ID: | 20130330143112.GC12134@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Mar 30, 2013 at 10:08:44PM +0800, 赖文豫 wrote:
> As we know, SSDs are widely used in various kinds of applications. But the SMGR
> in PostgreSQL still only
> support magnetic disk. How do we make full use of SSDs to improve the
> performance of PostgreSQL?
When the storage manager (SMGR) says magnetic disk, it is talking about
read/write media with random access capabillity, vs. something like
write-only media, which was originally supported in the code. Postgres
works just fine with SSDs; the only adjustment you might want to make
is to reduce random_page_cost.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2013-03-30 16:06:33 | Re: Cube extension improvement, GSoC |
| Previous Message | 赖文豫 | 2013-03-30 14:08:44 | By now, why PostgreSQL 9.2 don't support SSDs? |