From: | Aditya <aditya(at)grot(dot)org> |
---|---|
To: | Sean Chittenden <sean(at)chittenden(dot)org> |
Cc: | sfpug(at)postgresql(dot)org |
Subject: | Re: optimizing selects on time-series data in Pg |
Date: | 2003-08-12 19:11:59 |
Message-ID: | 20030812191159.GA28465@mighty.grot.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | sfpug |
On Tue, Aug 12, 2003 at 12:07:28PM -0700, Sean Chittenden wrote:
> 'ya know, that'd be a whicked cool patch to hack out: backtick support
> in postgresql.conf... hrm... from my TODO:
>
> Add backtick support for postgresql.conf:
> I want to be able to do stuff like:
>
> effective_cache_size = `$((\`sysctl -n vfs.hibufspace\` / 8192))`
>
> To have postgresql.conf files be able to automatically tune
> themselves on startup. What would likely need to happen would be
> some kind of processor (called by pg_ctl, most likely) that would
> run over the postgresql.conf file on startup, execute the
> backtick'ed areas to generate a new postgresql.conf that is static
> that the postmaster actually uses.
I remember reading a post that suggested using a (perl) script to generate the
postgresql.conf based on on the output of uname -- since we already use a sh
script in /usr/local/etc/rc.d, it would be trivial to incorporate it...
Aditya
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-08-12 19:15:50 | Re: optimizing selects on time-series data in Pg |
Previous Message | Sean Chittenden | 2003-08-12 19:07:28 | Re: optimizing selects on time-series data in Pg |