pgsql 7.1.2 server hanging...
От | Ed Loehr |
---|---|
Тема | pgsql 7.1.2 server hanging... |
Дата | |
Msg-id | 3B37C749.A0320A58@austin.rr.com обсуждение исходный текст |
Ответы |
Re: pgsql 7.1.2 server hanging...
|
Список | pgsql-general |
I am trying out postgresql 7.1.2. I'm experiencing a hung server on linux 2.4.2-2 when I run a sql script that drops & reloads many PL/pgSQL functions and triggers, as well as hanging during VACUUM ANALYZE. That last thing I see in the logs is as follows: 2001-06-25 17:35:19 [3718] DEBUG: query: DROP TRIGGER person_insert_trigger ON person; 2001-06-25 17:35:19 [3718] DEBUG: ProcessUtility: DROP TRIGGER person_insert_trigger ON person; 2001-06-25 17:35:38 [3719] DEBUG: MoveOfflineLogs: remove 0000000000000008 During VACUUM ANALYZE the last log messages are: 2001-06-25 18:14:15 [3866] DEBUG: --Relation pg_toast_16600-- 2001-06-25 18:14:15 [3866] DEBUG: Pages 4: Changed 2, reaped 0, Empty 0, New 0; Tup 14: Vac 0, Keep/VTL 12/0, Crash 0, UnUsed 0, MinLen 1203, MaxLen 1901; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 2001-06-25 18:14:15 [3866] DEBUG: Index pg_toast_16600_idx: Pages 2; Tuples 14. CPU 0.00s/0.00u sec. Any clues or helpful diagnostic questions? Regards, Ed Loehr % cat /usr/local/pgsql/data/postmaster.opts /usr/local/postgresql-7.1.2/bin/postmaster '-i' '-p' '5432' '-B' '1024' '-N' '20' '-o' '-F -S 4096'
В списке pgsql-general по дате отправления: