| From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | "Tomeh, Husam" <htomeh(at)firstam(dot)com> |
| Cc: | Adnan DURSUN <a_dursun(at)hotmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL Caching |
| Date: | 2006-10-04 13:52:26 |
| Message-ID: | 1159969946.15773.23.camel@dba5.int.libertyrms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-performance |
On Tue, 2006-10-03 at 18:29 -0700, Tomeh, Husam wrote:
> >> * When any session updates the data that already in shared
> buffer,
> >>does Postgres synchronize the data both disk and shared buffers area
> >> immediately ?
>
> Not necessarily true. When a block is modified in the shared buffers,
> the modified block is written to the Postgres WAL log. A periodic DB
> checkpoint is performed to flush the modified blocks in the shared
> buffers to the data files.
Postgres 8.0 and beyond have a process called bgwriter that continually
flushes dirty buffers to disk, to minimize the work that needs to be
done at checkpoint time.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-10-04 19:31:15 | Re: error compiling 7.4.13 on OSX 10.4.8 -- Intel |
| Previous Message | Brad Nicholson | 2006-10-04 13:47:05 | Re: PostgreSQL Caching |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2006-10-04 14:07:03 | Re: simple case using index on windows but not on linux |
| Previous Message | simon godden | 2006-10-04 13:47:43 | Re: simple case using index on windows but not on linux |