pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Where are the temporary work / sort files please
3+ messages / 3 participants
[nested] [flat]

* Where are the temporary work / sort files please
@ 2006-07-13 04:14  adey <adey11@gmail.com>
  0 siblings, 2 replies; 3+ messages in thread

From: adey @ 2006-07-13 04:14 UTC (permalink / raw)
  To: pgsql-admin; postgresql-l <postgresql-l@Groups.ittoolbox.com>

The postgresql parameter explanation for work_mem say :-

"Another way to set this value is to monitor the Postgres temp files
(in PGDATA/base/DB_OID/pgsql_tmp) and adjust sort_mem
upward if you see a lot of queries swapping from these temp files."

...but I can't find pgsql_tmp in my v8.1.4 installation.
Where can I find these temp files please?

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Where are the temporary work / sort files please
@ 2006-07-13 08:14  Andy Shellam <andy@andycc.net>
  parent: adey <adey11@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Andy Shellam @ 2006-07-13 08:14 UTC (permalink / raw)
  To: adey <adey11@gmail.com>; pgsql-admin

These do exist as the documentation says - I found them in my 8.1.3 
install, but only for a couple of databases.  Perhaps they're only used 
when there has a need to be swapping data to disk?



adey wrote:
> The postgresql parameter explanation for work_mem say :-
>  
> "Another way to set this value is to monitor the Postgres temp files
> (in PGDATA/base/DB_OID/pgsql_tmp) and adjust sort_mem
> upward if you see a lot of queries swapping from these temp files."
>  
> ...but I can't find pgsql_tmp in my v8.1.4 installation.
> Where can I find these temp files please?
>  
> !DSPAM:14,44b5cb6f34532045524622! 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Where are the temporary work / sort files please
@ 2006-07-13 15:34  Chris Browne <cbbrowne@acm.org>
  parent: adey <adey11@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Chris Browne @ 2006-07-13 15:34 UTC (permalink / raw)
  To: pgsql-admin

adey11@gmail.com (adey) writes:
> ...but I can't find pgsql_tmp in my v8.1.4 installation.
>
> Where can I find these temp files please?

They get created on demand, and go away when that demand disappears.

Run a big REINDEX and you'll see them pop into place...
-- 
output = ("cbbrowne" "@" "ntlug.org")
http://cbbrowne.com/info/sap.html
"...Roxanne falls in love with Christian, a chevalier in Cyrano's
regiment who hasn't got the brains God gave an eclair..."
-- reviewer on NPR



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-07-13 15:34 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-13 04:14 Where are the temporary work / sort files please adey <adey11@gmail.com>
2006-07-13 08:14 ` Andy Shellam <andy@andycc.net>
2006-07-13 15:34 ` Chris Browne <cbbrowne@acm.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox