Postgres Pro
Downloads
Home   >   mailing lists

Re: Batch insert heavily affecting query performance. - Mailing list pgsql-performance

From Jeremy Finzel
Subject Re: Batch insert heavily affecting query performance.
Date
Msg-id CAMa1XUjrFEQ3KxBCQ38FmKy783CJ3GJ7gjVzNA7ssurkhuJpiw@mail.gmail.com
Whole thread Raw
In response to Batch insert heavily affecting query performance.  (Jean Baro <jfbaro@gmail.com>)
Responses Re: Batch insert heavily affecting query performance.
List pgsql-performance
Tree view


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 cache performance.

There is definitely something wrong as there is no way a query like that should take 500ms.  Your instinct is correct there.

pgsql-performance by date:

Previous
From: "Mike Sofen"
Date:
Subject: RE: Batch insert heavily affecting query performance.
Next
From: Jeff Janes
Date:
Subject: Re: Batch insert heavily affecting query performance.