Re: [HACKERS] LONG - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] LONG
Date
Msg-id 199912112328.SAA13267@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] LONG  (wieck@debis.com (Jan Wieck))
List pgsql-hackers
> > At least this is my impression from some descriptions, and it also
> > seems reasonable thing to do in general as we dont want to read in
> > 500K tuples (and then sort them) just to join on int fields and filter
> > out on boolean and count(n) < 3.
> 
>     Even  if  this  is  a  side  effect  I  haven't  seen  at the
>     beginning, it would be one of the  best  side  effect's  I've
>     ever  seen.  A  really  tempting  one  that's worth to try it
>     anyway.
> 

Or make struct varlena vl_len a 15-bit field, and make islong a 1-bit
field.  I don't remember if using & manually or bit fields is faster.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] LONG
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] LONG