RE: [HACKERS] Re: ?????: ?????: WAL and indexes (Re: [HACKERS] WAL status & todo)

2000-10-17 Thread Mikheev, Vadim
> I'm still nervous about how we're going to test the WAL code > adequately for the lesser-used index types. Any ideas out there? First, seems we'll have to follow to what you've proposed for their redo/undo: log each *fact* of changing a page to know was update op done entirely or not (rebuild

[HACKERS] Ответ: [HACKERS] ????: [HACKERS] Otvet: WAL and indexes (Re: [HACKERS] WAL status & todo)

2000-10-17 Thread Mikheev, Vadim
> Just a confirmation. > Do you plan overwrite storage manager also in 7.2 ? Yes if I'll get enough time. Vadim

Re: [HACKERS] $B~V%i%J%d(B: [HACKERS] Otvet: WAL and indexes (Re: [HACKERS] WAL status & todo)

2000-10-17 Thread Hiroshi Inoue
"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 w

Re: [HACKERS] Re: ?????: ?????: WAL and indexes (Re: [HACKERS] WAL status& todo)

2000-10-16 Thread Bruce Momjian
> "Mikheev, Vadim" <[EMAIL PROTECTED]> writes: > > And how could I use such records on recovery > > being unable to know what data columns represent > > keys, what functions should be used for ordering? > > Um, that's not built into the index either, is it? OK, you win ... > > I'm still nervous

[HACKERS] Ответ: [HACKERS] Otvet: WAL and indexes (Re: [HACKERS] WAL status & todo)

2000-10-16 Thread Mikheev, Vadim
>> 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

[HACKERS] Re: Ответ: Ответ: WAL and indexes (Re: [HACKERS] WAL status & todo)

2000-10-16 Thread Tom Lane
"Mikheev, Vadim" <[EMAIL PROTECTED]> writes: > And how could I use such records on recovery > being unable to know what data columns represent > keys, what functions should be used for ordering? Um, that's not built into the index either, is it? OK, you win ... I'm still nervous about how we're

[HACKERS] Ответ: Ответ: WAL and indexes (Re: [HACKERS] WAL status & todo)

2000-10-16 Thread Mikheev, Vadim
>>> I don't understand why WAL needs to log internal operations of any of >>> the index types. Seems to me that you could treat indexes as black >>> boxes that are updated as side effects of WAL log items for heap tuples: >>> when adding a heap tuple as a result of a WAL item, you just call the >

Re: [HACKERS] Re: Otvet: WAL and indexes (Re: [HACKERS] WAL status & todo)

2000-10-16 Thread Alfred Perlstein
* Tom Lane <[EMAIL PROTECTED]> [001016 09:47] wrote: > "Mikheev, Vadim" <[EMAIL PROTECTED]> writes: > >> I don't understand why WAL needs to log internal operations of any of > >> the index types. Seems to me that you could treat indexes as black > >> boxes that are updated as side effects of WAL

[HACKERS] Re: Ответ: WAL and indexes (Re: [HACKERS] WAL status & todo)

2000-10-16 Thread Tom Lane
"Mikheev, Vadim" <[EMAIL PROTECTED]> writes: >> I don't understand why WAL needs to log internal operations of any of >> the index types. Seems to me that you could treat indexes as black >> boxes that are updated as side effects of WAL log items for heap tuples: >> when adding a heap tuple as a

Re: [HACKERS] Otvet: WAL and indexes (Re: [HACKERS] WAL status & todo)

2000-10-16 Thread Alfred Perlstein
* Mikheev, Vadim <[EMAIL PROTECTED]> [001016 09:33] wrote: > >I don't understand why WAL needs to log internal operations of any of > >the index types. Seems to me that you could treat indexes as black > >boxes that are updated as side effects of WAL log items for heap tuples: > >when adding a he

[HACKERS] Ответ: WAL and indexes (Re: [HACKERS] WAL status & todo)

2000-10-16 Thread Mikheev, Vadim
>I don't understand why WAL needs to log internal operations of any of >the index types. Seems to me that you could treat indexes as black >boxes that are updated as side effects of WAL log items for heap tuples: >when adding a heap tuple as a result of a WAL item, you just call the >usual index

WAL and indexes (Re: [HACKERS] WAL status & todo)

2000-10-16 Thread Tom Lane
"Vadim Mikheev" <[EMAIL PROTECTED]> writes: > 3. There are no redo/undo for HASH, RTREE & GIST yet. This would be *really > really > great* if someone could implement it using BTREE' redo/undo code as > prototype. > These are the most complex parts of this todo. I don't understand why WAL

[HACKERS] Ответ: [HACKERS] WAL status & todo

2000-10-15 Thread Mikheev, Vadim
>> Well, hopefully WAL will be ready for alpha testing in a few days. >> Unfortunately at the moment I have to step side from main stream >> to implement new file naming, the biggest todo for integration WAL into system. >> >> I would really appreciate any h

Re: [HACKERS] WAL status & todo

2000-10-15 Thread Martin A. Marques
On Sat, 14 Oct 2000, Vadim Mikheev wrote: > Well, hopefully WAL will be ready for alpha testing in a few days. > Unfortunately > at the moment I have to step side from main stream to implement new file > naming, > the biggest todo for integration WAL into system. > > I would really appreciate any

[HACKERS] WAL status & todo

2000-10-14 Thread Vadim Mikheev
Well, hopefully WAL will be ready for alpha testing in a few days. Unfortunately at the moment I have to step side from main stream to implement new file naming, the biggest todo for integration WAL into system. I would really appreciate any help in the following issues (testing can start regardl