| 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: | Whole Thread | Raw Message | 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 |