On Sat, Jun 7, 2008 at 8:05 AM, Viktor Rosenfeld <[EMAIL PROTECTED]> wrote: > Hi, > > I'm experimenting with different indexes to speed up my queries and I was > wondering if it is possible to temporarily deactivate an index, so it won't > be considered in the evaluation of query plans. The reason is that dropping > and then rebuilding an index takes up time which I would rather not wait. > > I couldn't find a command to do that, but I'm guessing that it should be > possible by manipulating a structure in the catalog?
Try this: begin; drop indexname; explain analyze select ...; rollback; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
