Re: Problems with adding a is not null to a query.

On Mon, Jan 17, 2011 at 8:23 AM, Tim Uckun <timuckun@gmail.com> wrote:
>> Hmm. =A0What do you get for:
>>
>> SELECT relname, pg_relation_size(oid), reltuples, relpages FROM
>> pg_class WHERE relname IN ('consolidated_urls',
>> 'consolidated_urls_pkey');
>
> =A0 =A0 =A0 =A0relname =A0 =A0 =A0 =A0 | pg_relation_size | =A0reltuples =
=A0| relpages
> ------------------------+------------------+-------------+----------
> =A0consolidated_urls =A0 =A0 =A0| =A0 =A0 =A0 1303060480 | 1.80192e+06 | =
=A0 159065
> =A0consolidated_urls_pkey | =A0 =A0 =A0 =A0114745344 | 1.80192e+06 | =A0 =
=A014007
> (2 rows)

Hmm, I was thinking that the table might be bloated but it's not
obvious from this.

I think you might have the same general kind of problem reported here:

http://archives.postgresql.org/pgsql-bugs/2009-09/msg00259.php

and here:

http://archives.postgresql.org/pgsql-performance/2010-04/msg00139.php

...and there are other reports as well.

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company