| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: temp_buffers |
| Date: | 2005-07-07 23:24:08 |
| Message-ID: | 20050707232408.GA28108@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"¿Que diferencia tiene para los muertos, los huérfanos, y aquellos que han
perdido su hogar, si la loca destrucción ha sido realizada bajo el nombre
del totalitarismo o del santo nombre de la libertad y la democracia?" (Gandhi)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Alcorn | 2005-07-07 23:41:10 | Re: SQL99 - Nested Tables |
| Previous Message | Joshua D. Drake | 2005-07-07 23:16:58 | temp_buffers |