From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [COMMITTERS] pgsql: Do all accesses to shared buffer headers through |
Date: | 2005-10-13 02:29:32 |
Message-ID: | 200510130229.j9D2TWi02519@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
Does any of this need to be backpatched?
---------------------------------------------------------------------------
Tom Lane wrote:
> Log Message:
> -----------
> Do all accesses to shared buffer headers through volatile-qualified
> pointers, to ensure that compilers won't rearrange accesses to occur
> while we're not holding the buffer header spinlock. It's probably
> not necessary to mark volatile in every single place in bufmgr.c,
> but better safe than sorry. Per trouble report from Kevin Grittner.
>
> Modified Files:
> --------------
> pgsql/contrib/pg_buffercache:
> pg_buffercache_pages.c (r1.4 -> r1.5)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_buffercache/pg_buffercache_pages.c.diff?r1=1.4&r2=1.5)
> pgsql/src/backend/storage/buffer:
> bufmgr.c (r1.195 -> r1.196)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/bufmgr.c.diff?r1=1.195&r2=1.196)
> freelist.c (r1.52 -> r1.53)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/freelist.c.diff?r1=1.52&r2=1.53)
> pgsql/src/include/storage:
> buf_internals.h (r1.79 -> r1.80)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/buf_internals.h.diff?r1=1.79&r2=1.80)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-10-13 02:46:14 | Re: [COMMITTERS] pgsql: Do all accesses to shared buffer headers through |
Previous Message | Bruce Momjian | 2005-10-13 02:23:12 | pgsql: Update trigger demo to reflect new trigger ordering. |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-10-13 02:46:14 | Re: [COMMITTERS] pgsql: Do all accesses to shared buffer headers through |
Previous Message | Christopher Kings-Lynne | 2005-10-13 02:15:48 | Re: Comments on columns in the pg_catalog tables/views |