Re: db grows and grows

From: Fran Fabrizio <ffabrizio(at)mmrd(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: "'PostgreSQL general list'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: db grows and grows
Date: 2002-06-20 13:12:44
Message-ID: 3D11D4CC.7070601@mmrd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-06-20 13:12:48 Re: how to evaluate a function only once for a query?
Previous Message Andrew Sullivan 2002-06-20 12:26:37 Re: db grows and grows