Hello, > Now, should I put these tables in 1 Database's different schemas or in > separate > databases itself for good performance? > I am using libpq for connection. > > Pictorial Representation: > > Process1 -> DB1.schema1.table1 > > Process2 -> DB1.schema2.table1 > > Vs. > > Process1 -> DB1.default.table1 > > Process2 -> DB2.default.table1 > > Which one is better? Well, that depends on what you mean by "database." In many other products each database is completely separate (with it's own cache, processes etc). In PostgreSQL, there's a cluster of databases, and all of them share the same cache (shared buffers) etc. I don't think you'll get performance improvement from running two PostgreSQL clusters (one for DB1, one for DB2). And when running two databases within the same cluster, there's no measurable performance difference AFAIK. So the two options are exactly the same. Tomas -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
