By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,983 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,983 IT Pros & Developers. It's quick & easy.

performance tuning postgres 8.2.3 on windows with shared server applications

P: 2
Hi, we have recently migrated from MySQL to PostgreSQL as our embedded database. We are running into several performance issues compared to MySQL. I tried referring several sites and forums but, most of them provide tips only for postgres installed on a dedicated system. Any help on where to start to look for solutions would be greatly appreciated.
Thanks in advance,
Nirmal R.
Apr 4 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 534
Hi, Nirmal.
There are too many things involved in performance, from the little information you posted I cannot even begin to speculate how to improve performance for your application(s)

Here are few links, all have to do with performance, but some may be more helpful than others in your case.
I think if you review these docs you might be able to get some answers and narrow down your search...

http://www.postgresql.org/docs/curre...ance-tips.html
http://www.postgresql.org/docs/8.1/s...l-explain.html
http://www.postgresql.org/docs/8.1/s...-resource.html

http://www.revsys.com/writings/postg...rformance.html

These two are little old, take a look, but watch for potentially obsolete information.
http://www.varlena.com/GeneralBits/33.html
http://www.varlena.com/varlena/Gener...bits/perf.html

Let us know whether you get anything helpful from this.
Apr 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.