On Dec 5, 2007 1:13 PM, Robert Bernabe <robert_bernabe@xxxxxxxxx> wrote:
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.
i think that might be a better starting point. What are you trying to do and how.
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.
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
