Re: Limit clause not using index

From: Tobias Brox <tobias(at)nordicbet(dot)com>
To: John A Meinel <john(at)arbash-meinel(dot)com>
Cc: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Limit clause not using index
Date: 2005-06-21 19:46:39
Message-ID: 20050621194639.GG22746@oppetid.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

[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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Paul Ramsey 2005-06-21 19:59:22 Re: Querying 19million records very slowly
Previous Message Oliver Crosby 2005-06-21 19:46:03 Prepared statements vs. Stored Procedures