Re: BUG #13628: System Hangs During Update Query

On 09/21/2015 12:57 AM, manoj.sagar@globallogic.com wrote:
> The following bug has been logged on the website:
>=20
> Bug reference:      13628
> Logged by:          manoj kumar
> Email address:      manoj.sagar@globallogic.com
> PostgreSQL version: 9.1.3
> Operating system:   OpenSuse
> Description:       =20
>=20
> Hi I am running an update command on the postgress ,the query is quite =
long
> so sometimes my system hangs up during this command and we have to rest=
art
> the postgres as a workaround .WE are not able to locate the problem so
> please help us in this scenario,we have checked the pg_stats_activity a=
nd
> pg_locks also but no information could be fetched about the issue

First of all, this is unlikely to be a bug, and thus this is the wrong
place. Please use the pgsql-general list. If needed sign up here:

  http://www.postgresql.org/list/).

Second, there is not nearly enough information here for anyone to help
you. Please read the information here *prior* to posting on pgsql-general=
:

  https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

HTH,

Joe

--=20
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development