pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedissue pgsql_tmp keeps increasing
2+ messages / 2 participants
[nested] [flat]
* issue pgsql_tmp keeps increasing
@ 2010-09-17 01:20 donghe@caltech.edu
0 siblings, 1 reply; 2+ messages in thread
From: donghe@caltech.edu @ 2010-09-17 01:20 UTC (permalink / raw)
To: pgsql-admin
Hi,
I use psql (PostgreSQL) 8.1.10 on my box, there is a postmater process
running automatically to make temp files in pgsql_tmp folder, I don't do
any query on my database. Anybody knows what's wrong with it? and how to
find what the postmater process is for
Thanks
Dong He
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: issue pgsql_tmp keeps increasing
@ 2010-09-17 01:35 Tom Lane <tgl@sss.pgh.pa.us>
parent: donghe@caltech.edu
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2010-09-17 01:35 UTC (permalink / raw)
To: donghe@caltech.edu; +Cc: pgsql-admin
donghe@caltech.edu writes:
> I use psql (PostgreSQL) 8.1.10 on my box, there is a postmater process
> running automatically to make temp files in pgsql_tmp folder, I don't do
> any query on my database. Anybody knows what's wrong with it? and how to
> find what the postmater process is for
Look in pg_stat_activity, perhaps. In 8.1 that won't show you the
actual command unless you changed some default settings, but it should
at least tell you when the command was started and by whom.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-09-17 01:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-09-17 01:20 issue pgsql_tmp keeps increasing donghe@caltech.edu
2010-09-17 01:35 ` Re: issue pgsql_tmp keeps increasing Tom Lane <tgl@sss.pgh.pa.us>
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