Re: Unexpected query plan results

Список
Период
Сортировка
От Anne Rosset
Тема Re: Unexpected query plan results
Дата
Msg-id 4A243FC4.8060302@collab.net
обсуждение исходный текст
Ответ на Re: Unexpected query plan results  (Robert Haas)
Ответы Re: Unexpected query plan results  ("Dave Dutcher")
Re: Unexpected query plan results  (Robert Haas)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Ron Mayer
Дата:
Сообщение: Re: Scalability in postgres
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Scalability in postgres