Gauri Kanekar escribió: > I want the planner to ignore a specific index. > I am testing some query output. For that purpose i dont want the index. > I that possible to ignore a index by the planner.
Sure: BEGIN DROP INDEX foo SELECT .... ROLLBACK -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
