seems similar to this problem:
http://stackoverflow.com/questions/5198380/improving-postgres-psycopg2-query-performance-for-python-to-the-same-level-of-ja
but no solution yet.
On Thu, Jan 12, 2012 at 5:00 PM, Yan Chunlu springri...@gmail.com wrote:
I also tried explain but found nothing
I am transforming a db with millions records to anther schema. for
some reason I need to select the records using IN (xx,xx).
the ids in the IN was about 1000 recored every time, but I found the
query was getting slow while the selection moving on.
the shared buffer is 2048M. and the cpu and
I also tried explain but found nothing special:
explain select * from data_table where thing_id in
(164438,112478,102941,112377,164442,181764,104028);
QUERY PLAN