Re: MySQL interview, no mention of PostgreSQL

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, "Arcadius A(dot)" <ahouans(at)sh(dot)cvut(dot)cz>, PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: MySQL interview, no mention of PostgreSQL
Date: 2003-10-17 19:21:52
Message-ID: 20031017162040.O83287@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

On Fri, 17 Oct 2003, Neil Conway wrote:

> On Fri, 2003-10-17 at 07:23, Bruce Momjian wrote:
> > We don't want to fire up a backend until we know this is a valid user.
>
> We do the fork() before we even look at the client's connection packet,
> so I'm sceptical that going through all that trouble really makes us
> significantly more resistant to a DOS attack.

The point is that its alot faster for the backend to open a text file and
parse that, then it is to open up a full database connection just to SQL
query a table to see if the person is allowed to open the database
connection in the first place ...

Then again, doesn't that almost defeat the purpose of checking in the
first place? :)

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Neil Conway 2003-10-17 19:35:38 Re: MySQL interview, no mention of PostgreSQL
Previous Message Neil Conway 2003-10-17 18:47:43 Re: MySQL interview, no mention of PostgreSQL