Re: [PATCHES] [HACKERS] Including Snapshot Info with Indexes

I am not seeing my mail getting listed in the archives. So i am just resending it, in case the above one has got missed. Thanks, Gokul. On Jan 28, 2008 4:14 PM, Gokulakannan Somasundaram <[EMAIL PROTECTED]> wrote: > > Doh! Can you please send another patch with gram.y as we

Re: [PATCHES] [HACKERS] Including Snapshot Info with Indexes

is <[EMAIL PROTECTED]> wrote: > On Jan 23, 2008 11:28 AM, Gokulakannan Somasundaram <[EMAIL PROTECTED]> > wrote: > > Fixed a type 'o' > > I'm playing with this now against 8.3 HEAD. Looks like there's a > couple things which are problematic: > &

Re: [PATCHES] [HACKERS] Including Snapshot Info with Indexes

Fixed a type 'o' On Jan 23, 2008 9:28 PM, Gokulakannan Somasundaram <[EMAIL PROTECTED]> wrote: > This fixes the bug in dealing with scans with 'or' conditions. I have also > attached the design document. > > > Thanks, > Gokul. > > > On Jan

Re: [PATCHES] [HACKERS] Including Snapshot Info with Indexes

This fixes the bug in dealing with scans with 'or' conditions. I have also attached the design document. Thanks, Gokul. On Jan 16, 2008 7:25 PM, Gokulakannan Somasundaram <[EMAIL PROTECTED]> wrote: > Hi, > I did some more bug fixes and performance updates especiall

Re: [PATCHES] [HACKERS] Including Snapshot Info with Indexes

Hi, I did some more bug fixes and performance updates especially for select count(1) queries. Thanks, Gokul. patchfile.tar.gz Description: GNU Zip compressed data ---(end of broadcast)--- TIP 5: don't forget to increase your free space map set

Re: [PATCHES] [HACKERS] Proposal for Null Bitmap Optimization(for TrailingNULLs)

Hi, Back from the holiday times. I have tried to present the proof, that the null bitmap was absent in the table with the trailing nulls. On Dec 22, 2007 4:43 AM, Decibel! <[EMAIL PROTECTED]> wrote: > On Dec 20, 2007, at 2:36 AM, Gokulakannan Somasundaram wrote: > > I checked

Re: [PATCHES] [HACKERS] Proposal for Null Bitmap Optimization(for TrailingNULLs)

Thanks for the suggestions. I am re-submitting the patch in contextual diff format. As far as storage savings are concened, the patch claims whatever is stated. I checked it by creating a table with 10 columns on a 32 bit machine. i inserted 100,000 rows with trailing nulls and i observed savings

Re: [PATCHES] [HACKERS] Proposal for Null Bitmap Optimization(for TrailingNULLs)

I have submitted the first working patch for the trailing null optimization. It currently does the following a) Doesn't store the null bitmap, if the heap tuple / index tuple contains only trailing nulls b) In Heap Tuple, the trailing nulls won't occupy space in the null bitmap. The General design

Re: [PATCHES] [HACKERS] Including Snapshot Info with Indexes

On 10/23/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: > > Gokulakannan Somasundaram wrote: > > I would like to present the first patch. It currently has the > following > > restrictions > > a) It does not support any functional indexes. > > b) It sup

Re: [PATCHES] [HACKERS] Including Snapshot Info with Indexes

Hi, I would like to present the first patch. It currently has the following restrictions a) It does not support any functional indexes. b) It supports queries like select count(1) from table where (restrictions from indexed columns), but it does not support select count(1) from table. The Synt