Re: Vacuum Question

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