pg_subtrans directory grows over 1 GB, is there a way to control it?

Поиск
Список
Период
Сортировка
От Dennis Wang
Тема pg_subtrans directory grows over 1 GB, is there a way to control it?
Дата
Msg-id BAY137-W50DCFFB333D7318AD4F557D6C80@phx.gbl
обсуждение исходный текст
Ответы Re: pg_subtrans directory grows over 1 GB, is there a way to control it?
Re: pg_subtrans directory grows over 1 GB, is there a way to control it?
Список pgsql-interfaces
I am using PostgreSQL database in a location recognition application, the files under postgresql/cluster is growing
andover a few days it become very large as below. <br />    /var/opt/postgresql/cluster/data  166015 Kilobytes  (the
actualdatabase data)<br />    /var/opt/postgresql/cluster/sys/pg_clog 74188 Kilobytes  (transaction commit status
data)<br/>    /var/opt/postgresql/cluster/sys/pg_subtrans   1187032 Kilobytes (transaction status data)<br /><br />The
pg_clogand pg_subtrans can grow when database contains more data and more queries come in. But these figures looks
ratherlarge to me because the queries goes in the database are mainly read operation rather than write one. I got a few
questionto ask here:<br />     Is there a way to control the size of pg_clog and pg_subtrans? <br />     Is the file
sizestill be normal for the database of this size (166MB for cluster/data)?<br />     Does the larger pg_subtrans
indicatesome bad transaction happens in the database?<br /><br />You expertise is very appreciated.<br /><br
/>Thanks<br/><br />Dennis<br /><br /><br /><br /><hr />Find out: SEEK Salary Centre <a
href="http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Eseek%2Ecom%2Eau%2Fcareer%2Dresources%2Fsalary%2Dcentre%2F%3Ftracking%3Dsk%3Ahet%3Asc%3Anine%3A0%3Ahot%3Atext&_t=764565661&_r=OCT07_endtext_salary&_m=EXT"
target="_new">Areyou paid what you're worth?</a> 

В списке pgsql-interfaces по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: Function's final statement must be a SELECT
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_subtrans directory grows over 1 GB, is there a way to control it?