Re: Updated ALTER TABLE ... SET TABLESPACE patch - Mailing list pgsql-patches

From Tom Lane
Subject Re: Updated ALTER TABLE ... SET TABLESPACE patch
Date
Msg-id 3944.1089600846@sss.pgh.pa.us
Whole thread Raw
In response to Re: Updated ALTER TABLE ... SET TABLESPACE patch  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-patches
Gavin Sherry <swm@linuxworld.com.au> writes:
> On Mon, 12 Jul 2004, Christopher Kings-Lynne wrote:
>> I vote for taking it out.

> Pull it.  I added it intentionally but now I'm questioning my reasoning
> (which was, sequences might be accessed lots, people might want to put
> them somewhere intentionally).

I thought about that, but AFAICS a heavily used sequence would merely
end up as a single hot entry in the shared buffer arena (or at worst,
an often-hit page in kernel buffers).  It could not result in a lot of
actual I/O because it's only one page; at most one would expect one
write per checkpoint cycle.  So putting it on particularly fast disk
would be a useless exercise.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Updated ALTER TABLE ... SET TABLESPACE patch
Next
From: Tom Lane
Date:
Subject: Re: Updated ALTER TABLE ... SET TABLESPACE patch