David G Johnston <david.g.johns...@gmail.com> writes: > Benedikt Grundmann wrote >> That is it possible to tell the planner that index is off limits i.e. >> don't ever generate a plan using it?
> Catalog hacking could work but not recommended (nor do I know the proper > commands and limitations). Do you need the database/table to accept writes > during the testing period? Hacking pg_index.indisvalid could work, given a reasonably recent PG. I would not try it in production until I'd tested it ;-) regards, tom lane -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers