Lists: | pgsql-performance |
---|
From: | "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca> |
---|---|
To: | 'Christopher Kings-Lynne' <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Why will vacuum not end? |
Date: | 2004-04-20 12:58:09 |
Message-ID: | F2D63B916C88C14D9B59F93C2A5DD33F0B923F@cisxa.cmc.int.ec.gc.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-performance |
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(at)familyhealth(dot)com(dot)au]
Sent: Tuesday, April 20, 2004 12:02 AM
To: Shea,Dan [CIS]
Cc: pgsql-performance(at)postgresql(dot)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?
Chris
From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
---|---|
To: | "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca> |
Cc: | 'Christopher Kings-Lynne' <chriskl(at)familyhealth(dot)com(dot)au>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Why will vacuum not end? |
Date: | 2004-04-20 13:14:00 |
Message-ID: | 40852218.2050204@potentialtech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | 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(at)familyhealth(dot)com(dot)au]
> Sent: Tuesday, April 20, 2004 12:02 AM
> To: Shea,Dan [CIS]
> Cc: pgsql-performance(at)postgresql(dot)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
From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Why will vacuum not end? |
Date: | 2004-04-21 01:26:27 |
Message-ID: | 4085CDC3.4090201@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-performance |
> No, but data is constantly being inserted by userid scores. It is postgres
> runnimg the vacuum.
> Dan.
Well, inserts create some locks - perhaps that's the problem...
Otherwise, check the pg_locks view to see if you can figure it out.
Chris