"Andrus" <kobruleht2@xxxxxx> writes: > My query takes 26 seconds to run. The time seems entirely spent in fetching rows from table "rid". Perhaps that table is bloated by lack of vacuuming --- can you show the output from "vacuum verbose rid"? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly