Re: Strange performance boost with random()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sébastien Lorion <sl(at)thestrangefactory(dot)com>
Cc: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, M Putz <puma(at)c007(dot)de>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Strange performance boost with random()
Date: 2014-02-11 15:37:47
Message-ID: 19895.1392133067@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?UTF-8?Q?S=C3=A9bastien_Lorion?= <sl(at)thestrangefactory(dot)com> writes:
> That's interesting .. Does PostgreSQL always use the NUMERIC data type for
> constants in absence of cast ?

If they're not integers, yes, that's the initial assumption.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2014-02-11 15:56:07 Re: [PERFORM] encouraging index-only scans
Previous Message Sébastien Lorion 2014-02-11 15:21:30 Re: Strange performance boost with random()