Skip site navigation (1) Skip section navigation (2)

Re: Postgresql on windows / solid state

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgresql on windows / solid state
Date: 2010-11-25 01:48:25
Message-ID: ickf99$lia$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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. BarbierDate: 2010-11-25 01:54:43
Subject: Re: Postgresql on windows / solid state
Previous:From: Jasen BettsDate: 2010-11-25 01:40:10
Subject: Re: Multi-row insert using a Function

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group