Query performance with min and filter

2020-08-31 Thread Yorwerth, Adam
Hi Postgres community, We seem to have found a situation where a query run using explain analyse or pgbench is incredibly fast, but run via Java under load performs very poorly – we’ve checked query performance metrics for our Postgres instance and can confirm that it’s the query running slowly

BigSerial and txid issuance

2020-07-08 Thread Yorwerth, Adam
Hi Everyone, We’re trying to solve a problem that relies on BigSerial and txid (as returned by txid_current() ) values being issued consistently. Is it possible for two transactions to interleave their issuance of these two variables? For example: Schema: CREATE TABLE EXAMPLE( offset bigin