Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jean-Michel Pouré <jm(at)poure(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query
Date: 2009-08-26 14:07:41
Message-ID: 11687.1251295661@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jean-Michel =?ISO-8859-1?Q?Pour=E9?= <jm(at)poure(dot)com> writes:
> Analysing slow queries, I noticed that PostgreSQL 8.4 would cast data
> from int4 to int_unsigned.

> Details and query plan: http://drupal.org/node/559986
> Some queries range between 400ms and 700ms.

I see no reason whatever to think that that domain has anything to do
with the choice of query plan.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2009-08-26 14:16:26 Re: PostgreSQL does CAST implicitely between int and a domain derive from int during SELECT query
Previous Message Andrew Dunstan 2009-08-26 14:07:33 Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query