Re: [ADMIN] Experience with large number of tables in single PostgreSQL instance

2013-04-10 Thread Vedran Krivokuca
On Wed, Apr 10, 2013 at 10:43 AM, Dale Betts wrote: > > I'd agree, certainly in my experiences. > > You need to ensure OS parameters such as the max open files (fs.file-max if > we're talking > Linux) is set appropriately. Baring in mind each user will have an open file > on each > underlying da

Re: [ADMIN] Experience with large number of tables in single PostgreSQL instance

2013-04-10 Thread Vedran Krivokuca
On Wed, Apr 10, 2013 at 9:07 AM, Vedran Krivokuca wrote: > 1) we can go with different instances of PostgreSQL service, let's say > (for pure theory) 10 of them on the same HA cluster setup. Every > instance would hold let's say 1/10th of that big recordset, and around >

[ADMIN] Experience with large number of tables in single PostgreSQL instance

2013-04-10 Thread Vedran Krivokuca
Hello all, We are exploring possible strategies on deploying PostgreSQL with application which will store fairly much data (current implementation stores around 345 GB of data, and it will be subject of up to 10 times more data stored in the database). Now, not to go into too much details to avo