Re: db grows and grows - Mailing list pgsql-general

From Fran Fabrizio
Subject Re: db grows and grows
Date
Msg-id 3D11D4CC.7070601@mmrd.com
Whole thread Raw
In response to Re: db grows and grows  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>
>
>A while ago I did post a script that did this, only it did the create first,
>then the drop and then renamed the new index to the old one. All within a
>transaction so other queries wouldn't be left without an index.
>
>It used pg_dump to get the CREATE INDEX command.
>
>Should be in the archive somewhere...
>
>
Any hints?  I'm not having much luck searching the archives for this
script.

Thanks,
Fran



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: how to evaluate a function only once for a query?
Next
From: Fran Fabrizio
Date:
Subject: Re: db grows and grows