Re: [GENERAL] Best practice in postgres

2004-12-18 Thread Jim C. Nasby
On Sat, Dec 11, 2004 at 10:40:42PM -0600, Guy Rouillier wrote: > Nilesh Doshi wrote: > > Also, I thought vacuuming will be easier if oracle schema becomes > > database in postgres. For example in our case each schema is like > > 80-90 gb, smaller compare to vacuuming on 400gb. > > I'm very new to

Re: [GENERAL] Best practice in postgres

2004-12-14 Thread Richard_D_Levine
ge.net>cc: "[EMAIL PROTECTED]" Sent by: <[EMAIL PROTECTED]> [EMAIL PROTECTED] Subject

Re: [GENERAL] Best practice in postgres

2004-12-13 Thread Robert Treat
On Fri, 2004-12-10 at 17:49, Nilesh Doshi wrote: > Hi All, > > I'm new to postgres, so I need your help. > > We are in the process of migrating from oracle to postgres. DB size is about > 400gb. > My question is about schemas in oracle and postgres. Does every schema in > oracle becomes a separ

Re: [GENERAL] Best practice in postgres

2004-12-11 Thread Guy Rouillier
Nilesh Doshi wrote: > My question is about schemas in oracle and postgres. Does every > schema in oracle becomes a separate database in postgres ? OR it is > still like oracle, where all schemas are part of big database ? You can have multiple schemas in a single PostgreSQL database. Unlike Orac

[GENERAL] Best practice in postgres

2004-12-11 Thread Nilesh Doshi
Hi All, I'm new to postgres, so I need your help. We are in the process of migrating from oracle to postgres. DB size is about 400gb. My question is about schemas in oracle and postgres. Does every schema in oracle becomes a separate database in postgres ? OR it is still like oracle, where all s