Re: Optimizer not using index on 120M row table

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Optimizer not using index on 120M row table
Дата
Msg-id 20030407225421.N31861@flake.decibel.org
обсуждение исходный текст
Ответ на Re: Optimizer not using index on 120M row table  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Optimizer not using index on 120M row table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Mon, Apr 07, 2003 at 11:51:17PM -0400, Tom Lane wrote:
> or just declare project_id to be integer (hint: the space savings are
> completely illusory in this example, anyway, because of alignment
> requirements).

Hrm... where can I find more info about that?
--
Jim C. Nasby (aka Decibel!)                    jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Optimizer not using index on 120M row table
Следующее
От: Jonathan Bartlett
Дата:
Сообщение: Re: Why no performance boost although I added an index?