HUGE pg_sorttemp files, can I delete?
От | Micah Anderson |
---|---|
Тема | HUGE pg_sorttemp files, can I delete? |
Дата | |
Msg-id | 20001114144906.G24165@psasolar.colltech.com обсуждение исходный текст |
Ответы |
Re: HUGE pg_sorttemp files, can I delete?
|
Список | pgsql-general |
In my /var/postgres/base/database directory I've got a bunch of REALLY big files that are from several months ago: -rw------- 1 postgres postgres 191684608 Oct 30 23:35 pg_sorttemp10964.0 -rw------- 1 postgres postgres 192126976 Oct 30 23:44 pg_sorttemp11353.0 -rw------- 1 postgres postgres 192126976 Oct 30 23:44 pg_sorttemp11369.0 -rw------- 1 postgres postgres 983040 Oct 23 17:37 pg_sorttemp22475.0 -rw------- 1 postgres postgres 26787840 Oct 21 14:00 pg_sorttemp2372.0 -rw------- 1 postgres postgres 130465792 Nov 9 13:42 pg_sorttemp30831.0 -rw------- 1 postgres postgres 232701952 Oct 30 20:41 pg_sorttemp5564.0 -rw------- 1 postgres postgres 232701952 Oct 30 20:41 pg_sorttemp5576.0 -rw------- 1 postgres postgres 232701952 Oct 30 20:41 pg_sorttemp5588.0 -rw------- 1 postgres postgres 232792064 Oct 30 20:41 pg_sorttemp5749.0 -rw------- 1 postgres postgres 190275584 Oct 30 20:41 pg_sorttemp6480.0 -rw------- 1 postgres postgres 190275584 Oct 30 20:41 pg_sorttemp6494.0 There are some there that are from today - but from Oct 30? Can I delete these files? What are causing these? Can I set a limit or something? My database is 3.6 gigs, that is HUGE. I think it is largely because of these files. Thanks! Micah -- Micah Anderson Collective Technologies www.colltech.com "To be and not to do is not to be at all"
В списке pgsql-general по дате отправления: