Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mVPAi-0007U2-Rh for pgsql-performance@arkaria.postgresql.org; Wed, 29 Sep 2021 02:18:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mVPAh-0002N8-JI for pgsql-performance@arkaria.postgresql.org; Wed, 29 Sep 2021 02:18:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mVPAh-0002N0-4x for pgsql-performance@lists.postgresql.org; Wed, 29 Sep 2021 02:18:11 +0000 Received: from mail-io1-xd36.google.com ([2607:f8b0:4864:20::d36]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mVPAd-0005KA-Rn for pgsql-performance@lists.postgresql.org; Wed, 29 Sep 2021 02:18:10 +0000 Received: by mail-io1-xd36.google.com with SMTP id i62so1178036ioa.6 for ; Tue, 28 Sep 2021 19:18:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=LteUpk3rYxkh/SO2xH1eVrMCQudw7yfXUfML6qBychk=; b=JDLpgTMS4z7DtnKUDpXoK3rROYjNmvDVWPjZUJht9L1TW2CNQ73EWEmBWlN4u6FtnE 0aQu74gnXiZ2btq2CT8QYosgRbBkT5GqTA8EwmtX+DSt5Hjy6jyXExgKCf4qRuFrh2dU qE5z0AYRZFhDy23GAy9hM2kMfGkY+Pncj38zFWaFQbNzcSlmxEZtGgYDaIQGO2zUH2op YrUrASblL6siRTe9jfFnhvyzS6iBoCzl0Griow8T/yx5ATTD4xVH4R2RxuezAHHBYMYg +xgiwAd5lUe8VxjUnDltFBskhw96mXHu7EuYOxjyFeUWtIQnGm5C3tefz22RdCG2jHcf UvwQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=LteUpk3rYxkh/SO2xH1eVrMCQudw7yfXUfML6qBychk=; b=FzTgM0rs9vn2Oi6Yo7CdQBGCjw3sHOA/pRBzUETWM7jd4xTvo13SIsR5ONIvaywiIM 9H5/rTII+u7dqn8TX3v+suPBj1YcXUCyjIyv0D7Xskn6WJ2rljL7LVX3knKvHYyq4vir RD9qFUrRrJFG0erI50kEsDHfl3OjsHG3yas4Mv/qeRrBmb42UF8+HzTUDuvdj6o31cK/ im4Y2FnumYuFGbAFnPtbvPbzQnI8l5tVFdFJXNzBJkR6hPvfxJZN1EYb7MAxv+v9gsDn o6BdM92SmpN8qmdxr0ZpN61tyq/Io/x0iFjt/rooJWiIyOtcf/PShsgrTw9IxbUDI8WC UAiA== X-Gm-Message-State: AOAM530mRYQdKUPeFG/BpzycAdOK1tUmRp5IgCvhMG3Kic8WIua1Ce8H IMI4p6IW3GKVvMC4TOJ2P9Z+6esZItztTQ== X-Google-Smtp-Source: ABdhPJwVn25XbZ5tSdMFUfoOHUm70FSeQT4m2XBvsESMsQLj+P1qHg0GjjLyAzT8YxIhSY5+9YZFWg== X-Received: by 2002:a05:6638:14cd:: with SMTP id l13mr7322312jak.90.1632881885152; Tue, 28 Sep 2021 19:18:05 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id a12sm487453ilb.66.2021.09.28.19.18.04 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 28 Sep 2021 19:18:04 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 6DE92800A3B; Tue, 28 Sep 2021 21:18:03 -0500 (CDT) Date: Tue, 28 Sep 2021 21:18:03 -0500 From: Justin Pryzby To: Daniel Diniz Cc: Tom Lane , pgsql-performance@lists.postgresql.org Subject: Re: Problem with indices from 10 to 13 Message-ID: <20210929021803.GC831@telsasoft.com> References: <8d2ba21d-2318-4f02-a8fd-04c7d97e22ab.e854021a-9da0-4eba-a51f-e5ff782985ef.17ca0caa-f521-44ce-817a-17cbc713d135@emailsignatures365.codetwo.com> <2853352.1632851116@sss.pgh.pa.us> <2920281.1632868873@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Sep 29, 2021 at 02:11:15AM +0000, Daniel Diniz wrote: > How do i increase the statistics target for h.nome_des? > And why uploading the dump at 10 and at 13 is there this difference? It's like ALTER TABLE h ALTER nome_des SET STATISTICS 2000; ANALYZE h; https://www.postgresql.org/docs/current/sql-altertable.html -- Justin