Postgres Pro
Downloads
Home   >   mailing lists

Re: Limit clause not using index - Mailing list pgsql-performance

From Tobias Brox
Subject Re: Limit clause not using index
Date
Msg-id 20050621194639.GG22746@oppetid.no
Whole thread Raw
In response to Re: Limit clause not using index  (John A Meinel <john@arbash-meinel.com>)
Responses Re: Limit clause not using index
Re: Limit clause not using index
List pgsql-performance
Tree view 
[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

pgsql-performance by date:

Previous
From: Yves Vindevogel
Date:
Subject: Re: Another question on indexes (drop and recreate)
Next
From: Oliver Crosby
Date:
Subject: Prepared statements vs. Stored Procedures