Tom Lane wrote:
Heikki Linnakangas <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
(Note that COPY per se will not trigger this behavior anyway, since it
will act in a limited number of buffers because of the recent buffer
access strategy patch.)

Actually we dropped it from COPY, because it didn't seem to improve performance in the tests we ran.

Who's "we"?  AFAICS, CVS HEAD will treat a large copy the same as any
other large heapscan.

Umm, I'm talking about populating a table with COPY *FROM*. That's not a heap scan at all.

  Heikki Linnakangas

---------------------------(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

Reply via email to