Re: docs update for count(*) and index-only scans

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: docs update for count(*) and index-only scans
Дата
Msg-id CAOR=d=364hfCt9XjXYVKXig-++M=hBRPd9u4k=TnBhioKW-8xA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: docs update for count(*) and index-only scans  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-docs
On Fri, Nov 4, 2011 at 2:10 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Tue, Nov 1, 2011 at 8:07 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> It's the "lobotomized engines" that are the problem, IMO --- people
>> coming from databases like mysql tend to think count(*) just means
>> reading a table size counter that the engine has anyway.
>
> This is probably a much less common misconception than formerly, due
> to the rise of InnoDB and the falling-out-of-favor experienced by
> MyISAM.

True.  For instance the Drizzle project simply yanked myisam as an
engine out of mysql for their fork, and made innodb the standard
default table handler.

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: docs update for count(*) and index-only scans
Следующее
От: Jason Strimpel
Дата:
Сообщение: collation charts/tables