Re: Postgres 9.0 has a bias against indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres 9.0 has a bias against indexes
Дата
Msg-id 17268.1296146447@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres 9.0 has a bias against indexes  (David Wilson <david.t.wilson@gmail.com>)
Ответы Re: Postgres 9.0 has a bias against indexes  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
Список pgsql-performance
David Wilson <david.t.wilson@gmail.com> writes:
> You're still using a 14 row table, though.

Exactly.  Please note what it says in the fine manual:

    It is worth noting that EXPLAIN results should not be extrapolated
    to situations other than the one you are actually testing; for
    example, results on a toy-sized table cannot be assumed to apply to
    large tables. The planner's cost estimates are not linear and so it
    might choose a different plan for a larger or smaller table. An
    extreme example is that on a table that only occupies one disk page,
    you'll nearly always get a sequential scan plan whether indexes are
    available or not. The planner realizes that it's going to take one
    disk page read to process the table in any case, so there's no value
    in expending additional page reads to look at an index.


            regards, tom lane

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

Предыдущее
От: "Igor Neyman"
Дата:
Сообщение: Re: Real vs Int performance
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Running PostgreSQL as fast as possible no matter the consequences