| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> |
| Cc: | "Magnus Hagander" <magnus(at)hagander(dot)net>, "Jim C(dot) Nasby" <jim(at)nasby(dot)net>, "Patrick Earl" <patearl(at)patearl(dot)net>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Checkpoint request failed on version 8.2.1. |
| Date: | 2007-01-16 05:29:22 |
| Message-ID: | 15400.1168925362@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
"Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> writes:
> BTW, why does the bgwriter try to open and write the pages of already
> dropped relations?
It does not; the problem is with stale fsync requests.
> If the relation being dropeed has
> already been registered in the list of files to be fsynced, isn't it
> possible to remove the file from the list before unlinking the file,
> asking bgwriter in a similar way as ForwardFsyncRequest()?
I suggested that here
http://archives.postgresql.org/pgsql-hackers/2007-01/msg00642.php
but have received no feedback about it ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scara Maccai | 2007-01-16 09:08:35 | Very long "or" where clause |
| Previous Message | Tom Lane | 2007-01-16 05:26:05 | Re: Improve Postgres Query Speed |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Cave-Ayland | 2007-01-16 08:23:12 | Re: Function execution costs 'n all that |
| Previous Message | Tom Lane | 2007-01-16 05:07:12 | Re: xml type and encodings |