Re: Question about memory allocations

> Steve <cheetah(at)tanabi(dot)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