Tom Lane schrieb: > Peter Hinse <loco@xxxxxxxxxxx> writes: >> More info: the statement is an INSERT with some huge subselects, running >> every night on a PGSQL 8.3.6 on CentOS 4.7 x86_64. In 97% of all >> occasions, the job terminates in about 1-2 minutes - however, sometimes >> it just hangs. If terminated with kill <pid> and restarted, it always >> terminates. > > Define "huge" --- you mean a lot of relations in the query? If you have > enough to trigger GEQO optimization, it could be that it's sometimes > picking a bad plan. You might try raising the geqo threshold to more > relations than that; or if this results in unacceptably long planning > time, increase geqo_effort instead. Hi Tom, thanks for your hints, I will check this with our R&D people. And yes: with "huge" I meant the number of relations. Regards, Peter -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
