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* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Stefan Kaltenbrunner < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> 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/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend