"Steven Flatt" <steven(dot)flatt(at)gmail(dot)com> writes:
> Having said that, what kinds of things should I be looking for that could
> deteriorate/bloat over time? Ordinarily the culprit might be infrequent
> vacuuming or analyzing, but that wouldn't be corrected by a restart of
> Postgres. In our case, restarting Postgres gives us a huge performance
> improvement (for a short while, anyways).
Do you actually need to restart the postmaster, or is just starting a
fresh session (fresh backend) sufficient? And again, have you monitored
the backend process to see if it's bloating memory-wise or open-file-wise?
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2006-12-13 23:44:47|
|Subject: Re: Insertion to temp table deteriorating over time |
|Previous:||From: Tom Lane||Date: 2006-12-13 23:24:55|
|Subject: Re: strange query behavior |