Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group