[GENERAL] making a pg store of 'multiple checkboxes' efficient

2007-04-18 Thread Jonathan Vanasco
I have a large table (5M items current) that is projected to grow at the rate of 2.5M a month looking at the current usage trends. the table represents some core standardized user account attributes , while text heavy / unstandardized info lies in other tables. my issue is this: i'm adding

Re: [GENERAL] making a pg store of 'multiple checkboxes' efficient

2007-04-18 Thread Alban Hertroys
Jonathan Vanasco wrote: I have a large table (5M items current) that is projected to grow at the rate of 2.5M a month looking at the current usage trends. the table represents some core standardized user account attributes , while text heavy / unstandardized info lies in other tables. my

Re: [GENERAL] making a pg store of 'multiple checkboxes' efficient

2007-04-18 Thread Jonathan Vanasco
On Apr 18, 2007, at 4:28 AM, Alban Hertroys wrote: I got some good results using bitwise operations on an integer column. An index on such a column helps a great deal of course. What type of integer you need depends on how many booleans you (expect to) have. My operations were like WHERE