On Tue, Apr 19, 2011 at 9:48 AM, Jens Wilke wrote:
> On Tue, Apr 19, 2011 at 04:02:01AM +0530, Vibhor Kumar wrote:
>
> > > IIRC "vacuum full" mode rewrites the indexes as well.
> >
> > Till 8.4 no. From 9.0 onwards yes. However VACUUM FULL still locks the
> table.
>
> Don't be confused with the "
On Tue, Apr 19, 2011 at 8:48 AM, Jens Wilke wrote:
> On Tue, Apr 19, 2011 at 04:02:01AM +0530, Vibhor Kumar wrote:
>
>> > IIRC "vacuum full" mode rewrites the indexes as well.
>>
>> Till 8.4 no. From 9.0 onwards yes. However VACUUM FULL still locks the table.
>
> Don't be confused with the "vacuum
On Tue, Apr 19, 2011 at 04:02:01AM +0530, Vibhor Kumar wrote:
> > IIRC "vacuum full" mode rewrites the indexes as well.
>
> Till 8.4 no. From 9.0 onwards yes. However VACUUM FULL still locks the table.
Don't be confused with the "vacuum full" term.
This has nothing to do with the postgresql "vac
On Apr 19, 2011, at 3:40 AM, Jens Wilke wrote:
> yes, we used it to reduce massive bloat after a database split and
> were very satisfied.
> IIRC "vacuum full" mode rewrites the indexes as well.
Till 8.4 no. From 9.0 onwards yes. However VACUUM FULL still locks the table.
> There's a proposal
On Montag, 18. April 2011, Scott Mead wrote:
> I've seen it, but catalog hacks always make me nervous. Anybody
> else have good / bad experience to share?
Hi,
yes, we used it to reduce massive bloat after a database split and
were very satisfied.
IIRC "vacuum full" mode rewrites the indexes as
On Apr 19, 2011, at 2:29 AM, Raghavendra wrote:
>
> I've seen it, but catalog hacks always make me nervous. Anybody else have
> good / bad experience to share?
>
> --scott
>
>
> It is observed, double the space required for this utility.
I have used it many times. Yes it requires double sp
>
>
> I've seen it, but catalog hacks always make me nervous. Anybody else have
> good / bad experience to share?
>
> --scott
>
>
It is observed, double the space required for this utility.
Eg:-
If the database is 4 gig, there should be 8gigs space.
Best Regards,
Raghavendra
EnterpriseDB Corpora
On Mon, Apr 18, 2011 at 4:39 PM, Merlin Moncure wrote:
> ...is an amazing tool!
>
>
I've seen it, but catalog hacks always make me nervous. Anybody else have
good / bad experience to share?
--scott
> merlin
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make
