[John A Meinel - Tue at 10:14:24AM -0500]
> I believe if you drop the indexes inside a transaction, they will still
> be there for other queries, and if you rollback instead of commit, you
> won't lose anything.
Has anyone tested this?
(sorry, I only have the production database to play with at the moment,
and I don't think I should play with it ;-)
Tobias Brox, Beijing
In response to
pgsql-performance by date
|Next:||From: Paul Ramsey||Date: 2005-06-21 19:59:22|
|Subject: Re: Querying 19million records very slowly|
|Previous:||From: Oliver Crosby||Date: 2005-06-21 19:46:03|
|Subject: Prepared statements vs. Stored Procedures|