| From: | Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de> |
|---|---|
| To: | Ruben Rubio Rey <ruben(at)rentalia(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Posrgres speed problem - solved? |
| Date: | 2006-06-13 08:11:23 |
| Message-ID: | F4703D84-5BA7-44D6-B6F9-78C5D89CE76C@pharmaline.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 13.06.2006, at 8:44 Uhr, Ruben Rubio Rey wrote:
> Tonight database has been vacumm full and reindex (all nights
> database do it)
>
> Now its working fine. Speed is as spected. I ll be watching that
> sql ...
> Maybe the problem exists when database is busy, or maybe its
> solved ...
Depending on the usage pattern the nightly re-index / vacuum analyse
is suboptimal. If you have high insert/update traffic your
performance will decrease over the day and will only be good in the
morning hours and I hope this is not what you intend to have.
Autovacuum is the way to go, if you have "changing content". Perhaps
combined with vacuum analyse in a nightly or weekly schedule. We do
this weekly.
cug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ruben Rubio Rey | 2006-06-13 08:17:08 | Re: Posrgres speed problem - solved? |
| Previous Message | Ruben Rubio Rey | 2006-06-13 06:44:31 | Re: Posrgres speed problem - solved? |