I have an old application that was written on Postgres 8.1.
There are a few hundreds tables, 30-40 columns per table, hundreds of
views, and all the sql is inside java code.
We are moving it to 8.4, it seems to be VERY slow.
There are 20-30 tables transactions - the objects are spread acrross
multiple tables and some tables have data from different objects.
I need a short term tuning strategy minimizing rewrite & redesign.
Should I start with replacing the sql with procedures?
Should I start with replacing the views with the procedures to save time on
recreating an execution plan and parsing?
Should I start with tuning server parameters ?
all your suggestions are greatly appreciated!
View this message in context: http://postgresql.1045698.n5.nabble.com/tunning-strategy-needed-tp4710245p4710245.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.