Query plan issues - volatile tables

Поиск
Список
Период
Сортировка
От Brian Herlihy
Тема Query plan issues - volatile tables
Дата
Msg-id 179219.21947.qm@web52310.mail.re2.yahoo.com
обсуждение исходный текст
Ответы Re: Query plan issues - volatile tables  (Craig James <craig_james@emolecules.com>)
Список pgsql-performance
Hi,

We have a problem with some of our query plans.  One of our tables is quite volatile, but postgres always uses the last
statisticssnapshot from the last time it was analyzed for query planning.  Is there a way to tell postgres that it
shouldnot trust the statistics for this table?  Basically we want it to assume that there may be 0, 1 or 100,000
entriescoming out from a query on that table at any time, and that it should not make any assumptions. 

Thanks,
Brian
 ========================
Brian Herlihy
Trellian Pty Ltd
+65 67534396 (Office)
+65 92720492 (Handphone)
========================


В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Pointers needed on optimizing slow SQL statements
Следующее
От: Janine Sisk
Дата:
Сообщение: Re: Pointers needed on optimizing slow SQL statements