From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
Cc: | Alfred Perlstein <bright(at)wintelcom(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: =?iso-2022-jp?B?GyRCflYlaSVKJWQbKEI=?=: [HACKERS] Otvet: WAL and indexes (Re: [HACKERS] WAL status & todo) |
Date: | 2000-10-17 08:08:37 |
Message-ID: | 39EC0905.F46C6461@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Mikheev, Vadim" wrote:
> >> One of the purposes of WAL is immediate removing tuples
> >> inserted by aborted xactions. I want make VACUUM
> >> *optional* in future - space must be available for
> >> reusing without VACUUM. And this is first, very small,
> >> step in this direction.
> >
> >Why would vacuum become optional? Would WAL offer an option to
> >not reclaim free space? We're hoping that vacuum becomes unneeded
>
> Reclaiming free space is issue of storage manager, as
> I said here many times. WAL is just Write A-head Log
> (first write to log then to data files, to have ability
> to recover using log data) and for matter of space it can
> only help to delete tuples inserted by aborted transaction.
>
> >when postgresql is run with some flag indicating that we're
> >uninterested in time travel.
>
> Time travel is gone ~ 3 years ago and vacuum was needed all
> these years and will be needed to reclaim space in 7.1
>
> >How much longer do you estimate until you can make it work that way?
>
> Hopefully in 7.2
>
Just a confirmation.
Do you plan overwrite storage manager also in 7.2 ?
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB | 2000-10-17 08:29:37 | AW: Re: New relkind for views |
Previous Message | Devik | 2000-10-17 07:37:27 | Re: pgsql is 75 times faster with my new index scan |