Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability)

2004-10-22 Thread Kevin Barnard
On Fri, 22 Oct 2004 14:18:52 -0400, Jan Wieck <[EMAIL PROTECTED]> wrote: > > > That "multiple hosts" sounds that he came across the NDB cluster stuff > that will become available in MySQL someday. Be aware that this new > table handler will to my knowledge NOT support foreign keys. So the > enfor

Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability)

2004-10-22 Thread Jan Wieck
On 10/21/2004 3:40 PM, John Wells wrote: Guys, My boss has been keeping himself busy reading MySQL marketing pubs, and came at me with a few questions this morning regarding PostgreSQL features (we're currently moving to PostgreSQL). While I don't think either are really that important for our situ

Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability)

2004-10-22 Thread Andrew Sullivan
On Thu, Oct 21, 2004 at 03:40:23PM -0400, John Wells wrote: > Guys, > > My boss has been keeping himself busy reading MySQL marketing pubs, > and came at me with a few questions this morning regarding PostgreSQL > features (we're currently moving to PostgreSQL). I should point out that there's a

Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability)

2004-10-22 Thread Richard_D_Levine
PROTECTED]> ge.net>cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Sent by: Subject: Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability

Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability)

2004-10-21 Thread Jeff Davis
> and what sort of capabilities PostgreSQL has to scale across > > multiple CPUs and hosts (multithreading, load balancing, etc). > > > > Well, PostgreSQL can certainly take advantage of multiple CPU's, > although there are some cases where we could do more (use multiple CPU > on one query). You

Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability)

2004-10-21 Thread Ben
On 21 Oct 2004, Robert Treat wrote: > slony to set up load balancing depending on your needs... though I > should say that PostgreSQL has tremendous ability to scale up even > without getting into all the buzzword friendly schemes. You should strive to pool your connections, though. Of course, t

Re: [GENERAL] Two questions from the boss (SQL:2003 && scalability)

2004-10-21 Thread Robert Treat
On Thu, 2004-10-21 at 15:40, John Wells wrote: > Guys, > > My boss has been keeping himself busy reading MySQL marketing pubs, > and came at me with a few questions this morning regarding PostgreSQL > features (we're currently moving to PostgreSQL). > I'd be interested to see what my$ql has to s

[GENERAL] Two questions from the boss (SQL:2003 && scalability)

2004-10-21 Thread John Wells
Guys, My boss has been keeping himself busy reading MySQL marketing pubs, and came at me with a few questions this morning regarding PostgreSQL features (we're currently moving to PostgreSQL). While I don't think either are really that important for our situation, he wanted to know specifically w