On Thu, Nov 25, 2010 at 4:46 PM, t...@fuzzy.cz 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
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,
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
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
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
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 is
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 is
-performance@postgresql.org; t...@fuzzy.cz; Divakar Singh
dpsma...@yahoo.com
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
, 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 from running two
PostgreSQL clusters (one for DB1, one for DB2