Fwd: A thought on Index Organized Tables - Mailing list pgsql-hackers

From Gokulakannan Somasundaram
Subject Fwd: A thought on Index Organized Tables
Date
Msg-id 9362e74e1002241105g55473f59g4fb4aec8555779fa@mail.gmail.com
Whole thread Raw
In response to A thought on Index Organized Tables  (Gokulakannan Somasundaram <gokul007@gmail.com>)
List pgsql-hackers
Missed the group....



So basically you want to have index-only scans, but you want them to
be really slow?

No Robert, i just asked him to make it optional, so that the crash safe visibility map is used only when its need is realized by the DB designer. When there is a table with no indexes/ a table where the data will be often updated/ a database where there will be a batch job together with OLTP stuff, the visibility map is just useless. So i am requesting Heikki to make it optional. I am not asking him to drop that idea, as it might be useful in read only environments.

Hope, i have not offended you in conveying that.

Thanks,
Gokul.


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: pg_stop_backup does not complete
Next
From: Josh Berkus
Date:
Subject: Re: pg_stop_backup does not complete