> Are PG admins experienced in determining and killing such zombi-sessions? > I mean, may be script or something to do this job exist in nature? > > Thanks. >
#statement_timeout = 0 # 0 is disabled, in milliseconds I think if you give this item in postgresql.conf a value, it will kill long running queries for you. > -- > Best regards > Ilja Golshtein > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
