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$3@reversiblemaps.ath.cx (view raw or flat)
Thread:
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

Responses

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-2014 The PostgreSQL Global Development Group