From: Mauro Bertoli <bertolima@yahoo.it>
To: PFC <lists@boutiquenumerique.com>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgres performance
Date: Sat, 5 Mar 2005 17:31:02 +0100 (CET)
Message-ID: <20050305163102.91123.qmail@web51406.mail.yahoo.com> (raw)
--- PFC <lists@boutiquenumerique.com> wrote:
> You mean, you have no foreign keys in your database
?
> In SELECT they are definitely useful (think select
> for update, isolation
> level serializable...)
No, I haven't foreign keys in the older version, in
that new I've it... however I manage relations from
app code (PHP)... doesn't MYSQL allow to use 'foreign
keys' in sure and fast way then?
> > - why postgres use a new process for every query ?
> > (mySQL, if I'm not wrong, use threads... I think
> its
> > faster)
>
> Not for every query, for every CONNECTION.
> You are using persistant connections are you. Are
you ?
I'm using PHP and every user (can be from 1 user to
100 users) must connect to the database... do you know
how I can use persistant connection? I think it's
impossible... I'm wrong?
>
> > - why connection time is slower? (compared to
> mySQL)?
>
> This is of no importance as everyone uses
> persistent connections anyway.
See last answer...
> > - why postgres require analyze? (mySQL, if I'm not
> > wrong, don't require it)
> > Yours answers will be very apreciated! Thx
>
> So it has a planner which knows what it's doing ;)
> instead of just
> guessing in the dark.
>
> And MySQL requires analyze too (read the docs),
> optimize table which
> looks like vacuum to me, and sometimes repair
> table...
Ok... they are conceptually implemented in the same
mode...
Thx a lot! Now my ideas about pg & mySQL are cleared
(and corrects ;) )
Mauro
___________________________________
Nuovo Yahoo! Messenger: E' molto più divertente: Audibles, Avatar, Webcam, Giochi, Rubrica… Scaricalo ora!
http://it.messenger.yahoo.it
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bertolima@yahoo.it, lists@boutiquenumerique.com, dev@archonet.com
Subject: Re: Postgres performance
In-Reply-To: <20050305163102.91123.qmail@web51406.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox