On Mar 30, 2013 7:13 PM, "Satoshi Nagayasu" wrote:
> But I heard that larger block size, like 256kB, would take
> advantage of the SSD performance because of the block management
> within SSD.
This is only true for very bad SSDs. Any SSD that you would want to trust
with your data do block remapp
2013/03/30 23:31, Bruce Momjian wrote:
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?
Andrew Dunstan writes:
> This isn't the first time I've seen this sort of comment. Do we need to
> add some wording like the above to the top of md.c and the README in
> that directory?
Yeah, probably. I'll go write something ...
regards, tom lane
--
Sent via pgsql-
On 03/30/2013 12:28 PM, Tom Lane wrote:
Bruce Momjian writes:
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 t
Bruce Momjian writes:
> 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 PostgreS
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)
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?
--
Just do it!