i try to compare two methods of garbage-collect.(Postgresql Ver:8.1.3)
1. enable autovacuum without using vacuumdb -f mydb in crontab.
2. using crontab to vacuumdb in every 10 min (autovacuum disable)
the method 2 got more free space than method 1.
the disk size of database still increas
i try to compare two methods of garbage-collect.(Postgresql Ver:8.1.3)
1. enable autovacuum without using vacuumdb -f mydb in crontab.
2. using crontab to vacuumdb in every 10 min (autovacuum disable)
the method 2 got more free space than method 1.
the disk size of database still increas
http://www.postgresql.org/docs/8.1/interactive/maintenance.html#VACUUM-FOR-WRAPAROUND
XID is transcation ID?
so, "select * from mydb" is a transcation?
if i executed "select * from mydb" twice, the XID wil be increased by 2
or ,just the "update","delete" command can be counted
--
View this mes
Tom Lane-2 wrote:
>
> Jeff Frost <[EMAIL PROTECTED]> writes:
>> On Thu, 27 Dec 2007, Tom Lane wrote:
>>> There's no global counter. There's a backend-local "virtual transaction
>>> id" counter.
>
>> That's a drag as I have quite a few clients who graph the xacts/sec with
>> MRTG.
>> Most of t
> mydb age:33193
why always increased by 5?
Postgresql Ver:8.1.3
using pgAdminIII Query window
Andrew Sullivan wrote:
>
> On Wed, Dec 26, 2007 at 05:48:14PM -0800, ivan.hou wrote:
>>
>> XID is transcation ID?
>
> Yes.
>
>> so, "select * from mydb&q
how do u know this theory ? 1 + (2 * number of columns in the SELECT)
just try & test? or have any document?
Guillaume Lelarge-3 wrote:
>
> Tom Lane wrote:
>> "ivan.hou" <[EMAIL PROTECTED]> writes:
>>> step 1. SELECT datname, age(datfrozenxid) FROM pg_da
