Re: Evaluation of PG performance vs MSDE/MSSQL 2000 (not 2005) - Mailing list pgsql-performance

From Usama Dar
Subject Re: Evaluation of PG performance vs MSDE/MSSQL 2000 (not 2005)
Date
Msg-id ff0e67090712050106nff91020q35d97ef08a7b9783@mail.gmail.com
Whole thread Raw
In response to Evaluation of PG performance vs MSDE/MSSQL 2000 (not 2005)  (Robert Bernabe <robert_bernabe@yahoo.com>)
List pgsql-performance


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

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Bad query plans for queries on partitioned table
Next
From: Julian Mehnle
Date:
Subject: Re: Bad query plans for queries on partitioned table