"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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster

xeb@mail.ru writes: > error message in log: > ERROR: invalid restriction selectivity: 0.000049 [ blink... ] Surely it didn't really say that, because a moment's glance at the code shows that it's impossible: if (result < 0.0 || result > 1.0) elog(ERROR, "invalid restriction selectivity: %f", result); If it really did say that, then you have either seriously flaky hardware or a broken compiler. In either case, us mere database weenies can't help much. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly