From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Vacuum Question |
Date: | 2000-06-06 14:17:40 |
Message-ID: | 393D0804.EFA07399@austin.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
>
> Ed Loehr <eloehr(at)austin(dot)rr(dot)com> writes:
> >> Then, start this one in another bash window/terminal/whatever...
> >>
> >> % while test 1; do echo -n "`date`: "; psql -d pdb -c "vacuum analyze;
> >> select count(*) from foo;"; sleep 3; done
> >>
> >> This seems to consistently crash after the first vacuum with the
> >> following message:
>
> This is a known gotcha that's got nothing to do with any sort of
> concurrency. You can't safely send a VACUUM followed by anything
> else in a single query string.
Well, I thought that select count(*) might've been causing a problem, so
I experimented without it and found the same problem. Doesn't seem to
happen with 'vacuum'or 'vacuum analyze foo', only 'vacuum analyze'...
Regards,
Ed Loehr
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2000-06-06 14:19:45 | Re: Errors attempting to insert duplicate values |
Previous Message | Travis Bauer | 2000-06-06 13:37:52 | Precision of calculated numeric fields |