On Dec 5, 2007 3:13 AM, Robert Bernabe <robert_bernabe@xxxxxxxxx> wrote: > 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. speaking in very general terms, postgresql should be competitive with ms sql in this type of application. there are a few things here and there you have to watch out for...for example select count(*) from table is slower on pg. another common thing is certain query forms that you have to watch out for...but these issues are often addressed with small adjustments. the key here is to isolate specific things in your procedure that are underperforming and to determine the answer why. to get the most benefit from this list, try and post some particulars along with some 'explain analyze' results. merlin ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
