Re: [PATCH] Opclass parameters

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>, Nikolay Shaplov <dhyan(at)nataraj(dot)su>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Oleg Bartunov <obartunov(at)gmail(dot)com>
Subject: Re: [PATCH] Opclass parameters
Date: 2019-06-11 17:57:45
Message-ID: 20190611175745.wwb6jywbch2pz23f@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


while rebasing the patch series [1] adding bloom/multi-minmax BRIN
opclasses, I've decided to also rebase it on top of this patch, because it
needs the opclass parameters. So I had to rebase this too - it went mostly
fine, with reasonably limited bitrot. The rebased patch series is attached.

Using this patch series in [1] was mostly smooth, I only have two minor
comments at this point:

1) We need a better infrastructure to parse opclass parameters. For
example the gtsvector_options does this:

Datum raw_options = PG_GETARG_DATUM(0);
bool validate = PG_GETARG_BOOL(1);
relopt_int siglen =
{ {"siglen", "signature length", 0, 0, 6, RELOPT_TYPE_INT },
relopt_gen *optgen[] = { &siglen.gen };
int offsets[] = { offsetof(GistTsVectorOptions, siglen) };
GistTsVectorOptions *options =
parseAndFillLocalRelOptions(raw_options, optgen, offsets, 1,
sizeof(GistTsVectorOptions), validate);


So in other words, it builds all the various pieces (relopts, optgen,
offsets, lengths etc.) manually, which is really error-prone and difficult
to maintain. We need to make it simpler - ideally as simple as defining a
custom GUC, or just an array of relopt_* structs.

2) The 0001 part does this in index_opclass_options_generic:

get_opclass_name(opclass, InvalidOid, &str);

errmsg("operator class \"%s\" has no options",;

But that's a bit broken, because get_opclass_name() appends the opclass
name to 'str', but with a space at the beginning. So this produces
messages like

ERROR: operator class " int4_bloom_ops" has no options

which is not right. I haven't checked if a better function already exists,
or whether we need to implement it.


Tomas Vondra
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
0001-Add-opclass-parameters-20190611.patch text/plain 41.7 KB
0002-Add-opclass-parameters-to-GiST-20190611.patch text/plain 13.7 KB
0003-Add-opclass-parameters-to-GIN-20190611.patch text/plain 15.2 KB
0004-Add-opclass-parameters-to-GiST-tsvector_ops-20190611.patch text/plain 31.7 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2019-06-11 18:20:06 Re: Status of the table access method work
Previous Message Tom Lane 2019-06-11 17:57:16 Re: hyrax vs. RelationBuildPartitionDesc