Re: Queries intermittently slow

Is this generally true for all PostgreSQL systems on Linux, or only for
specific use cases?

On Thu, Jan 7, 2016 at 12:51 PM, Scott Rankin <srankin(at)motus(dot)com> wrote:

> Winner! Both of those settings were set to always, and as soon as I
> turned them off, the query times smoothed right out.
>
> Thank you all so much for your help!
>
> - Scott
>
> From: Bob Lunney <bob_lunney(at)yahoo(dot)com>
> Date: Thursday, January 7, 2016 at 12:13 PM
> To: Scott Rankin <srankin(at)motus(dot)com>
> Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
> Subject: Re: [PERFORM] Queries intermittently slow
>
> Scott,
>
> Is transparent huge pages turned off along with defrag? Check
>
> /sys/kernel/mm/transparent_hugepage/enabled
>
> and
>
> /sys/kernel/mm/transparent_hugepage/defrag
>
> Both should be configured with "never".
>
> Bob Lunney
>
> This email message contains information that Motus, LLC considers
> confidential and/or proprietary, or may later designate as confidential and
> proprietary. It is intended only for use of the individual or entity named
> above and should not be forwarded to any other persons or entities without
> the express consent of Motus, LLC, nor should it be used for any purpose
> other than in the course of any potential or actual business relationship
> with Motus, LLC. If the reader of this message is not the intended
> recipient, or the employee or agent responsible to deliver it to the
> intended recipient, you are hereby notified that any dissemination,
> distribution, or copying of this communication is strictly prohibited. If
> you have received this communication in error, please notify sender
> immediately and destroy the original message.
>
> Internal Revenue Service regulations require that certain types of written
> advice include a disclaimer. To the extent the preceding message contains
> advice relating to a Federal tax issue, unless expressly stated otherwise
> the advice is not intended or written to be used, and it cannot be used by
> the recipient or any other taxpayer, for the purpose of avoiding Federal
> tax penalties, and was not written to support the promotion or marketing of
> any transaction or matter discussed herein.
>