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
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
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
> 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
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
> 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
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
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
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