Re: Autovacuum in the backend
| От | Qingqing Zhou |
|---|---|
| Тема | Re: Autovacuum in the backend |
| Дата | |
| Msg-id | d8or3d$1bgq$1@news.hub.org обсуждение исходный текст |
| Ответ на | Autovacuum in the backend (Bruce Momjian <pgman@candle.pha.pa.us>) |
| Ответы |
Re: Autovacuum in the backend
|
| Список | pgsql-hackers |
"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes > > The start/stop routine is quite like Bgwriter. > I just realized that the non-standard backend can't execute any SQL command. If so, how would the background pg_autovacuum do "vacuum"? It could be forked more like a standard backend, but this is obviously not a good idea, since we don't know which database this process will sit on. A possible solution is that backgroud pg_autovacuum could fork another process to connect to postmaster as an ordinary backend each time it feels that a "vacuum" is needed. Any ideas? Regards, Qingqing
В списке pgsql-hackers по дате отправления: