Re: Insert into partition table hangs - Mailing list pgsql-general

From Nik
Subject Re: Insert into partition table hangs
Date
Msg-id 1149086738.652246.208550@c74g2000cwc.googlegroups.com
Whole thread Raw
In response to Re: Insert into partition table hangs  ("Nik" <XLPizza@gmail.com>)
List pgsql-general
I am still having the same problem. I tried to eliminate any possible
network issues by placing the application on the server itself, but the
same thing happened.

However, I had an interesting discovery today that I don't understand.

I left the insert query that was stuck running. Then, without changing
any parameters, I ran reload configuration, aka. sending SIGHUP, and
the query immediately completed and went on to the next insert.

I also noticed that I am having the similar issue with SELECT
statements. Same SELECT statement will run fine 3-4 times in a row and
then get stuck and run forever with no results. But if I reload the
configuration like above, the query immediatelly returns with correct
result.

Why does this happen, and could this give any insight in my problem?

Thanks.


pgsql-general by date:

Previous
From: dananrg@yahoo.com
Date:
Subject: Re: Best open source tool for database design / ERDs?
Next
From: Alexander Scholz
Date:
Subject: Re: Problem V8.1.4 - providing pwd for commandline tools doesn't