thank you, it is a great article.
the current on 8.1 checkpoint_segments = 3.
it looks too low for me , but I'm not tuning the 8.1 schema.
I'm looking for a generic approach of improving that beast while moving it
to 8.4
I'm trying to understand the internals for Views vs. Functions
there was none on 8.1 and I'm using pgpsql for 8.4.
Does it make sence to put view's sql into a function? would it save on
re-creating the execution plan and parsing?
thank you.
Helen
--
View this message in context: http://postgresql.1045698.n5.nabble.com/tunning-strategy-needed-tp4710245p4717048.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.