Re: Unexpected query plan results

From: Anne Rosset
Subject: Re: Unexpected query plan results
Date: ,
Msg-id: 4A243FC4.8060302@collab.net
(view: Whole thread, Raw)
In response to: Re: Unexpected query plan results  (Robert Haas)
Responses: Re: Unexpected query plan results  ("Dave Dutcher")
Re: Unexpected query plan results  (Robert Haas)
List: pgsql-performance

Tree view

Unexpected query plan results  (Anne Rosset, )
 Re: Unexpected query plan results  ("Dave Dutcher", )
  Re: Unexpected query plan results  (Anne Rosset, )
   Re: Unexpected query plan results  ("Dave Dutcher", )
    Re: Unexpected query plan results  (Scott Mead, )
    Re: Unexpected query plan results  (Anne Rosset, )
     Re: Unexpected query plan results  (Robert Haas, )
 Re: Unexpected query plan results  (Robert Haas, )
  Re: Unexpected query plan results  (Anne Rosset, )
   Re: Unexpected query plan results  (Robert Haas, )
    Re: Unexpected query plan results  (Anne Rosset, )
     Re: Unexpected query plan results  (Robert Haas, )
      Re: Unexpected query plan results  (Anne Rosset, )
       Re: Unexpected query plan results  ("Dave Dutcher", )
        Re: Unexpected query plan results  (Anne Rosset, )
       Re: Unexpected query plan results  (Robert Haas, )
        Re: Unexpected query plan results  (Віталій Тимчишин, )
         Re: Unexpected query plan results  (Robert Haas, )
        Re: Unexpected query plan results  (Anne Rosset, )
         Re: Unexpected query plan results  (Robert Haas, )

Robert Haas wrote:

>On Mon, Jun 1, 2009 at 2:14 PM, Anne Rosset <> 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


pgsql-performance by date:

From: Ron Mayer
Date:
Subject: Re: Scalability in postgres
From: Greg Smith
Date:
Subject: Re: Scalability in postgres