Last modified: 2010-05-15 15:48:19 UTC
We run PostgreSQL 8.1 Apparently at random the system appears to hang while waiting for an event that never happens. In general the server is idle at this point, though random activity takes places. To cause the hangs/pseudo-hangs we will do one of the following: Run a search and attempt to edit. Result: Either or both of the search takes for ever to reach EOJ or an edit may open fast but take up to 60 seconds to submit Edit several pages simultaneously (tabbed browser) and submit edits as near simultaneously as posisble. Result: Edits Do submit, but take of the order of 60 seconds Server is very lightly loaded indeed (we are in the startup phase)
Could not duplicate. Can you try and figure out what is locking or taking so long? Use the Postgres server logs, and/or check the output of: select pid, relation:regclass, locktype, granted from pg_locks; select * from pg_stat_activity; Also, how many pages do you have, and how long does a search usually take?
Changing to "worksforme". If the submitter has more information, please reopen the bug.
