Re: go for a script! / ex: PostgreSQL vs. MySQL - Mailing list pgsql-performance

From Sean Chittenden
Subject Re: go for a script! / ex: PostgreSQL vs. MySQL
Date
Msg-id 20031009181112.GA71907@perrin.nxad.com
Whole thread Raw
In response to Re: go for a script! / ex: PostgreSQL vs. MySQL  (Dror Matalon <dror@zapatec.com>)
List pgsql-performance
> Yeah, I had similar thought to Oliver's and suspected that this
> would be the answer.  Also, while it's not too hard to do this for a
> single platform, it gets complecated once you start looking at
> different ones.
>
> Josh, let me know when you're ready to do this. I'll try to help,
> although my perl's kind of rusty. Also, can you even assume perl for
> a postgres install? Does Solaris, for instance come with perl?

Um, why not wait until the C version of initdb is committed, then
steak out a section that'll allow us to submit patches to have initdb
autotune to our hearts content?  There's a tad bit of precedence with
having shared buffer's automatically set in initdb, why not continue
with it?  I know under FreeBSD initdb will have some #ifdef's to wrap
around the syscall sysctl() to get info about kernel bits.  Talking
about how to expand handle this gracefully for a gazillion different
platforms might be a more useful discussion at this point because I'm
sure people from their native OS will be able to contrib the necessary
patches to extract info from their OS so that initdb can make useful
decisions.  Or, lastly, does anyone think that this should be in a
different, external program?  -sc

--
Sean Chittenden

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Sun performance - Major discovery!
Next
From: "Nick Fankhauser"
Date:
Subject: Re: [pgsql-advocacy] OFFTOPIC: PostgreSQL vs MySQL