Thread: is there any backend timeout?

    Hi!

    Is there any server timeout that is undocumented?

    I've issued a query like the one below and the server timed out after
180min (+/-). The query "construct_warehouse()" can last well above the
180min because it fills a table with millions of tuples...

spid=> vacuum full analyze ; select construct_warehouse() ; vacuum analyze ;
NOTICE:  Skipping "pg_group" --- only table or database owner can VACUUM it
NOTICE:  Skipping "pg_database" --- only table or database owner can VACUUM it
NOTICE:  Skipping "pg_shadow" --- only table or database owner can VACUUM it
VACUUM
server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
You are currently not connected to a database.
!> \q

    I've searched the archives for some documented timeout but nothing...

    Can anyone help me? Thanks in advance!

--
     o__        Bem haja,
    _.>/ _            NunoACHenriques
   (_) \(_)            ~~~~~~~~~~~~~~~
                http://students.fct.unl.pt/users/nuno/