EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de Stef
Enviado el: viernes, 23 de septiembre de 2005 14:18
Para: Bruno Wolff III
CC: Markus Benne; pgsql-performance@postgresql.org
Asunto: Re: [PERFORM] VACUUM FULL vs CLUSTER
Bruno Wolff III mentioned :
=> > => If you have a proper F
[EMAIL PROTECTED] (Stef) writes:
> Bruno Wolff III mentioned :
> => If you have a proper FSM setting you shouldn't need to do vacuum fulls
> => (unless you have an older version of postgres where index bloat might
> => be an issue).
>
> What version of postgres was the last version that had
> the i
Bruno Wolff III mentioned :
=> > => If you have a proper FSM setting you shouldn't need to do vacuum fulls
=> > => (unless you have an older version of postgres where index bloat might
=> > => be an issue).
Thanks Alvaro and Bruno
I just want to clarify something that I also couldn't
find a cle
On Fri, Sep 23, 2005 at 18:16:44 +0200,
Stef <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III mentioned :
> => If you have a proper FSM setting you shouldn't need to do vacuum fulls
> => (unless you have an older version of postgres where index bloat might
> => be an issue).
>
> What version of post
On Fri, Sep 23, 2005 at 06:16:44PM +0200, Stef wrote:
> Bruno Wolff III mentioned :
> => If you have a proper FSM setting you shouldn't need to do vacuum fulls
> => (unless you have an older version of postgres where index bloat might
> => be an issue).
>
> What version of postgres was the last ve
Bruno Wolff III mentioned :
=> If you have a proper FSM setting you shouldn't need to do vacuum fulls
=> (unless you have an older version of postgres where index bloat might
=> be an issue).
What version of postgres was the last version that had
the index bloat problem?
-
On Tue, Sep 20, 2005 at 14:53:19 -0400,
Markus Benne <[EMAIL PROTECTED]> wrote:
> I have a table that is purged by 25% each night. I'd like to do a
> vacuum nightly after the purge to reclaim the space, but I think I'll
> still need to do a vacuum full weekly.
>
> Would there be any benefit to