On Thu, 16 Jan 2003, Fred Zellinger wrote:
With Oracle, you can screw around with files and tablespaces and
extents and segments and partition striping and local and global
indexing and block sizes and 400+ other tuning parameters to your
heart's content. ... I am a control freak and I think
On Thu, 2003-01-16 at 08:29, Mark Kirkwood wrote:
Adrian 'Dagurashibanipal' von Bidder wrote:
I'm just saying that there are
*some* small arcane details in postgres, too (although, at least, they
don't affect stability, just performance).
Indeed you are right... Pg has its own
I work in an all Oracle shop, with server instances around the world. At
least 20 servers are 400Gb+ and a couple are 4 Terabyte+. I tooks $15k worth
of Oracle training, have set up my own instances and done Perl/CGI/Apache
work along with setting up really big data warehousing apps for
On Wed, 15 Jan 2003, mlw wrote:
I just wanted to post this note.
I have been in Oracle hell for four days now, and in between the 5
minutes of work and the hours of watings, dealing with table spaces,
I've been in Informix hell for the month or so.
At first, we were getting the message No
On Thu, Jan 16, 2003 at 11:17:42AM -0500, Jeff wrote:
On Wed, 15 Jan 2003, mlw wrote:
So with all that, you gotta appreciate both sides - hte fact pg just
works and the tunability of bigger db's (Oh yeah - and we've actually had
informix on the horn about the problem - their solution was
On Thu, Jan 16, 2003 at 10:50:49AM -0600, Ross J. Reedstrom wrote:
suggestion to upgrade to a not yet released version invariably includes
the option of applying the patch yourself. Not something Oracle can offer.
Not for a sane price, I guess. I believe the high end support contracts
include
Peter Eisentraut wrote:
Adrian 'Dagurashibanipal' von Bidder writes:
- postgres should auto-tune itself - the *cost could perhaps be
adjusted after some statistics have been collected, and there should be
some sensible way to determine an optimal setting for the famous
Fred Zellinger wrote:
I also am a Linux Nut and use Postgres whenever possible because I like the
freedom of access to the HACKERS mailing list...something only a few highly
renound DBA snobs have with Oracle.
Indeed, I think this is a significant component of the appeal of open
source
I
Adrian 'Dagurashibanipal' von Bidder writes:
- postgres should auto-tune itself - the *cost could perhaps be
adjusted after some statistics have been collected, and there should be
some sensible way to determine an optimal setting for the famous
shared_buffers (and the default should be
I just wanted to post this note.
I have been in Oracle hell for four days now, and in between the 5
minutes of work and the hours of watings, dealing with table spaces,
extents, and all that, I just keep thinking about how much easier
PostgreSQL is to work with.
We all may bitch and moan
On Wed, 15 Jan 2003, mlw wrote:
I just wanted to post this note.
I have been in Oracle hell for four days now, and in between the 5
minutes of work and the hours of watings, dealing with table spaces,
extents, and all that, I just keep thinking about how much easier
PostgreSQL is to
Gavin Sherry wrote:
On Wed, 15 Jan 2003, mlw wrote:
I just wanted to post this note.
I have been in Oracle hell for four days now, and in between the 5
minutes of work and the hours of watings, dealing with table spaces,
extents, and all that, I just keep thinking about how
snippage
The Oracle system stops from time to time because of various arcane
reasons. You get the error message, look it up on alltheweb.com, and
fix it. The whole system is bogus. It DEMANDS a full time DBA.
PostgreSQL does not.
I could be accused of being cynical here (gosh)... but I
(i.e. arcane
little need to know things that trap all but the initiated...
So, for postgres, that means:
- a good thing the autovacuum thingy is coming along
- postgres should auto-tune itself - the *cost could perhaps be
adjusted after some statistics have been collected, and there should
Adrian 'Dagurashibanipal' von Bidder wrote:
I'm just saying that there are
*some* small arcane details in postgres, too (although, at least, they
don't affect stability, just performance).
Indeed you are right... Pg has its own collection of arcane details too,
but hopefully the culture of
15 matches
Mail list logo
