Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Thu, Jul 07, 2005 at 04:16:58PM -0700, Joshua D. Drake wrote:
>> Can someone give me a reasonable explanation of what temp_buffers is for?
> Number of buffers to be used for temp tables. Think shared_buffers, but
> local to a connection instead of shared.
> They are also used for new relations, in the transaction they are being
> created. Because no one else can see the relation, there's no point in
> sharing their pages.
No, temp buffers are *only* used for temp tables. Several versions back
the code acted as you say, but we got rid of that because it was more of
a headache than it was worth.
regards, tom lane
---------------------------(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
match
