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

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



Title: Konsole output

  
    On 06/05/2015 12:28 PM, Steve Crawford
      wrote:

    
      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';)
    
    
    And just to confirm, are there any table-specific overrides to the
    system-wide settings?

    
    Cheers,

    Steve