| From: | Adrian 'Dagurashibanipal' von Bidder <avbidder(at)fortytwo(dot)ch> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Oracle rant |
| Date: | 2003-01-16 06:56:02 |
| Message-ID: | 1042700162.582.5.camel@altfrangg.fortytwo.ch |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> (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 be
some sensible way to determine an optimal setting for the famous
shared_buffers (and the default should be something that gets reasonable
performance on common cases)
No, I don't expect the second one soon - I know how hard it is. No, I'm
not debating that PostgreSQL is not much, much, much easier to
administrate and set up than Oracle. I'm just saying that there are
*some* small arcane details in postgres, too (although, at least, they
don't affect stability, just performance).
cheers
-- vbi
--
pub 1024D/92082481 2002-02-22 Adrian von Bidder
Key fingerprint = EFE3 96F4 18F5 8D65 8494 28FC 1438 5168 9208 2481
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2003-01-16 07:29:23 | Re: Oracle rant |
| Previous Message | Mark Kirkwood | 2003-01-16 06:18:47 | Re: Oracle rant |