On Fri, 06 Jan 2012 08:51:24 +0100, Guillaume Lelarge wrote:
On Fri, 2012-01-06 at 07:12 +0100, Stefan Keller wrote:
Hi Igor
2011/12/16 Igor Neyman wrote: > But I
think,
your problem is right here:
>
> " running VACUUM FULL pg_largeobject"
>
> If you are running "VACUUM FULL ..." on the tabl
Stefan,
> -Original Message-
> From: Stefan Keller [mailto:sfkel...@gmail.com]
> Sent: Friday, January 06, 2012 1:12 AM
> To: Igor Neyman
> Cc: Simon Windsor; pgsql-general@postgresql.org
> Subject: Re: Vacuum and Large Objects
>
> Hi Igor
> 2011/12/16 Igor Neyman wrote: > But I think,
>
> -Original Message-
> From: Stefan Keller [mailto:sfkel...@gmail.com]
> Sent: Friday, January 06, 2012 1:12 AM
> To: Igor Neyman
> Cc: Simon Windsor; pgsql-general@postgresql.org
> Subject: Re: Vacuum and Large Objects
>
> Hi Igor
> 2011/12/16 Igor Neyman wrote: > But I think,
> your pro
On Fri, 2012-01-06 at 07:12 +0100, Stefan Keller wrote:
> Hi Igor
> 2011/12/16 Igor Neyman wrote: > But I think,
> your problem is right here:
> >
> > " running VACUUM FULL pg_largeobject"
> >
> > If you are running "VACUUM FULL ..." on the table, you should follow it
> > with the "REINDEX TABLE
Hi Igor
2011/12/16 Igor Neyman wrote: > But I think,
your problem is right here:
>
> " running VACUUM FULL pg_largeobject"
>
> If you are running "VACUUM FULL ..." on the table, you should follow it with
> the "REINDEX TABLE ...", at least on PG versions prior to 9.0.
I'm pretty sure that VACUU
From: Simon Windsor [mailto:simon.wind...@cornfield.me.uk]
Sent: Wednesday, December 14, 2011 3:02 PM
To: pgsql-general@postgresql.org
Subject: Vacuum and Large Objects
Hi
I am having problems recovering storage from a Postgres 9.05 database that is
used to hold large XML blocks for a week, bef
On 12/15/2011 04:01 AM, Simon Windsor wrote:
Hi
I am having problems recovering storage from a Postgres 9.05 database
that is used to hold large XML blocks for a week, before they are
archived off line.
The main tables are partitioned in daily partitions, and these are
easy to manage, howe
Hi
I am having problems recovering storage from a Postgres 9.05 database that
is used to hold large XML blocks for a week, before they are archived off
line.
The main tables are partitioned in daily partitions, and these are easy to
manage, however the DB keeps growing despite using Vacuum
