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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
