Hello,
well Ｉcouldn't turn off my antivirus since it is controlled by our IT
management team. However, since I rebuilt the indexes, the query has
been running fine. I don't understand what happpened. Before asking for
help, I made sure I could repeat the problem over several reboots.
Emilie Laffray
Richard Huxton wrote:
Emilie Laffray wrote:
3) I have an antivirus running, but again this antivirus has been
running for months and I have worked on postgresql also for months.
There has been an update yesterday to that antivirus, but I don't think
it had an impact.
I tried also in the meantime to run a vacuum, and I got some messages
that the indexes had a problem and it was working to fix it. It crashed.
I restarted my pc and could perform the vacuum just fine afterwards.
I don't run PG on Windows other than to test, but this definitely sounds
like antivirus problems to me. They're quite sophisticated nowadays and
it might be that it takes a certain pattern of activity to trigger it.
Try (1) turning your antivirus off and running the update and if that
works, (2) excluding all the data directories and PostgreSQL from it's
checking.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
