From: Usama Dar <munir.usama@gmail.com>
To: Robert Bernabe <robert_bernabe@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Evaluation of PG performance vs MSDE/MSSQL 2000 (not 2005)
Date: Wed, 5 Dec 2007 14:06:35 +0500
Message-ID: <ff0e67090712050106nff91020q35d97ef08a7b9783@mail.gmail.com> (raw)
In-Reply-To: <37470.23740.qm@web51601.mail.re2.yahoo.com>
References: <37470.23740.qm@web51601.mail.re2.yahoo.com>
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
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: munir.usama@gmail.com, robert_bernabe@yahoo.com
Subject: Re: Evaluation of PG performance vs MSDE/MSSQL 2000 (not 2005)
In-Reply-To: <ff0e67090712050106nff91020q35d97ef08a7b9783@mail.gmail.com>
* 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