On Thu, Jan 19, 2006 at 02:25:15PM -0500, uwcssa wrote:
i have a table that is already vacuumed. 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?
What effect do you want this un-vacuum to
On 1/19/06, uwcssa [EMAIL PROTECTED] 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 vacuumed. for some reason i want
to un-vacuum it instead of dropping the table and recreate the table
Ühel kenal päeval, N, 2006-01-19 kell 14:25, kirjutas uwcssa:
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 vacuumed. for some reason i want
to un-vacuum it instead of dropping the table and
Michael Fuhr [EMAIL PROTECTED] writes:
On Thu, Jan 19, 2006 at 03:54:33PM -0500, uwcssa wrote:
I want to do this for repeating some experiment results, not for
tuning the db (pretty much like using an old machine to find
performance difference for an algorithm). so if i have a way
of
I want to do this for repeating some experiment results, not for
tuning the db (pretty much like using an old machine to find
performance difference for an algorithm). so if i have a way
of knowing which tables are storing the statistics, i guess i can
delete all from that table to archieve
On Thu, Jan 19, 2006 at 03:54:33PM -0500, uwcssa wrote:
I want to do this for repeating some experiment results, not for
tuning the db (pretty much like using an old machine to find
performance difference for an algorithm). so if i have a way
of knowing which tables are storing the
On Thu, 2006-01-19 at 14:25 -0500, uwcssa 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 vacuumed. for some reason i want
to un-vacuum it instead of dropping the table and recreate the
You could also do this by doing a filesystem copy of $PG_DATA (with
postgresql shut down), and then restoring that copy after your test. If
you used rsync (or something that allowed filesystem snapshots) this
probably wouldn't be very painful.
On Thu, Jan 19, 2006 at 03:54:33PM -0500, uwcssa
On Thu, Jan 19, 2006 at 04:54:21PM -0600, Jim C. Nasby wrote:
You could also do this by doing a filesystem copy of $PG_DATA (with
postgresql shut down), and then restoring that copy after your test. If
you used rsync (or something that allowed filesystem snapshots) this
probably wouldn't be