Re: Question about memory allocations

> Steve <cheetah@tanabi.org> writes:
>> - What is temp_buffers used for exactly?
>
> Temporary tables.  Pages of temp tables belonging to your own backend
> don't ever get loaded into the main shared-buffers arena, they are read
> into backend-local memory.  temp_buffers is the max amount (per backend)
> of local memory to use for this purpose.

 	Are these only tables explicitly stated as 'temporary' (which as I 
recall is a create table option) or are temporary tables used for other 
things to like, say, nested queries or other lil in the background things?

>> - Any idea if this is a smart configuration for this machine?
>
> Um ... you didn't mention which PG version?
>

 	The latest and greatest stable as downloaded a couple days ago. 
8.2.3. :)


Thanks for the info!


Steve