Re: Problem with indices from 10 to 13

2021-09-28 Thread Alan Hodgson
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

Re: Slow Bitmap Index Scan

2018-12-03 Thread Alan Hodgson
On Mon, 2018-12-03 at 18:41 +, Scott Rankin wrote: > Upon further analysis, this is - unsurprisingly - taking place when we have > multiple prefixed search terms in a ts_query going against a tsvector index. > > We have roughly 30 million rows in the table, and the search column is > basical

Re: Details after Load Peak was: OT: Performance of VM

2018-02-06 Thread Alan Hodgson
On Tue, 2018-02-06 at 15:31 +0100, Thomas Güttler wrote: > But one thing is still unclear. Imagine I see a peak in the chart. The peak > was some hours ago. AFAIK sar has only the aggregated numbers. > > But I need to know details if I want to answer the question "Why?". The peak > has gone