Re: Unexpected query plan results

Robert Haas wrote:

>On Mon, Jun 1, 2009 at 2:14 PM, Anne Rosset <arosset@collab.net> wrote:
>
>
>>>>The table has 468173 rows and the value for default_statistics_target is
>>>>750.
>>>>Anne
>>>>
>>>>
>>Hi Robert,
>>we did a vacuum analyze and the results are the same.
>>Here are the results of the queries :
>>
>>SELECT SUM(1) FROM item WHERE is_deleted = 'f'; sum --------- 1824592 (1
>>row)
>>SELECT SUM(1) FROM item WHERE folder_id = 'tracker3641
>></sf/sfmain/do/go/tracker3641?returnUrlKey=1243878161701>'; sum --------
>>122412 (1 row)
>>SELECT SUM(1) FROM item WHERE folder_id = 'tracker3641
>></sf/sfmain/do/go/tracker3641?returnUrlKey=1243878161701>' AND is_deleted =
>>'f'; sum ----- 71 (1 row)
>>SELECT SUM(1) FROM item WHERE folder_id = 'tracker3641
>></sf/sfmain/do/go/tracker3641?returnUrlKey=1243878161701>' AND is_deleted =
>>'t'; sum -------- 122341 (1 row)
>>
>>
>
>Something's not right here.  If the whole table has only 468173 rows,
>you can't have 1.8 million deleted rows where is_deleted = false.
>
>...Robert
>
>
The item table has 2324829 rows
The artifact table has 468173 rows.
Thanks,
Anne