"Andrus" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly