problem with max and not using index on PK

Поиск
Список
Период
Сортировка
От pginfo
Тема problem with max and not using index on PK
Дата
Msg-id 3EB387F6.F3230162@t1.unisoftbg.com
обсуждение исходный текст
Ответы Re: problem with max and not using index on PK
Список pgsql-sql
Hi,
I am using PG 7.3.1

The query plan is:

mydb=# explain analyze select max(IDS) from t_sk10;                                                      QUERY PLAN

------------------------------------------------------------------------------------------------------------------------
Aggregate  (cost=61742.78..61742.78 rows=1 width=64) (actual
time=11221.42..11221.43 rows=1 loops=1)  ->  Seq Scan on t_sk10  (cost=0.00..60076.22 rows=666622 width=64)
(actual time=16.59..9968.00 rows=666622 loops=1)Total runtime: 11221.50 msec
(3 rows)

Time: 11222.68 ms

The time is very big.
For example if I start it on oracle, it take ~ 100 ms !

The column IDS is the PK. It is declared as name.
I do not know the reason for not using index in this case.

Also if I get another (not indexed column) and start also max, PG i
working 4 time quicker as oracle and it is great.

Regards,
ivan.



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

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: timeofday() and now() issue..
Следующее
От: Philip Warner
Дата:
Сообщение: Re: problem with max and not using index on PK