Re: ERROR: invalid restriction selectivity: 224359728.000000

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: xeb(at)mail(dot)ru, pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: invalid restriction selectivity: 224359728.000000
Date: 2007-11-18 18:36:43
Message-ID: 6726.1195411003@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> writes:
> On Nov 16, 2007 11:59 AM, <xeb(at)mail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shane Ambler 2007-11-18 18:53:20 Re: Need help with complicated SQL statement
Previous Message Tom Lane 2007-11-18 18:17:29 Re: Compressed Backup too big