Re: [ADMIN] Creating schema best practices

2012-10-12 Thread Babay Adi, Hava
, Hava Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Creating schema best practices On Wed, Oct 3, 2012 at 10:58 AM, Babay Adi, Hava mailto:hava.ba...@hp.com>> wrote: Thanks Craig for the useful information. On the same regard – Some of the mentioned modules in the mentioned applicatio

Re: [ADMIN] Creating schema best practices

2012-10-05 Thread Christian Ullrich
* Babay Adi, Hava wrote: On the same regard – Some of the mentioned modules in the mentioned application use a set of tables which is logically separate (there are no join statements with tables of other modules). What are the pros\cons of using a separate database instead of a separate schema f

Re: [ADMIN] Creating schema best practices

2012-10-03 Thread Craig James
On Wed, Oct 3, 2012 at 10:58 AM, Babay Adi, Hava wrote: > Thanks Craig for the useful information. > > ** ** > > On the same regard – Some of the mentioned modules in the mentioned > application use a set of tables which is logically separate (there are no > join statements with tables of ot

Re: [ADMIN] Creating schema best practices

2012-10-03 Thread Babay Adi, Hava
using database vs schema. Hava From: Craig James [mailto:cja...@emolecules.com] Sent: יום ד 03 אוקטובר 2012 19:00 To: Babay Adi, Hava Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Creating schema best practices On Tue, Oct 2, 2012 at 11:54 AM, Babay Adi, Hava mailto:hava.ba...@hp.com

Re: [ADMIN] Creating schema best practices

2012-10-03 Thread Craig James
On Tue, Oct 2, 2012 at 11:54 AM, Babay Adi, Hava wrote: > Dear list, > > ** ** > > I’m new to PostgreSQL, planning now a migration to PostgreSQL and would > appreciate your help. > > ** ** > > One aspect of the migration is re-thinking our DB structure. > > ** ** > > The application