Re: [PERFORM] [NOVICE] Partitioning

2006-12-26 Thread Tom Lane
Kevin Hunter <[EMAIL PROTECTED]> writes: > On 26 Dec 2006 at 2:55p -0500, Tom Lane wrote: >> I thought you did a fine job right there ;-). In essence this would be >> replacing one level of indexing with two, which is unlikely to be a win. >> If you have exactly M rows in each of N tables then

Re: [PERFORM] [NOVICE] Partitioning

2006-12-26 Thread Kevin Hunter
On 26 Dec 2006 at 2:55p -0500, Tom Lane wrote: Kevin Hunter <[EMAIL PROTECTED]> writes: A friend has asked me about creating a unique table for individual users that sign up for his site. (In essence, each user who signs up would essentially get a set of CREATE TABLE {users,friends,movies,eat