> 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