Date: Wed, 17 Aug 2011 15:40:11 -0700 (PDT)
From: hyelluas <helen_yelluas@mcafee.com>
To: pgsql-performance@postgresql.org
Message-ID: <1313620811606-4710245.post@n5.nabble.com>
Subject: tunning strategy needed
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello,

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!

thank you.

Helen

--
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.