Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query
Date
Msg-id 11687.1251295661@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query  (Jean-Michel Pouré <jm@poure.com>)
List pgsql-hackers
Tree view 
Jean-Michel Pouré <jm@poure.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

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query
Next
From: "Kevin Grittner"
Date:
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derive from int during SELECT query