On 2010-11-23, Machiel Richards <machielr(at)rdc(dot)co(dot)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