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 schemas. I do not think PG would need much more resources (mem, cpu) if I go for different database for each process..? Also, is there any limit on number of databases I can start using a PG server?
Best Regards,
Divakar
From: "tv@xxxxxxxx" <tv@xxxxxxxx>
To: Andres Freund <andres@xxxxxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxx; tv@xxxxxxxx; Divakar Singh <dpsmails@xxxxxxxxx>
Sent: Thu, November 25, 2010 5:55:33 PM
Subject: Re: Which gives good performance? separate database vs separate schema
> On Thursday 25 November 2010 13:02:08 tv@xxxxxxxx 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 definitely not true in many circumstances. As soon as you
> start to
> hit contention (shared memory, locks) you may very well be better of with
> two
> separate clusters.
>
> Andres
>
Good point, I forgot about that. Anyway it's hard to predict what kind of
performance issue he's facing and whether two clusters would fix it.
regards
Tomas
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Actually I am porting from Oracle to PG. Oracle starts a lot of processes when it needs to run many schemas. I do not think PG would need much more resources (mem, cpu) if I go for different database for each process..? Also, is there any limit on number of databases I can start using a PG server?
Divakar
From: "tv@xxxxxxxx" <tv@xxxxxxxx>
To: Andres Freund <andres@xxxxxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxx; tv@xxxxxxxx; Divakar Singh <dpsmails@xxxxxxxxx>
Sent: Thu, November 25, 2010 5:55:33 PM
Subject: Re: Which gives good performance? separate database vs separate schema
> On Thursday 25 November 2010 13:02:08 tv@xxxxxxxx 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 definitely not true in many circumstances. As soon as you
> start to
> hit contention (shared memory, locks) you may very well be better of with
> two
> separate clusters.
>
> Andres
>
Good point, I forgot about that. Anyway it's hard to predict what kind of
performance issue he's facing and whether two clusters would fix it.
regards
Tomas
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
