Re: Bitmap heap scan performance

2019-08-12 Thread Jeremy Finzel
> > Presumably I could partition proposal on has_been_anonymised, however > the row counts seem low enough that it feels a bit like overkill? We > also need referential integrity so I'll need to wait until that's in > (I think it's coming in PG12?) > > If I decrease the number of legacy_organisatio

Re: Batch insert heavily affecting query performance.

2017-12-27 Thread Jeremy Finzel
> > The EXPLAIN > > 'Index Scan using idx_user_country on card (cost=0.57..1854.66 rows=460 > width=922)' > ' Index Cond: (((user_id)::text = '4684'::text) AND (user_country = > 'BR'::bpchar))' > Show 3 runs of the full explain analyze plan on given condition so that we can also see cold vs warm