[PERFORM] Clustered/covering indexes (or lack thereof :-)

2007-11-16 Thread adrobj
This is probably a FAQ, but I can't find a good answer... So - are there common techniques to compensate for the lack of clustered/covering indexes in PostgreSQL? To be more specific - here is my table (simplified): topic_id int post_id int post_text varchar(1024) The most used query is:

Re: [PERFORM] Clustered/covering indexes (or lack thereof :-)

2007-11-16 Thread Heikki Linnakangas
adrobj wrote: This is probably a FAQ, but I can't find a good answer... So - are there common techniques to compensate for the lack of clustered/covering indexes in PostgreSQL? To be more specific - here is my table (simplified): topic_id int post_id int post_text varchar(1024) The most used

Re: [PERFORM] Clustered/covering indexes (or lack thereof :-)

2007-11-16 Thread Bill Moran
In response to Jeff Davis [EMAIL PROTECTED]: On Sun, 2007-11-11 at 22:59 -0800, adrobj wrote: This is probably a FAQ, but I can't find a good answer... So - are there common techniques to compensate for the lack of clustered/covering indexes in PostgreSQL? To be more specific - here is

Re: [PERFORM] Clustered/covering indexes (or lack thereof :-)

2007-11-16 Thread Jeff Davis
On Sun, 2007-11-11 at 22:59 -0800, adrobj wrote: This is probably a FAQ, but I can't find a good answer... So - are there common techniques to compensate for the lack of clustered/covering indexes in PostgreSQL? To be more specific - here is my table (simplified): topic_id int post_id