Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 86E522E0322 for ; Wed, 5 Dec 2007 05:06:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 55931-01 for ; Wed, 5 Dec 2007 05:06:40 -0400 (AST) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id 307002E0300 for ; Wed, 5 Dec 2007 05:06:38 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id f5so2636613nfh for ; Wed, 05 Dec 2007 01:06:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=/8QsJvNrRGU4xPyJuZ4iK/mSe69I0zzcgOmTPZrLtHo=; b=pAjwxGqiXvFPqUIOBr7z96x0hP+c3DoQRZ87Cs1etacpdAqXOHUN2PXddnoPa4IunPMXjNUm7/wEvzjRpeq3/j2G1P+EYvO0qLwnsmHIBakaDts2gaPZ4TqWkLzCNR+vple8dC/G4IvnmGh6vV+KACmrVOuuaOx108MgRX0cpFw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=NmEPE1ctVYJfLwwGgZzkJjquaOXiywJULQprmNvbD4wEYEiC5Vg8Ca/rQSfU+wRLln8uM2b7oJ5LrJYhBCx9QPPafW/M4uXEpRZALSwJKOw9vNAfqcoqGZJzKXycN3cDJep0IDRyOgV2WrdtmOXV9CvBvLtmQqR3ud7iYo8WD8k= Received: by 10.78.206.9 with SMTP id d9mr158116hug.1196845595765; Wed, 05 Dec 2007 01:06:35 -0800 (PST) Received: by 10.78.151.9 with HTTP; Wed, 5 Dec 2007 01:06:35 -0800 (PST) Message-ID: Date: Wed, 5 Dec 2007 14:06:35 +0500 From: "Usama Dar" To: "Robert Bernabe" Subject: Re: Evaluation of PG performance vs MSDE/MSSQL 2000 (not 2005) Cc: pgsql-performance@postgresql.org In-Reply-To: <37470.23740.qm@web51601.mail.re2.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_699_29655468.1196845595755" References: <37470.23740.qm@web51601.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/68 X-Sequence-Number: 27884 ------=_Part_699_29655468.1196845595755 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Dec 5, 2007 1:13 PM, Robert Bernabe wrote: > Anyways I'd like to break up this request/begging for help into two parts. > > 1) First would be settings of postgresql.conf. Did I do it correctly? The > sample data is so small....I based my settings on the recommendations > researched for data centers. > i think this would mainly depend on what do your stored procedures do, are they writing stuff to the tables, or reading most of the time or something else? i would imagine with small dataset the postgresql.conf settings should be ok, but more can be told after looking at the code. > > 2) Code optimization which I plan to start in another email thread since > the discussions there would be more detailed. > i think that might be a better starting point. What are you trying to do and how. > > > Would it also make sense to optimize (as far as possible) everything > (including the code) for windows first? The target here would be a linux OS > but since the discrepancy is so big...the unified Windows OS might be a good > place to start for now. > Sure, but i am not able to comprehend how the pl/pgsql could contain code which can tuned OS wise, i would think that any optimization you would do there in the stored code would apply to all platforms. > > > Many Thanks in advance. > > Regards > > > > -- Usama Munir Dar http://linkedin.com/in/usamadar Consultant Architect Cell:+92 321 5020666 Skype: usamadar ------=_Part_699_29655468.1196845595755 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On Dec 5, 2007 1:13 PM, Robert Bernabe <robert_bernabe@yahoo.com> wrote:
Anyways I'd like to break up this request/begging for help into two parts.

1) First would be settings of postgresql.conf. Did I do it correctly? The sample data is so small....I based my settings on the recommendations researched for data centers.

i think this would  mainly depend on what do your stored procedures do, are they writing stuff to the tables, or reading most of the time or something else? i would imagine with small dataset the postgresql.conf settings should be ok, but more can be told after looking at the code.



2) Code optimization which I plan to start in another email thread since the discussions there would be more detailed.

i think that might be a better starting point.  What are you trying to do and how.
 


Would it also make sense to optimize (as far as possible) everything (including the code) for windows first? The target here would be a linux OS but since the discrepancy is so big...the unified Windows OS might be a good place to start for now.

Sure, but i am not able to comprehend how the pl/pgsql could contain code which can tuned OS wise, i would think that any optimization you would do there in the stored code would apply to all platforms.


 


Many Thanks in advance.

Regards






--
Usama Munir Dar http://linkedin.com/in/usamadar
Consultant Architect
Cell:+92 321 5020666
Skype: usamadar
------=_Part_699_29655468.1196845595755--