"Ivetta Starikova" <ivetta_s(at)hotmail(dot)com> writes:
> I have a problem with my program that inserts records into postgreSQL
> database.
> After continuously running for several days, it suddenly hangs.
Looks to me like it's waiting for the server process. Are you sure
there isn't some other operation blocking the INSERT (perhaps by
exclusively locking the table)? If you're not sure what the server
is doing, try getting a stack trace from it.
regards, tom lane