Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange performance boost with random() - Mailing list pgsql-performance

From Tom Lane
Subject Re: Strange performance boost with random()
Date
Msg-id 19895.1392133067@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange performance boost with random()  (Sébastien Lorion <sl@thestrangefactory.com>)
Responses list number of entries to be delete in cascading deletes  (Eildert Groeneveld <eildert.groeneveld@fli.bund.de>)
List pgsql-performance
Tree view 
=?UTF-8?Q?S=C3=A9bastien_Lorion?= <sl@thestrangefactory.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

pgsql-performance by date:

Previous
From: Sébastien Lorion
Date:
Subject: Re: Strange performance boost with random()
Next
From: Eildert Groeneveld
Date:
Subject: list number of entries to be delete in cascading deletes