Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with adding a is not null to a query. - Mailing list pgsql-bugs

From Tim Uckun
Subject Re: Problems with adding a is not null to a query.
Date
Msg-id AANLkTim4je4KYdbUykmfoCCjWf1GHcGDGxUb_XuQ6d2T@mail.gmail.com
Whole thread Raw
In response to Re: Problems with adding a is not null to a query.  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Problems with adding a is not null to a query.  (Robert Haas <robertmhaas@gmail.com>)
Re: Problems with adding a is not null to a query.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
>
> Hmm. =C2=A0What do you get for:
>
> SELECT relname, pg_relation_size(oid), reltuples, relpages FROM
> pg_class WHERE relname IN ('consolidated_urls',
> 'consolidated_urls_pkey');
>


        relname         | pg_relation_size |  reltuples  | relpages
------------------------+------------------+-------------+----------
 consolidated_urls      |       1303060480 | 1.80192e+06 |   159065
 consolidated_urls_pkey |        114745344 | 1.80192e+06 |    14007
(2 rows)

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: Problems with adding a is not null to a query.
Next
From: "Jeff Turner"
Date:
Subject: BUG #5841: rank()+1 fails, 1+rank() succeeds