Re: A thought on Index Organized Tables

From: Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: A thought on Index Organized Tables
Date: 2010-02-24 21:46:06
Message-ID: 9362e74e1002241346l7b06023cy4addb7421b109a96@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I haven't thought about whether this is sufficient but if it is then
> an initial useful thing to add would be to use it for queries where we
> have a qual that can be checked using the index key even though we
> can't do a range scan. For example if you have a btree index on
> <a,b,c> and you have a WHERE clause like "WHERE c=0"
>
> That would be a much smaller change than IOT but it would still be a
> pretty big project. Usually the hardest part is actually putting the
> logic in the planner to determine whether it's advantageous. I would
> suggest waiting until after 9.0 is out the door to make sure you have
> the attention of Heikki or Tom or someone else who can spend the time
> to check that it will actually work before putting lots of work coding
> it.
>
> I will try that. Thanks ...

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-02-24 21:52:00 Re: pg_stop_backup does not complete
Previous Message Gokulakannan Somasundaram 2010-02-24 21:44:18 Re: A thought on Index Organized Tables