From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
---|---|
To: | pggeneral <pgsql-general(at)postgreSQL(dot)org> |
Subject: | pgsql 7.1.2 server hanging... |
Date: | 2001-06-25 23:20:41 |
Message-ID: | 3B37C749.A0320A58@austin.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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'
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Snow | 2001-06-25 23:30:23 | RE: Red Hat to support PostgreSQL |
Previous Message | Tom Lane | 2001-06-25 21:41:18 | Re: Pg uses non-unique index instead of pkey index |