Re: Problem with indices from 10 to 13

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: Problem with indices from 10 to 13
Дата
Msg-id 20210929021803.GC831@telsasoft.com
обсуждение исходный текст
Ответ на RE: Problem with indices from 10 to 13  (Daniel Diniz <daniel@flashcourier.com.br>)
Ответы RE: Problem with indices from 10 to 13  (Daniel Diniz <daniel@flashcourier.com.br>)
Список 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 по дате отправления:

Предыдущее
От: Daniel Diniz
Дата:
Сообщение: RE: Problem with indices from 10 to 13
Следующее
От: Daniel Diniz
Дата:
Сообщение: RE: Problem with indices from 10 to 13