Re: ERROR: invalid restriction selectivity: 224359728.000000

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: invalid restriction selectivity: 224359728.000000
Дата
Msg-id 6726.1195411003@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ERROR: invalid restriction selectivity: 224359728.000000  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
"Scott Marlowe" <scott.marlowe@gmail.com> writes:
> On Nov 16, 2007 11:59 AM,  <xeb@mail.ru> wrote:
>> Does anybody know what does the subj means and why it occures ?

> You're giving us WAY too little information to troubleshoot this problem.

Indeed, but it seems to have something to do with a broken selectivity
estimator function (see restriction_selectivity()).  What PG version
is this?  Do you have any add-on datatypes or operators installed?
Exactly what is the query that triggers the problem?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Compressed Backup too big
Следующее
От: Shane Ambler
Дата:
Сообщение: Re: Need help with complicated SQL statement