Re: Bogus sizing parameters in some AllocSetContextCreate calls - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Bogus sizing parameters in some AllocSetContextCreate calls
Date
Msg-id CA+TgmobNcELVd3QmLD3tx=w7+CokRQiC4_U0txjz=WHpfdkU=w@mail.gmail.com
Whole thread Raw
In response to Bogus sizing parameters in some AllocSetContextCreate calls  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bogus sizing parameters in some AllocSetContextCreate calls
List pgsql-hackers
On Sat, Aug 27, 2016 at 2:08 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The standard calling pattern for AllocSetContextCreate is
>
>     cxt = AllocSetContextCreate(parent, name,
>                                 ALLOCSET_DEFAULT_MINSIZE,
>                                 ALLOCSET_DEFAULT_INITSIZE,
>                                 ALLOCSET_DEFAULT_MAXSIZE);
>
> or for some contexts you might s/DEFAULT/SMALL/g if you expect the context
> to never contain very much data.  I happened to notice that there are a
> few calls that get this pattern wrong.  After a bit of grepping, I found:
>
> hba.c lines 389, 2196:
>                                    ALLOCSET_DEFAULT_MINSIZE,
>                                    ALLOCSET_DEFAULT_MINSIZE,
>                                    ALLOCSET_DEFAULT_MAXSIZE);
>
> guc-file.l line 146:
>                                        ALLOCSET_DEFAULT_MINSIZE,
>                                        ALLOCSET_DEFAULT_MINSIZE,
>                                        ALLOCSET_DEFAULT_MAXSIZE);
>
> brin.c line 857:
>
>                                 ALLOCSET_SMALL_INITSIZE,
>                                 ALLOCSET_SMALL_MINSIZE,
>                                 ALLOCSET_SMALL_MAXSIZE);
>
> autovacuum.c line 2184:
>                                           ALLOCSET_DEFAULT_INITSIZE,
>                                           ALLOCSET_DEFAULT_MINSIZE,
>                                           ALLOCSET_DEFAULT_MAXSIZE);
>
> typcache.c lines 757, 842:
>
>                                             ALLOCSET_SMALL_INITSIZE,
>                                             ALLOCSET_SMALL_MINSIZE,
>                                             ALLOCSET_SMALL_MAXSIZE);
>
> In all of these cases, we're passing zero as the initBlockSize, which is
> invalid, but but AllocSetContextCreate silently forces it up to 1K.  So
> there's no failure but there may be some inefficiency due to small block
> sizes of early allocation blocks.  I seriously doubt that's intentional;
> in some of these cases it might be sane to use the SMALL parameters
> instead, but this isn't a good way to get that effect.  The last four
> cases are also passing a nonzero value as the minContextSize, forcing
> the context to allocate at least that much instantly and hold onto it
> over resets.  That's inefficient as well, though probably only minorly so.

I noticed this a while back while playing with my alternate allocator,
but wasn't sure how much of it was intentional.  Anyway, +1 for doing
something to clean this up.  Your proposal sounds OK, but maybe
AllocSetContextCreateDefault() and AllocSetContextCreateSmall() would
be nice and easier to remember.

Also, I think we ought to replace this code in aset.c:
   initBlockSize = MAXALIGN(initBlockSize);   if (initBlockSize < 1024)       initBlockSize = 1024;   maxBlockSize =
MAXALIGN(maxBlockSize);

With this:
   Assert(initBlockSize >= 1024 && initBlockSize == MAXALIGN(initBlockSize));   Assert(maxBlockSize ==
MAXALIGN(maxBlockSize));

This might save a few cycles which wouldn't be unwelcome given that
AllocSetContextCreate does show up in profiles, but more importantly I
think it's completely inappropriate for this function to paper over
whatever errors may be made by callers.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: WIP: Covering + unique indexes.
Next
From: Robert Haas
Date:
Subject: Re: Checksum error and VACUUM FULL