Re: [PERFORM] Query plan issues - volatile tables

2009-06-04 Thread Craig James
Brian Herlihy wrote: We have a problem with some of our query plans. One of our tables is quite volatile, but postgres always uses the last statistics snapshot from the last time it was analyzed for query planning. Is there a way to tell postgres that it should not trust the statistics for this

[PERFORM] Query plan issues - volatile tables

2009-06-03 Thread Brian Herlihy
Hi, We have a problem with some of our query plans. One of our tables is quite volatile, but postgres always uses the last statistics snapshot from the last time it was analyzed for query planning. Is there a way to tell postgres that it should not trust the statistics for this table? Basic