Re: Why will vacuum not end?
От | Bill Moran |
---|---|
Тема | Re: Why will vacuum not end? |
Дата | |
Msg-id | 40852218.2050204@potentialtech.com обсуждение исходный текст |
Ответ на | Re: Why will vacuum not end? ("Shea,Dan [CIS]" <Dan.Shea@ec.gc.ca>) |
Список | pgsql-performance |
Shea,Dan [CIS] wrote: > No, but data is constantly being inserted by userid scores. It is postgres > runnimg the vacuum. > Dan. > > -----Original Message----- > From: Christopher Kings-Lynne [mailto:chriskl@familyhealth.com.au] > Sent: Tuesday, April 20, 2004 12:02 AM > To: Shea,Dan [CIS] > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Why will vacuum not end? > >>This vacuum is running a marathon. Why will it not end and show me free >>space map INFO? We have deleted a lot of data and I would like to be >>confident that these deletions will be used as free space, rather than >>creating more table files. > > Does another postgres query running have a lock on that table? This may be a dumb question (but only because I don't know the answer) Doesn't/shouldn't vacuum have some kind of timeout so if a table is locked it will give up eventually (loudly complaining when it does so)? -- Bill Moran Potential Technologies http://www.potentialtech.com
В списке pgsql-performance по дате отправления: