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 (<[EMAIL PROTECTED]>) "Las cosas son buenas o malas segun las hace nuestra opinión" (Lisias) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
