| From: | Dan Moschuk <dan(at)freebsd(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: More vacuum troubles |
| Date: | 2000-11-10 20:03:19 |
| Message-ID: | 20001110150319.A2481@spirit.jaded.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
| | I've upgraded to 7.0.3, now I get...
| |
| | c2net=> vacuum verbose analyze some_table;
| | NOTICE: --Relation some_table--
| |
| | It's been sitting like that for about half an hour now. There's only
| | about 3000 records in that table.
|
| As a side note, when I ^C the vacuum I get..
|
| ^CCancel request sent
| pqReadData() -- backend closed the channel unexpectedly.
| This probably means the backend terminated abnormally
| before or while processing the request.
| The connection to the server was lost. Attempting reset: Succeeded.
| c2net=>
|
| The very next vacuum I do produces the exact same response. The next one
| after that though continues..
And as another side note :) ...
vacuum some_table (without the analyze) completes quite happily.
Cheers,
-Dan
--
Man is a rational animal who always loses his temper when he is called
upon to act in accordance with the dictates of reason.
-- Oscar Wilde
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Moschuk | 2000-11-10 20:06:48 | Re: More vacuum troubles |
| Previous Message | Dan Moschuk | 2000-11-10 19:53:16 | Re: More vacuum troubles |