Steve <cheetah@xxxxxxxxxx> 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
