Version of pg server is 8.3.10
We have some very large tables (78 gb/ 60m rows, 132 gb/90m rows).
Storage is mounted NFS on a netapp 3160 (pretty fast I/O).
However, the tables have been autovacuuming for over 3 days (from querying
pg-stat-activity).
The current_query column value is : "autovacuum
What platform is this running on? It looks as if someone executed a sql script
from the Windows environment that contains the control characters and pointed
it to postgres running on Linux/Unix.
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Marc
In my postgresql logs, found in the pg_log folder, there are several sql syntax
errors where the sql statement is broken up with the characters "^M". The error
is at the first field name that is broken up by the ^M as shown below in the
example. The ^M breaks up the field reference2zip by splitt
