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 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 statistics, i guess i can
> delete all from that table to archieve this.
>
>
> > On 1/19/06, Hannu Krosing <hannu@skype.net> wrote:
> > > ?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 "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?
> > >
> > > What exactly are you tryingto achieve ?
> > >
> > > -------------
> > > Hannu
> > >
> > >
> > >
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461