| From: | "Doran L(dot) Barton" <fozz(at)iodynamics(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: 7.1.3 w/ Perl/DBI application hangs |
| Date: | 2001-11-13 08:13:48 |
| Message-ID: | 20011113011348.A5207@iodynamics.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
I have made an interesting observation that SHOULD have been made before
(yeah, stupid of me not to have made this connection before):
The problem I'm having with the queries "hanging" is apparently happening
as soon as a VACUUM ANALYZE is done on the database. Until a VACUUM ANALYZE
is done, the database is speedy and responsive. As soon as a VACUUM ANALYZE
is performed, the same queries executed before spin indefinitely.
A VACUUM by itself doesn't bring on this behavior- so it must be the
ANALYZE portion.
Again, this is 7.1.3 built by Red Hat for Red Hat 7.2 running on an Athlon
1.0Ghz system. Please let me know what information could be helpful in
tracking down this "bug." Is it a bug?
-=Fozz
--
-------------------------------------------------------------------------
Doran L. Barton <fozz(at)iodynamics(dot)com> - Chief Super Hero - Iodynamics LLC
< http://www.iodynamics.com/ > - Linux solutions and dynamic websites
"We take your bags and send them in all directions."
-- Seen in a Copenhagen airline ticket office
| From | Date | Subject | |
|---|---|---|---|
| Next Message | N Waanders | 2001-11-13 11:29:02 | Installation problem |
| Previous Message | Derrick Hamner | 2001-11-13 01:02:39 | Incorrect text to timestamp conversion |