| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Fix mdsync never-ending loop problem |
| Date: | 2007-04-05 10:46:39 |
| Message-ID: | 4614D38F.2060902@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Here's a fix for the problem that on a busy system, mdsync never
finishes. See the original problem description on hackers:
http://archives.postgresql.org/pgsql-hackers/2007-04/msg00259.php
The solution is taken from ITAGAKI Takahiro's Load Distributed
Checkpoint patch. At the beginning of mdsync, the pendingOpsTable is
copied to a linked list, and that list is then processed until it's empty.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| fix_neverending_mdsync_loop.patch | text/x-diff | 10.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2007-04-05 10:58:40 | Re: Checkpoint gets stuck in mdsync |
| Previous Message | Stuart Bishop | 2007-04-05 10:23:09 | Re: elog(FATAL) vs shared memory |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | NikhilS | 2007-04-05 11:05:31 | Re: Auto Partitioning |
| Previous Message | Simon Riggs | 2007-04-05 09:34:50 | Re: [HACKERS] Full page writes improvement, code update |