RE: deleting old versions

What's the easiest way to re-index everything?


-----Original Message-----
From: slanninglocalhost.localdomain
[mailto:slanninglocalhost.localdomain] On Behalf Of Scott
Lanning
Sent: Wednesday, February 28, 2007 4:13 PM
To: userslists.bricolage.cc
Subject: Re: deleting old versions

On Wed, 28 Feb 2007, Scott Lanning wrote:
> On Tue, 27 Feb 2007, Scott Lanning wrote:
>> Anyone have a script/SQL for keeping only the last
N versions
>> of stories in the database?
>
> I take that as a 'no'.
> Attached is what I whipped up.
> DISCLAIMER: NO WARRANTY, NO GUARANTEE OF USEABILITY,
> it might hose your entire database, set the building on
fire,
> have unintended side-effects, etc.
> Backup your data. Test on a test machine.

Also I wanted to mention that you should probably
vacuum and reindex after doing this. (I assume...)

On Feb 28, 2007, at 13:55, Beaudet, David P. wrote:

> What's the easiest way to re-index everything?

   http://www.postgresql.org/docs/8.2/static/sql-reindex.
html

Best,

David