Check constraints and function volatility categories

From: Dane Foster <studdugie(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Check constraints and function volatility categories
Date: 2016-02-01 19:17:25
Message-ID: CA+WxinK=RdRMxXzbqWErbRLga6HX2rMhG1-JbdN6b_6Zp=nSsQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm discovering that I need to write quite a few functions for use strictly
w/ check constraints and I'm wondering if declaring the volatility category
for said functions will affect their behavior when invoked by PostgreSQL's
check constraint mechanism.

Essentially what I'm trying to figure out is if volatility categories
increase or decrease the latency of executing check constraints. I've done
some micro benchmarks but I have no experience benchmarking anything in
PostgreSQL to trust that I'm measuring the right thing. So I'm asking the
experts.

I'm running PostgreSQL 9.5 on Ubuntu Linux 15.10. I don't know if this
matters but this is my workstation which is a pretty zippy AlienWare X51 w/
16GB RAM on a Core i7-4770 processor.

Thanks,

Dane

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2016-02-01 19:41:08 Re: strange sql behavior
Previous Message Yu Nie 2016-02-01 19:16:13 Re: strange sql behavior