On Thu, Aug 20, 2009 at 9:16 PM, Craig James<craig_james@xxxxxxxxxxxxxx> wrote: > Fabio La Farcioli wrote: >> >> i am developing a web app for thousands users (1.000/2.000). >> >> Each user have a 2 table of work...I finally have 2.000 (users) x 2 tables >> = 4.000 tables! >> >> Postgres support an elevate number of tables?? >> i have problem of performance ??? What you want is a multi-column primary key where userid is part of the key. You don't want to have a separate table for each user unless each user has their own unique set of columns. > When the user logs back in, a hidden part of the login process gets a table > from the pool of available tables, assigns it to this user, and copies the > user's data from the archive into this personal table. They are now ready > to work. This whole process takes just a fraction of a second for most > users. And what does all this accomplish? -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
