Skip site navigation (1) Skip section navigation (2)

Re: pgsql is 75 times faster with my new index scan

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: devik(at)cdi(dot)cz, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pgsql is 75 times faster with my new index scan
Date: 2000-09-26 10:59:46
Message-ID: 39D081A2.9059FAC9@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers

Hannu Krosing wrote:

>
> >
> > TODO:
> > - add HeapTupleHeaderData into each IndexTupleData
> > - change code to reflect above
> > - when deleting-updating heap then also update tuples'
> >   HeapTupleHeaderData in indices
>
> I doubt everyone would like trading query speed for insert/update
> speed plus index size
>
> Perhaps this could be implemented as a special type of index which
> you must explicitly specify at create time ?
>
> > The last step could be done in two ways. First by limiting
> > number of indices for one table we can store coresponding
> > indices' TIDs in each heap tuple. The update is then simple
> > taking one disk write.
>
> Why limit it ? One could just save an tid array in each tuple .
>

Indice's TIDs are transient.
Isn't it useless to store indice's TIDs ?

Regards.

Hiroshi Inoue


In response to

Responses

pgsql-hackers by date

Next:From: devikDate: 2000-09-26 11:13:40
Subject: Re: pgsql is 75 times faster with my new index scan
Previous:From: Hannu KrosingDate: 2000-09-26 10:35:24
Subject: Re: Case sensitive field names

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group