Skip site navigation (1) Skip section navigation (2)

Re: un-vacuum?

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: uwcssa <uwcssa(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: un-vacuum?
Date: 2006-01-19 19:33:45
Message-ID: c2d9e70e0601191133n342ed76crba73e80f59093f38@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 1/19/06, uwcssa <uwcssa(at)gmail(dot)com> wrote:
> I have a simple question here, not sure if i should posted here but
> if you have the quick answer, it helps a lot
>
> i have a table that is already "vacuum"ed.  for some reason i want
> to un-vacuum it instead of dropping the table and recreate the table
> and indexes on it.  is there a existing command to do so?
>

can you explain yourself a bit better?
vacuum is good, why do you think you want to undo it?
why do you think that drop and create will undo vacuum?

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2006-01-19 19:35:15
Subject: Re: un-vacuum?
Previous:From: Michael FuhrDate: 2006-01-19 19:33:05
Subject: Re: un-vacuum?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group