Re: [HACKERS] PG process architecture

2006-01-14 Thread Denis Lussier
EnterpriseDB is a clone AND a fork. :-) We work hard to free customers from Oracle vendor lock-in AND stay up with the latest releases and patches of Postgres AND don't break any Postgres native and/or ANSI functionality. --Denis Lussier Founder CTO www.EnterpriseDB.com On 1/11/06,

[HACKERS] PG process architecture

2006-01-11 Thread Milen Kulev
Hi listers, I am experienced Oracle DBA und now I was given a task to evaluate Postgresql. May first goal is to compare the architecture of Oracle and Postgres. After reading the fine manuals and several mailing lists, I have found that the following parameters are analogous in PG vs Oracle

Re: [HACKERS] PG process architecture

2006-01-11 Thread Tom Lane
Milen Kulev [EMAIL PROTECTED] writes: My questions is: Where PG is storing data dictionary information (coming form system pg_* tables) while parsing the queries ? There's a limited-size catalog cache in each backend process, which might be the closest analogy to this. Offhand I think it's

Re: [HACKERS] PG process architecture

2006-01-11 Thread Milen Kulev
of PG (several times) to understand a little bit deeper the internal mechanics of PG. Regards. Milen. --- Ursprüngliche Nachricht --- Von: Jonah H. Harris [EMAIL PROTECTED] An: Milen Kulev [EMAIL PROTECTED] Betreff: Re: [HACKERS] PG process architecture Datum: Wed, 11 Jan 2006 09:44:31 -0500

Re: [HACKERS] PG process architecture

2006-01-11 Thread Joshua D. Drake
Milen Kulev wrote: Hi Harris, from oracle DBA point of view Enterprise DB is VERY cool. My boss will be very happy to hear that there a way to get (paid) support for a PG DB. There several highly qualified support vendors for PostgreSQL: SRA America Pervasive and ourselves, the only