Re: [PERFORM] Which gives good performance? separate database vs separate schema

2010-11-26 Thread Robert Klemme
On Thu, Nov 25, 2010 at 4:46 PM, wrote: >> I am not facing any issues, but yes I want to have optimal performance for >> SELECT and INSERT, especially when I am doing these ops repeatedly. >> Actually I am porting from Oracle to PG. Oracle starts a lot of processes >> when >> it needs to run many

Re: [PERFORM] Which gives good performance? separate database vs separate schema

2010-11-25 Thread tv
org; t...@fuzzy.cz; Divakar Singh > > Sent: Thu, November 25, 2010 5:55:33 PM > Subject: Re: [PERFORM] Which gives good performance? separate database vs > separate schema > >> On Thursday 25 November 2010 13:02:08 t...@fuzzy.cz wrote: >>> I don't think you'll

Re: [PERFORM] Which gives good performance? separate database vs separate schema

2010-11-25 Thread Divakar Singh
sql.org; t...@fuzzy.cz; Divakar Singh Sent: Thu, November 25, 2010 5:55:33 PM Subject: Re: [PERFORM] Which gives good performance? separate database vs separate schema > On Thursday 25 November 2010 13:02:08 t...@fuzzy.cz wrote: >> I don't think you'll get performance improvement f

Re: [PERFORM] Which gives good performance? separate database vs separate schema

2010-11-25 Thread tv
> On Thursday 25 November 2010 13:02:08 t...@fuzzy.cz wrote: >> 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. > Th

Re: [PERFORM] Which gives good performance? separate database vs separate schema

2010-11-25 Thread Andres Freund
On Thursday 25 November 2010 13:02:08 t...@fuzzy.cz wrote: > 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. That one i

Re: [PERFORM] Which gives good performance? separate database vs separate schema

2010-11-25 Thread tv
> I don't think it will make a big difference in performance. > > The real question is: do you need queries that "cross boundaries"? If that > is the case you have to use schema, because Postgres does not support > cross-database queries. Well, there's dblink contrib module, but that won't improve

Re: [PERFORM] Which gives good performance? separate database vs separate schema

2010-11-25 Thread Thomas Kellerer
Divakar Singh, 25.11.2010 12:37: Hello Friends, I have many instances of my software running on a server (Solaris SPARC). Each software instance requires some DB tables (same DDL for all instances' tables) to store data. It essentially means that some processes from each instance of the softwar

Re: [PERFORM] Which gives good performance? separate database vs separate schema

2010-11-25 Thread tv
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.d

[PERFORM] Which gives good performance? separate database vs separate schema

2010-11-25 Thread Divakar Singh
Hello Friends, I have many instances of my software running on a server (Solaris SPARC). Each software instance requires some DB tables (same DDL for all instances' tables) to store data. It essentially means that some processes from each instance of the software connect to these tables. Now, sh