Re: Question about memory allocations

From: Steve
Subject: Re: Question about memory allocations
Date: ,
Msg-id: Pine.GSO.4.64.0704121242250.17955@kittyhawk.tanabi.org
(view: Whole thread, Raw)
In response to: Re: Question about memory allocations  (Tom Lane)
List: pgsql-performance

Tree view

how to efficiently update tuple in many-to-many relationship?  (Drew Wilson, )
 Re: how to efficiently update tuple in many-to-many relationship?  ("Merlin Moncure", )
 Re: how to efficiently update tuple in many-to-many relationship?  (Tom Lane, )
  Re: how to efficiently update tuple in many-to-many relationship?  (Drew Wilson, )
   Re: how to efficiently update tuple in many-to-many relationship?  (Tom Lane, )
    Re: how to efficiently update tuple in many-to-many relationship?  (Drew Wilson, )
     Re: how to efficiently update tuple in many-to-many relationship?  (Tom Lane, )
      Re: how to efficiently update tuple in many-to-many relationship?  (Drew Wilson, )
       Re: how to efficiently update tuple in many-to-many relationship?  (Tom Lane, )
        Question about memory allocations  (Steve, )
         Re: Question about memory allocations  (Tom Lane, )
          Re: Question about memory allocations  (Steve, )
         Re: Question about memory allocations  (Greg Smith, )
          Re: Question about memory allocations  (Steve, )
         Re: Question about memory allocations  (Andrew McMillan, )
          Re: Question about memory allocations  (Steve, )
           Re: Question about memory allocations  (Ron, )
            Re: Question about memory allocations  (Tom Lane, )
           Re: Question about memory allocations  (Carlos Moreno, )
            Re: Question about memory allocations  ("Jan de Visser", )

> Steve <> 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


pgsql-performance by date:

From: Steve
Date:
Subject: Re: Strangely Variable Query Performance
From: Tom Lane
Date:
Subject: Re: Strangely Variable Query Performance