pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Ruben Rubio Rey <ruben@rentalia.com>
To: Guido Neitzer <guido.neitzer@pharmaline.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Posrgres speed problem - solved?
Date: Tue, 13 Jun 2006 10:17:08 +0200
Message-ID: <448E7484.2020100@rentalia.com> (raw)
In-Reply-To: <F4703D84-5BA7-44D6-B6F9-78C5D89CE76C@pharmaline.de>
References: <448D7C81.1000108@rentalia.com>
	<448D8940.4050209@aeccom.com>
	<448E5ECF.5090100@rentalia.com>
	<F4703D84-5BA7-44D6-B6F9-78C5D89CE76C@pharmaline.de>

Guido Neitzer wrote:

> 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
>
>
I ll configure autovacum. I ll write if problem is solved.

view thread (5+ messages)  latest in thread

Message-ID: <448E7484.2020100@rentalia.com>
Permalink:  ../448E7484.2020100@rentalia.com/
Also on:    postgresql.org/message-id/448E7484.2020100@rentalia.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ruben@rentalia.com, guido.neitzer@pharmaline.de
  Subject: Re: Posrgres speed problem - solved?
  In-Reply-To: <448E7484.2020100@rentalia.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox