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
In response to
pgsql-novice by date
|Next:||From: Jean-Yves F. Barbier||Date: 2010-11-25 01:54:43|
|Subject: Re: Postgresql on windows / solid state|
|Previous:||From: Jasen Betts||Date: 2010-11-25 01:40:10|
|Subject: Re: Multi-row insert using a Function|