Обсуждение: autovacuum questions v2
Hello community, we are running a CRM system with Postgres database (version 8.3). To organize handwritten contracts we save them scanned as LOBs. Normally they are unlinked in case of deleting them. However we run a cron job which does vacuumlo to get save that there is nothing in the nirvana. My Question: Does the autovacuum also what vacuumlo does or is there a way to specify this in the configuration? -- Cheers Alexander Strotmann
Alexander Strotmann a écrit : > [...] > we are running a CRM system with Postgres database (version 8.3). To > organize handwritten contracts we save them scanned as LOBs. Normally > they are unlinked in case of deleting them. However we run a cron job > which does vacuumlo to get save that there is nothing in the nirvana. > My Question: Does the autovacuum also what vacuumlo does or is there a > way to specify this in the configuration? > Nope. vacuumlo and lo contrib modules are still needed. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com