Re: TIP 9: the planner will ignore... & datatypes

От: Alvaro Herrera
Тема: Re: TIP 9: the planner will ignore... & datatypes
Дата: ,
Msg-id: 20050601134009.GA23141@surnet.cl
(см: обсуждение, исходный текст)
Ответ на: TIP 9: the planner will ignore... & datatypes  ("Marc Mamin")
Список: pgsql-performance

Скрыть дерево обсуждения

slow queries, possibly disk io  (Josh Close, )
 Re: slow queries, possibly disk io  (John Arbash Meinel, )
  Re: slow queries, possibly disk io  (Josh Close, )
   Re: slow queries, possibly disk io  (Simon Riggs, )
    TIP 9: the planner will ignore... & datatypes  ("Marc Mamin", )
     Re: TIP 9: the planner will ignore... & datatypes  (Alvaro Herrera, )
 Re: slow queries, possibly disk io  (Dawid Kuroczko, )
 Re: slow queries, possibly disk io  (Christopher Kings-Lynne, )
  Re: slow queries, possibly disk io  (Josh Close, )
 slow queries, possibly disk io  (Josh Close, )
  Re: slow queries, possibly disk io  (Tom Lane, )
   Re: slow queries, possibly disk io  (Josh Close, )
   Re: slow queries, possibly disk io  (Josh Close, )
   Re: slow queries, possibly disk io  (Rudi Starcevic, )
    Re: slow queries, possibly disk io  (Josh Close, )
     Re: slow queries, possibly disk io  (Tom Lane, )
     Re: slow queries, possibly disk io  (Josh Close, )
      Re: slow queries, possibly disk io  (Manfred Koizar, )

On Wed, Jun 01, 2005 at 11:45:06AM +0200, Marc Mamin wrote:
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>
>
> But INT2, INT4, INT8 and "SERIAL" are considered to be a unique datatype.
> Am I Right?

No, they weren't when this tip was written.  As of 8.0 however this tip
is no longer the complete truth; we do allow cross-type index scans.

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"I suspect most samba developers are already technically insane...
Of course, since many of them are Australians, you can't tell." (L. Torvalds)


В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: Moving pg_xlog
От: "Keith Worthington"
Дата:
Сообщение: Re: Moving pg_xlog