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
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 ac
Igor,
Thank you for the hint, I read about the planner, added "vacuum analyze " to
my procedures.
There is no join in my query but GROUP BY that is taking all the time and I
don't know how to tune it.
It gets executed by the procedure, the execution time requirement is < 4
sec,
but it takes 8-11
Igor,
thank you , my tests showed better performance against the larger summary
tables when I splited the index for datasource_id & datex , I use to have a
composed index.
Regarding that index statistics - should I analyze the tables? I thought
auto vacuum takes care of it.
helen
--
View this
Hello,
I need to compare quiery execution : I have 2 tables partitioned by Datex (
daily):
summary_daily (
counter | bigint
datasource_id| integer
application_id | integer
action | character(1)
srcreporter_id | integer
destreporter_id | integer
b
