Mike Mascari <[EMAIL PROTECTED]> writes:
> When I query the view with a simple filter, I get:

> explain analyze select * from p_areas where deactive is null;

The problem seems to be here:

>     ->  Seq Scan on _areas a  (cost=0.00..2.48 rows=1 width=163) (actual 
> time=0.037..0.804 rows=48 loops=1)
>           Filter: (deactive IS NULL)

Why is it so completely off about the selectivity of the IS NULL clause?
Are you sure you ANALYZEd this table recently?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to