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

От: Marc Mamin
Тема: TIP 9: the planner will ignore... & datatypes
Дата: ,
Msg-id: 29804.1117619106@www18.gmx.net
(см: обсуждение, исходный текст)
Ответ на: Re: slow queries, possibly disk io  (Simon Riggs)
Ответы: Re: TIP 9: the planner will ignore... & datatypes  (Alvaro Herrera)
Список: 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, )

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?

Thanks,

Marc

--
Geschenkt: 3 Monate GMX ProMail gratis + 3 Ausgaben stern gratis
++ Jetzt anmelden & testen ++ http://www.gmx.net/de/go/promail ++


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

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