Postgres Pro
Downloads
Home   >   mailing lists

Re: IMMUTABLE and PARALLEL SAFE function markings - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: IMMUTABLE and PARALLEL SAFE function markings
Date
Msg-id e7ac5f79-3240-612e-b37c-7e35f22b8b74@2ndquadrant.com
Whole thread Raw
In response to IMMUTABLE and PARALLEL SAFE function markings  (Gajus Kuizinas <gajus@gajus.com>)
Responses Re: IMMUTABLE and PARALLEL SAFE function markings  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
On 26/11/2018 22:23, Gajus Kuizinas wrote:
> I was wondering what is the reason IMMUTABLE functions are not by
> default PARALLEL SAFE and if the default behaviour could be changed to
> make IMMUTABLE functions PARALLEL SAFE?

I think I have to concur with this.  When is an immutable function not
parallel safe?

Sure it could be mislabeled as immutable but it could just as easily be
mislabeled as parallel safe.  And we already treat fake immutable
functions as user errors, for example in indexes.
-- 
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [RFC] Removing "magic" oids
Next
From: Andres Freund
Date:
Subject: Re: IMMUTABLE and PARALLEL SAFE function markings