On Wed, Sep 29, 2021 at 02:11:15AM +, 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/cur
Daniel Diniz writes:
> The index I use is the GIN.
pg_trgm, you mean? That answers one question, but you still didn't
explain what type h.nome_des is, nor how bytea and convert_from()
are getting into the picture.
The second part of that is probably not critical, since the planner
should be wil
Em ter., 28 de set. de 2021 às 12:40, Daniel Diniz
escreveu:
> > Hello I migrated from postgres 10 to 13 and I noticed that there was a big
> > increase in a querie that I use, I did explain in 10 and 13 and the
> > difference is absurd, the indices and data are the same in 2. I've re-
> > create
Daniel Diniz writes:
> Hello I migrated from postgres 10 to 13 and I noticed that there was a big
> increase in a querie that I use, I did explain in 10 and 13 and the
> difference is absurd, the indices and data are the same in 2. I've re-created
> and re-indexed but I don't know what changed
Em ter., 28 de set. de 2021 às 12:40, Daniel Diniz <
dan...@flashcourier.com.br> escreveu:
> Hello I migrated from postgres 10 to 13 and I noticed that there was a big
> increase in a querie that I use, I did explain in 10 and 13 and the
> difference is absurd, the indices and data are the same in
