Re: Performance

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Donald Laurine <Donald(dot)Laurine(at)noaa(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance
Date: 2007-05-23 19:50:06
Message-ID: 46549AEE.4020804@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

  • Performance at 2007-05-23 17:12:09 from Donald Laurine

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2007-05-23 19:59:44 Re: Need software infrastructure advice
Previous Message Maciej Wawrzynczuk 2007-05-23 19:45:44 server side LO