slow plan for min/max

Поиск
Список
Период
Сортировка
От Pailloncy Jean-Gérard
Тема slow plan for min/max
Дата
Msg-id B451DA6A-E15D-11D7-B435-00039394E6D8@ifrance.com
обсуждение исходный текст
Ответы Re: slow plan for min/max
Re: slow plan for min/max
Список pgsql-performance
I have:
> psql (PostgreSQL) 7.3.2
I do a modification of 'access/index/indexam.c' where I comment:
> #ifdef NOT_USED
>         if (scan->keys_are_unique && scan->got_tuple)
>         {
>                 if (ScanDirectionIsForward(direction))
>                 {
>                         if (scan->unique_tuple_pos <= 0)
>                                 scan->unique_tuple_pos++;
>                 }
>                 else if (ScanDirectionIsBackward(direction))
>                 {
>                         if (scan->unique_tuple_pos >= 0)
>                                 scan->unique_tuple_pos--;
>                 }
>                 if (scan->unique_tuple_pos == 0)
>                         return heapTuple;
>                 else
>                         return NULL;
>         }
> #endif
I do not remember the references of the bug.
But the solution was planned for 7.4.

I do:
> psql=# \di
> [skip]
>  public | url_next_index_time      | index | postgresql | url
>  [skip]
> (11 rows)
I have an index on next_index_time field on table url.

> psql=# explain select min(next_index_time) from url \g
>                             QUERY PLAN
> -------------------------------------------------------------------
>  Aggregate  (cost=85157.70..85157.70 rows=1 width=4)
>    ->  Seq Scan on url  (cost=0.00..80975.56 rows=1672856 width=4)
> (2 rows)
Silly SeqScan of all the table.

> psql=# explain SELECT next_index_time FROM url ORDER BY
> next_index_time LIMIT 1 \g
>                                            QUERY PLAN
> -----------------------------------------------------------------------
> -------------------------
>  Limit  (cost=0.00..0.20 rows=1 width=4)
>    ->  Index Scan using url_next_index_time on url
> (cost=0.00..340431.47 rows=1672856 width=4)
> (2 rows)
I ask for the same thing.
That's better !

Why the planner does that ?

Jean-Gérard Pailloncy
Paris, France


В списке pgsql-performance по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] how to get accurate values in pg_statistic
Следующее
От: Greg Stark
Дата:
Сообщение: Re: [GENERAL] how to get accurate values in pg_statistic