Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple indexed IN query takes 40 seconds - Mailing list pgsql-performance

From Tom Lane
Subject Re: Simple indexed IN query takes 40 seconds
Date
Msg-id 7709.1226334545@sss.pgh.pa.us
Whole thread Raw
In response to Simple indexed IN query takes 40 seconds  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: Simple indexed IN query takes 40 seconds
List pgsql-performance
Tree view 
"Andrus" <kobruleht2@hot.ee> writes:
> How to make this query to run fast ?

Using something newer than 8.1 would help.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Andrus"
Date:
Subject: Simple indexed IN query takes 40 seconds
Next
From:
Date:
Subject: slow full table update