Re: [PERFORM] Slow query after upgrade to 8.4

2009-09-24 Thread Jared Beck
we try to improve statistics collection for that column (variableid) by using ALTER TABLE ... ALTER COLUMN ... SET STATISTICS? In other words, if the row estimate were perfect would we be likely to get a better plan? Or is that impossible to speculate on? Thanks again. Already you've been

[PERFORM] Slow query after upgrade to 8.4

2009-09-23 Thread Jared Beck
d and zipped it up here: http://pgsql.privatepaste.com/download/a3SdI8j2km Thank you very much in advance for any suggestions you may have, Jared Beck -- -- Jared Beck Web Developer Singlebrook Technology (607) 330-1493 ja...@singlebrook.com -- Sent via pgsql-performance mailing list (pgsql-perfo

[PERFORM] Slow query after upgrade to 8.4

2009-09-23 Thread Jared Beck
d and zipped it up here: http://pgsql.privatepaste.com/download/a3SdI8j2km Thank you very much in advance for any suggestions you may have, Jared Beck -- -- Jared Beck Web Developer Singlebrook Technology (607) 330-1493 ja...@singlebrook.com -- Sent via pgsql-performance mailing list (pgsql-perfo