BUG #15008: Need a pause

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: martellilaurent(at)gmail(dot)com
Subject: BUG #15008: Need a pause
Date: 2018-01-12 09:26:55
Message-ID: 20180112092655.1419.45992@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15008
Logged by: Laurent Martelli
Email address: martellilaurent(at)gmail(dot)com
PostgreSQL version: 9.6.6
Operating system: Debian 9.3
Description:

I have a set of scripts I execute with psql, and for some reason, a query in
one of them take forever (never had the patience to wait for more than 15
minutes), eating 1 CPU, unless I insert a pause (sleep 60) before that
script, and then it only takes a few seconds.

It only occurs when the tables we operate on have a sufficient number of
rows. When we do "unit" tests with a subset of the data, it all goes
smoothly.

Please, tell me what additional information I can provide to help fix this.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Clough 2018-01-12 09:39:02 RE: BUG #15008: Need a pause
Previous Message Thomas Munro 2018-01-12 04:01:58 Re: [HACKERS] [BUGS] BUG #14825: enum type: unsafe use?