Brian Cox <brian.cox@xxxxxx> writes: > Tom Lane [tgl@xxxxxxxxxxxxx] wrote: >> OK, so what's the entry for column ts_id? > Is this what you requested? Brian Yup. So according to those stats, all ts_id values fall in the range 600000000000000001 .. 600000000000250068. It's no wonder it's not expecting to find anything between 0 and 100000. I think maybe you forgot to re-analyze after loading data ... although this being 8.3, I'd have expected autovacuum to update the stats at some point ... Recommendation: re-ANALYZE, check that the plan changes to something with a higher estimate for the number of rows for this table, and then abort and restart those processes. Lord knows how long you'll be waiting for them to finish with their current plans :-( regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
