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

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

From: devik(at)cdi(dot)cz
To: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pgsql is 75 times faster with my new index scan
Date: 2000-09-28 12:02:35
Message-ID: 39D3335B.C53CBAD4@cdi.cz (view raw or flat)
Thread:
Lists: pgsql-hackers
> > The it will be MUCH faster to create secondary index which
> > is much smaller than heap and use values from it.
> 
> Agreed. But this will add 16 bytes (2 xid + 2 cid) to size of btitems.
> Currently, total size of btitem for 2-int4 key index is 16 bytes =>
> new feature will double size of index and increase # of levels
> (obviously bad for mostly static tables).
> 
> So, this feature should be *optional*...

yes. it definitely should.

> MVCC will not be affected by WAL currently. It's issue
> of storage manager, not WAL.

and where will the WAL sit ? can you explain it a bit ?

thanks devik


In response to

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2000-09-28 13:08:28
Subject: Re: Installation layout is still hazardous for shared prefixes
Previous:From: devikDate: 2000-09-28 12:01:14
Subject: Re: pgsql is 75 times faster with my new index scan

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