On 11/11/15 11:57 AM, Skarsol wrote:
Are we doing anything weird with this procedure? Is there anything more
I can do to get more info as to why/how the cancellation is happening or
why the function would slow down seemingly randomly?
ERROR: canceling statement due to user request
CONTEXT: PL/
On 11/10/15 3:42 PM, Jason Jho wrote:
On one particular day, this query hung for many hours and even while we
killed pids for running queries and any locks granted, the query would
never return. Also no hints of blocking processes. After some digging
through some I/O metrics, we didn't see any
On Fri, Nov 13, 2015 at 7:15 AM, Merlin Moncure wrote:
> On Thu, Nov 12, 2015 at 4:26 PM, Tom Lane wrote:
>> Merlin Moncure writes:
>>> On Thu, Nov 12, 2015 at 9:48 AM, Craig James wrote:
What about a warning on creation?
db=> create table foo(i integer primary key);
db=> cr
On Thu, Nov 12, 2015 at 4:26 PM, Tom Lane wrote:
> Merlin Moncure writes:
>> On Thu, Nov 12, 2015 at 9:48 AM, Craig James wrote:
>>> What about a warning on creation?
>>>
>>> db=> create table foo(i integer primary key);
>>> db=> create table bar(j integer primary key, i integer);
>>> db=> alter
