Re: Problem with indices from 10 to 13 - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: Problem with indices from 10 to 13
Date
Msg-id 20210929021803.GC831@telsasoft.com
Whole thread Raw
In response to RE: Problem with indices from 10 to 13  (Daniel Diniz <daniel@flashcourier.com.br>)
Responses RE: Problem with indices from 10 to 13  (Daniel Diniz <daniel@flashcourier.com.br>)
List pgsql-performance
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



pgsql-performance by date:

Previous
From: Daniel Diniz
Date:
Subject: RE: Problem with indices from 10 to 13
Next
From: Daniel Diniz
Date:
Subject: RE: Problem with indices from 10 to 13