Re: why postgresql over other RDBMS

Zoltan Boszormenyi írta:
> If you ask me, yes. When I had to choose between MySQL 3.x and
> PostgreSQL 6.5 a long ago and I was able to exclude the DB superuser
> with REVOKE CONNECT from MySQL, I said "no, thanks".
> I did it on purpose to prove that you can the external configuration
> is better in this case.

I wanted to write "you can reenable the superuser to fix problems later,
so the external configuration is better".

And sorry for the top-posting.

> And apart from fixing pg_hba.conf after you move the machine,
> PostgreSQL is quite location agnostic network-wise.
> You can modify the IP address[es] and FQDN of  the machine,
> which is not easily doable if you use e.g. Informix where the hostname
> is stored deep inside the DB and some subsystems break if it changes.
>
> Harpreet Dhaliwal írta:
>> is the host base configuration methodology in postgres superior to
>> other RDBMS.
>> is this something novel that postgres has come up with?
>>
>> ~Harpreet
>>
>> On 5/26/07, * Tom Lane* <tgl@sss.pgh.pa.us
>> <mailto:tgl@sss.pgh.pa.us>> wrote:
>>
>>     Stefan Kaltenbrunner < stefan@kaltenbrunner.cc
>>     <mailto:stefan@kaltenbrunner.cc>> writes:
>>     > Tom Lane wrote:
>>     >> A more interesting question is what sort of hardware you need
>>     for that
>>     >> actually to be a win, though.  Loading a few tables in parallel
>>     sounds
>>     >> like an ideal recipe for oversaturating your disk bandwidth...
>>
>>     > you don't actually need that much of disk bandwidth both COPY
>>     and CREATE
>>     > INDEX are CPU bottlenecked on modern boxes and reasonable disk
>>     > subsystems - spreading their work over multiple cores/processes
>>     can give
>>     > big benefits.
>>
>>     Hmm ... I wonder if that's true for COPY BINARY ...
>>
>>                             regards, tom lane
>>
>>     ---------------------------(end of
>>     broadcast)---------------------------
>>     TIP 2: Don't 'kill -9' the postmaster
>>
>>
>
>


--
----------------------------------
Zoltán Böszörményi
Cybertec Geschwinde & Schönig GmbH
http://www.postgresql.at/