pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kaarel <kaarel@future.ee>
To: Heiko Kehlenbrink <Heiko.Kehlenbrink@vermes.fh-oldenburg.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: performance comparission postgresql/ms-sql server
Date: Tue, 06 Apr 2004 17:43:21 +0300
Message-ID: <4072C209.1060902@future.ee> (raw)
In-Reply-To: <48932.195.243.253.146.1081179099.squirrel@webmail.fh-oldenburg.de>
References: <48932.195.243.253.146.1081179099.squirrel@webmail.fh-oldenburg.de>

Heiko Kehlenbrink wrote:

>i want to convince people to use postgresql instead of ms-sql server, so i
>set up a kind of comparission insert data / select data from postgresql /
>ms-sql server
>  
>
[...]

>do you have any hints like compiler-flags and so on to get the answering
>time from postgresql equal to ms-sql?
>
>(btw both dbms were running on exactly the same hardware)
>
>i use suse 8.1
>      postgresql 7.2 compiled from the rpms for using postgis, but that is
>anothe story...
>      1.5 gig ram
>      1.8 mhz intel cpu
>
>
>every help welcome
>  
>
Suse 8.1 comes with 2.4 series kernel I suppose. Many have witnessed a 
speed increase when using 2.6 series kernel. Might consider this too 
besides the newer PostgreSQL version already suggested. 2.6 has some 
scheduling options that are not enabled by default but may enhance 
database performance 
(http://story.news.yahoo.com/news?tmpl=story&cid=75&e=2&u=/nf/20040405/tc_nf/23603).

Kaarel



view thread (9+ messages)  latest in thread

Message-ID: <4072C209.1060902@future.ee>
Permalink:  ../4072C209.1060902@future.ee/
Also on:    postgresql.org/message-id/4072C209.1060902@future.ee

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: kaarel@future.ee, Heiko.Kehlenbrink@vermes.fh-oldenburg.de
  Subject: Re: performance comparission postgresql/ms-sql server
  In-Reply-To: <4072C209.1060902@future.ee>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox