Skip site navigation (1) Skip section navigation (2)

Re: Sorting writes during checkpoint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Sorting writes during checkpoint
Date: 2008-07-04 16:05:54
Message-ID: 23541.1215187554@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> Anyway, I note that we don't have an easy way of sorting by tablespace,

Say what?  tablespace is the first component of relfilenode.

> but I'm sure it would be possible to look up the tablespace for a file
> within a plugin.

If the information weren't readily available from relfilenode, it would
*not* be possible for a bufmgr plugin to look it up.  bufmgr is much too
low-level to be dependent on performing catalog lookups.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-07-04 16:15:03
Subject: Re: pgsql: Fix a couple of bugs in win32 shmem name generation: * Don't cut
Previous:From: Tom LaneDate: 2008-07-04 16:01:12
Subject: Re: [PATCHES] Explain XML patch v2

pgsql-patches by date

Next:From: Simon RiggsDate: 2008-07-04 16:20:48
Subject: Re: Explain XML patch v2
Previous:From: Tom LaneDate: 2008-07-04 16:01:12
Subject: Re: [PATCHES] Explain XML patch v2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group