Donald Laurine wrote:
My question is on Postgres performance. I have three systems all running
the same database and have the same data feed. One the of the systems is
running 7.4.8 and the other two are at 8.1.4 They all run under Linux.
The type of machines are not really important to my question, since I am
not comparing the performance of each machine. All three machines have
been tuned. Logs do not indicate any problems
The total size of the database is about 500M+ in size. There are several
large tables which are 9M in size. These large tables add and delete
about 200K rows per day. The total database size has not varied by much
over the past two years.
Now my question. The performance of each of these databases is
decreasing. I measure the average insert time to the database. This
metric has decreased by about 300 percent over the last year. I run
vacuum analyze and vacuum analyze full on a daily bases. I also run
vacuum 4 time a day. Still the performance continues to drop. Are there
some other performance activities I may try?. Are there other monitoring
options I can use to indicate where the slow down is occurring?
sure... :), default_statistics_target. If it is too low, your estimates
might be off and the planner might be choosing the wrong plan.
Joshua D. Drake
Thanks Don
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
