X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DFD42D1DC17 for ; Tue, 6 Apr 2004 11:42:19 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 66886-08 for ; Tue, 6 Apr 2004 11:43:04 -0300 (ADT) Received: from MXR-8.estpak.ee (ld1.estpak.ee [194.126.101.98]) by svr1.postgresql.org (Postfix) with ESMTP id A9604D1D9E6 for ; Tue, 6 Apr 2004 11:42:15 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by MXR-8.estpak.ee (Postfix) with ESMTP id 651302993B; Tue, 6 Apr 2004 17:43:03 +0300 (EEST) Received: from MXR-8.estpak.ee ([127.0.0.1]) by localhost (Relay8 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32755-03; Tue, 6 Apr 2004 17:43:03 +0300 (EEST) Received: from future.ee (80-235-33-83-dsl.mus.estpak.ee [80.235.33.83]) by MXR-8.estpak.ee (Postfix) with ESMTP id 3F6242992C; Tue, 6 Apr 2004 17:43:02 +0300 (EEST) Message-ID: <4072C209.1060902@future.ee> Date: Tue, 06 Apr 2004 17:43:21 +0300 From: Kaarel User-Agent: Mozilla Thunderbird 0.5+ (X11/20040220) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Heiko Kehlenbrink Cc: pgsql-performance@postgresql.org Subject: Re: performance comparission postgresql/ms-sql server References: <48932.195.243.253.146.1081179099.squirrel@webmail.fh-oldenburg.de> In-Reply-To: <48932.195.243.253.146.1081179099.squirrel@webmail.fh-oldenburg.de> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p7 (Debian) at neti.ee X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/62 X-Sequence-Number: 6362 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