Re: [PATCH] Opclass parameters

From: Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>
To: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Nikolay Shaplov <dhyan(at)nataraj(dot)su>, Oleg Bartunov <obartunov(at)gmail(dot)com>
Subject: Re: [PATCH] Opclass parameters
Date: 2020-03-18 00:27:37
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Attached new version of reordered patches.

Questionable patches for AM-specific per-attribute options were moved to
the end, so they can be skipped now.

On 16.03.2020 18:22, Alexander Korotkov wrote:

> Hi!
> I took a look on this patchset. There is a first set of questions.
> * Patchset badly needs comments. I've to literally reverse engineer
> to get what's going on. But I still don't understand many things.
> * I'm curious about what local_relopts.base field means.
> void
> extend_local_reloptions(local_relopts *opts, void *base, Size base_size)
> {
> Assert(opts->base_size < base_size);
> opts->base = base;
> opts->base_size = base_size;
> }
> /*
> * add_local_reloption
> * Add an already-created custom reloption to the local list.
> */
> static void
> add_local_reloption(local_relopts *relopts, relopt_gen *newoption, void *pval)
> {
> local_relopt *opt = palloc(sizeof(*opt));
> opt->option = newoption;
> opt->offset = (char *) pval - (char *) relopts->base;
> relopts->options = lappend(relopts->options, opt);
> }
> Datum
> ghstore_options(PG_FUNCTION_ARGS)
> {
> local_relopts *relopts = (local_relopts *) PG_GETARG_POINTER(0);
> GistHstoreOptions *options = NULL;
> extend_local_reloptions(relopts, options, sizeof(*options));
> add_local_int_reloption(relopts, "siglen",
> "signature length in bytes",
> &options->siglen);
> }
> It's not commented, but I guess it's used to calculate offsets from
> pointers passed to add_local_*_reloption(). Is it better to just pass
> offsets to add_local_*_reloption()?

Yes, 'base' field was used to calculate offsets. Now I started to pass offsets
instead of pointers to the fields of template structure (that gave us
additional type checking). Some comments were added.

> * It's generally unclear how does amattoptions and opclass options
> interact. As I get we now don't have an example where both
> amattoptions and opclass options involved. What is general benefit
> from putting both two kind of options into single bytea? Can opclass
> options method do something useful with amattoptions? For instance,
> some amattoptions can be calculated from opclass options? That would
> be some point for putting these options together, but it doesn't look
> like opclass options method can do this?

There are no examples for AM and opclass options interaction now. But AM and
opclass can register custom callbacks that will be called after parsing in
their registration order. In these callbacks it is possible to post-process
option values, check presence or absence of some options.

The main benefit of putting both option into single bytea is that it does not
require major modifications of reloption processing code. And it also does
not require to split reloption list obtained from SQL into two separate lists
for AM and opclass options.

> * It current opclass code safe for introduction new atattoptions.
> For instace, would ghstore_*() work the same way expecting
> GistHstoreOptions struct to be passed as opclass options if gist would
> introduce own attoptions? I guess not. If I'm wrong, please clarify
> this. And patchset needs comment one could get this without guessing.

Yes, the code will be broken after introduction of GiST per-attribute options.
GistHstoreOptions should include GistAttOptions which simply did not exist in
the previous version of the patches. I added empty XxxAttOptions for all AMs
in patch #7, and GistAttOptions and GinAttOptions now are included into
corresponding structures for opclass options.

Nikita Glukhov
Postgres Professional:
The Russian Postgres Company

Attachment Content-Type Size
0001-Introduce-opclass-parameters-20200318.patch.gz application/gzip 24.2 KB
0002-Use-opclass-parameters-in-GiST-tsvector_ops-20200318.patch.gz application/gzip 7.1 KB
0003-Use-opclass-parameters-in-contrib_intarray-20200318.patch.gz application/gzip 7.3 KB
0004-Use-opclass-parameters-in-contrib_ltree-20200318.patch.gz application/gzip 8.5 KB
0005-Use-opclass-parameters-in-contrib_pg_trgm-20200318.patch.gz application/gzip 6.0 KB
0006-Use-opclass-parameters-in-contrib_hstore-20200318.patch.gz application/gzip 4.8 KB
0007-Introduce-amattoptions-20200318.patch.gz application/gzip 4.4 KB
0008-Use-amattoptions-in-contrib_bloom-20200318.patch.gz application/gzip 2.7 KB
0009-Remove-pg_index.indoption-20200318.patch.gz application/gzip 11.1 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2020-03-18 00:29:46 Re: PATCH: add support for IN and @> in functional-dependency statistics use
Previous Message Andres Freund 2020-03-18 00:26:36 Re: Berserk Autovacuum (let's save next Mandrill)