Re: Problem with indices from 10 to 13

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Daniel Diniz <daniel(at)flashcourier(dot)com(dot)br>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Problem with indices from 10 to 13
Date: 2021-09-29 02:18:03
Message-ID: 20210929021803.GC831@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Daniel Diniz 2021-09-29 04:00:38 RE: Problem with indices from 10 to 13
Previous Message Daniel Diniz 2021-09-29 02:11:15 RE: Problem with indices from 10 to 13