On Dec 2, 2007 6:35 PM, rokj <[EMAIL PROTECTED]> wrote: > Hi. > > For an example let me say that I have a big (over 1 million) user > "base". Then every user does a lot of inserting/updating of data. > Would it be better to create different tables for insert/updating for > every user or would it be better just to have one big table with all > data (tables would have of course the same columns, ...). How do you > cope with this kind of things? > > 1.example (1 enormous table) > tablename (id, user_id, datetime, some_data) > > 2. example (a big number of tables) > tablename_user_id( id, datetime, some_data)
Although there isn't enough information in the email, but instead of creating a separate table for every user, you could use one table , partitioned on userid, that would , however, add a maint overhead whenever you add a new user. > > > Thank you. > > Kind regards, > > Rok > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- Usama Munir Dar http://linkedin.com/in/usamadar Consultant Architect Cell:+92 321 5020666 Skype: usamadar