Re: [GENERAL] Experience with many schemas vs many databases

2009-11-16 Thread undisclosed user
know if I am wrong here)? If I were to do a single schema/database, is it possible to get data per user and back it up? Select user rows, copy to a temp table/db, backup? Thanks, Frank On Sun, Nov 15, 2009 at 1:11 PM, John R Pierce wrote: > undisclosed user wrote: > >> If I were

Re: [GENERAL] Experience with many schemas vs many databases

2009-11-15 Thread undisclosed user
If I were to switch to a single DB/single schema format shared among all users , how can I backup each user individually? Frank On Sat, Nov 14, 2009 at 10:28 PM, undisclosed user < lovetodrinkpe...@gmail.com> wrote: > Hello everyone, > > I have hit a wall on completing a soluti

[GENERAL] Experience with many schemas vs many databases

2009-11-15 Thread undisclosed user
Hello everyone, I have hit a wall on completing a solution I am working on. Originally, the app used a db per user (on MyIsam)the solution did not fair so well in reliability and performance. I have been increasingly interested in Postgres lately. Currently, I have about 30-35k users/database