Skip site navigation (1) Skip section navigation (2)

Re: optimizing selects on time-series data in Pg

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 (view raw or flat)
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

In response to

Responses

sfpug by date

Next:From: Josh BerkusDate: 2003-08-12 19:15:50
Subject: Re: optimizing selects on time-series data in Pg
Previous:From: Sean ChittendenDate: 2003-08-12 19:07:28
Subject: Re: optimizing selects on time-series data in Pg

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group