[PERFORM] Re: Re: Query running slow for only one specific id. (Postgres 9.3) version

Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> · Fri, 05 Jun 2015 12:28:23 -0700



Title: Konsole output

  
    On 06/05/2015 11:38 AM, Sheena,
      Prabhjot wrote:

    
        When I run
            vacuum analyze it fixes the problem but after 1 or 2 days
            the problem comes back
         
        
    Is autovacuum running and using what settings?

    
    (select name, setting from pg_settings where name ~ 'autovacuum'
    
    or name ~ 'statistics';)

    
    Cheers,

    Steve

    
    P.S. The convention on the PostgreSQL mailing lists it to
    bottom-post, not top-post replies.

    
    Konsole outpor name ~ 'statistics';)