All Questions
4 questions
7
votes
3
answers
6k
views
Is it possible to never run vacuum full in PostgreSQL
Since a VACUUM FULL locks tables, it is unacceptable for us in our production environment.
Is it possible to only run VACUUM and never VACUUM FULL on a production system?
Does VACUUM make space ...
- 825
3
votes
1
answer
3k
views
How do we get around PostgreSQL autovacuum taking a table-level lock ACCESS EXCLUSIVE on replicas?
We are running:
user@primary/client-n:~$ psql -d database -c "SELECT version();"
version
--------------------------------------------...
- 947
2
votes
1
answer
1k
views
Will insert and update wait while a table is being vacuumed?
I want to vacuum a table in PostgreSQL version 9.1 which will take between 10 to 12 minutes. This needs to be done in real-time, in production use.
I just want to know that if any INSERT or UPDATE ...
- 279
2
votes
4
answers
4k
views
postgresql cannot drop a table when autovacuum holds lock on it
Autovacuuming process holds RowExclusiveLock and ShareUpdateExclusiveLock on the table, which I want to drop. I read that autovacuum should be canceled automatically, when submitting DROP TABLE ...
- 193