Re: [PERFORM] Small table or partial index?

2005-12-13 Thread Francisco Reyes
Jim C. Nasby writes: On Fri, Dec 02, 2005 at 06:28:09PM -0500, Francisco Reyes wrote: I am in the process of designing a new system. There will be a long list of words such as -word table word_id integer word varchar special boolean Some "special" words are used to determine if some work is t

Re: [PERFORM] Small table or partial index?

2005-12-12 Thread Jim C. Nasby
On Fri, Dec 02, 2005 at 06:28:09PM -0500, Francisco Reyes wrote: > I am in the process of designing a new system. > There will be a long list of words such as > > -word table > word_id integer > word varchar > special boolean > > Some "special" words are used to determine if some work is to be do

[PERFORM] Small table or partial index?

2005-12-02 Thread Francisco Reyes
I am in the process of designing a new system. There will be a long list of words such as -word table word_id integer word varchar special boolean Some "special" words are used to determine if some work is to be done and will be what we care the most for one type of operation. Will it be more