Rails on PostgreSQL : PGCon 2010 talk on Rails and PostgreSQL

Comment on PGCon 2010 talk on Rails and PostgreSQL by Alex Kane

2010-08-04T10:06:00+00:00

Great post, thanks for the info.

Comment on PGCon 2010 talk on Rails and PostgreSQL by EppO

2010-08-04T16:44:51+00:00

Do you know where to grab the tool that gives the sharedbuffers, workmem, autovacuum, … settings at 1:01:40 Tune PostgreSQL ? I didn’t find it searching sfpug on google.

Anyway, great talk, very interesting

Comment on PGCon 2010 talk on Rails and PostgreSQL by Tom Copeland

2010-08-04T18:05:55+00:00

@eppo I think they’re just showing their current settings… I’m not sure what that file is; maybe it’s a puppet template from which they generate their postgresql.conf.

Comment on PGCon 2010 talk on Rails and PostgreSQL by Michael Kohl

2010-08-09T05:00:40+00:00

@eppo: It’s a Puppet template. You’d have to set the ramfordatabase value yourself somewhere in the database template and then Puppet can generate the right config on pushing the file. You can even do something like

$ram_for_database = $deployment_env ? {
      staging => 'XXMB',
      default => 'XXXXMB',
}