Re: Postgresql on windows / solid state

On 2010-11-23, Machiel Richards <machielr@rdc.co.za> wrote:


>                 What they would like to know is whether there is a
> performance degration from running PostgreSQL on Windows in comparison
> to Linux.

postgres was designed for posix so the lack of unix domain sockets and
fork() will slow it down a little.  the memory management system may
have an effect too.  filesystem differences may slso have a part to play

>                   Secondly, is it viable or worth it to look at Solid
> State drive as storage method instead of 15k sas disks for instance?
> What is the performance difference in this regard.

SSD will be mauch faster if the database is large enough to mostly
miss the disk cache.

--
⚂⚃ 100% natural