On Thu, Apr 21, 2005 at 08:53:33PM -0400, Paul Tillotson wrote:
> 1) Does an update always go to the FSM to find out where to put the new
> tuple, or does it first try to put it in the current page, and only read
> the FSM if the current page is already full?
The latter.
> 2) Is it possible to write a where clause that can efficiently hit only
> the tuples in the end of the table? If there is a way, then I could
> test the idea without writing any code at all.
Not sure, but you could try using the ctid column.
--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Las cosas son buenas o malas segun las hace nuestra opinión" (Lisias)