Re: [RFC] Should smgrtruncate() avoid sending sinval message for temp relations - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [RFC] Should smgrtruncate() avoid sending sinval message for temp relations
Date
Msg-id 3257.1407863515@sss.pgh.pa.us
Whole thread Raw
In response to Re: [RFC] Should smgrtruncate() avoid sending sinval message for temp relations  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: [RFC] Should smgrtruncate() avoid sending sinval message for temp relations
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2014-08-12 11:56:41 -0400, Robert Haas wrote:
>> Yes.  Do you have a back-patchable solution for that?

> The easiest thing I can think of is sprinkling a few
> SetConfigOption('synchronous_commit', 'off',
>                 PGC_INTERNAL, PGC_S_OVERRIDE,
>                 GUC_ACTION_LOCAL, true, ERROR);

This still seems to me to be applying a band-aid that covers over some
symptoms; it's not dealing with the root cause that we've overloaded
the signal handling mechanism too much.   What reason is there to think
that there are no other symptoms of that?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [PATCH] PostgreSQL 9.4 mmap(2) performance regression on FreeBSD...
Next
From: Fabien COELHO
Date:
Subject: Re: PL/PgSQL: RAISE and the number of parameters