pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql.conf file from like 7.x to 9.2
3+ messages / 2 participants
[nested] [flat]
* Postgresql.conf file from like 7.x to 9.2
@ 2013-04-10 21:25 Tory M Blue <tmblue@gmail.com>
2013-04-10 21:42 ` Re: Postgresql.conf file from like 7.x to 9.2 Shaun Thomas <sthomas@optionshouse.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tory M Blue @ 2013-04-10 21:25 UTC (permalink / raw)
To: pgsql-performance
Afternoon
So I just realized I've been just reimporting me Postgres configs from one
version to the next, since they were initially customized for my setup.
Maybe from 7.x... And now on 9.2.4
Is there an easy/clean way to adapt my old config file to the new stuff,
I'm not sure what all has changed, so wondering if I just have to go line
by line and somehow consolidate old to new, area there any tools or
mechanism to do so?
I'm sure there are quite a few changes, just not sure if I'm missing
anything major.
Thanks
Tory
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgresql.conf file from like 7.x to 9.2
2013-04-10 21:25 Postgresql.conf file from like 7.x to 9.2 Tory M Blue <tmblue@gmail.com>
@ 2013-04-10 21:42 ` Shaun Thomas <sthomas@optionshouse.com>
2013-04-10 21:53 ` Re: Postgresql.conf file from like 7.x to 9.2 Tory M Blue <tmblue@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Shaun Thomas @ 2013-04-10 21:42 UTC (permalink / raw)
To: Tory M Blue <tmblue@gmail.com>; +Cc: pgsql-performance
On 04/10/2013 04:25 PM, Tory M Blue wrote:
> Is there an easy/clean way to adapt my old config file to the new stuff,
> I'm not sure what all has changed, so wondering if I just have to go
> line by line and somehow consolidate old to new, area there any tools or
> mechanism to do so?
Ehhh, at that point, it's probably best to just start over. we took the
annotated postgresql.conf and reevaluated each setting and compared it
to similar/same settings in our old config. Then we made a file of
*just* the stuff we changed, and made that the postgresql.conf, and keep
the annotated version around as defaults.conf to use as a reference.
That makes it a lot easier to copy between versions or incorporate
new/modified settings.
Of course, all this will probably be moot when 9.3 comes out, as I
believe it has the ability to include configuration fragments. Probably
another good opportunity to clean up your configs.
We jumped from 8.2 to 9.1 in a single upgrade, so while not quite as
wide as going from 7.x to 9.2, you could probably benefit from a reeval.
The fundamental settings are pretty much the same, so far as I know.
Settings we always change:
shared_buffers
work_mem
maintenance_work_mem
default_statistics_target
effective_cache_size
random_page_cost
archive_mode
archive_command
archive_timeout
log_checkpoints
log_min_duration_statement
Settings we usually tweak:
autovacuum_vacuum_scale_factor
autovacuum_analyze_scale_factor
autovacuum_freeze_max_age
Settings that are new, and could assist in setting up streaming or backups:
wal_level
max_wal_senders
People are getting more and more vocal about increasing cpu_tuple_cost,
as the default is apparently too low in practice.
Everything else? Salt to taste.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgresql.conf file from like 7.x to 9.2
2013-04-10 21:25 Postgresql.conf file from like 7.x to 9.2 Tory M Blue <tmblue@gmail.com>
2013-04-10 21:42 ` Re: Postgresql.conf file from like 7.x to 9.2 Shaun Thomas <sthomas@optionshouse.com>
@ 2013-04-10 21:53 ` Tory M Blue <tmblue@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Tory M Blue @ 2013-04-10 21:53 UTC (permalink / raw)
To: sthomas@optionshouse.com; +Cc: pgsql-performance
On Wed, Apr 10, 2013 at 2:42 PM, Shaun Thomas <sthomas@optionshouse.com>wrote:
> On 04/10/2013 04:25 PM, Tory M Blue wrote:
>
> Is there an easy/clean way to adapt my old config file to the new stuff,
>> I'm not sure what all has changed, so wondering if I just have to go
>> line by line and somehow consolidate old to new, area there any tools or
>> mechanism to do so?
>>
>
> Ehhh, at that point, it's probably best to just start over. we took the
> annotated postgresql.conf and reevaluated each setting and compared it to
> similar/same settings in our old config. Then we made a file of *just* the
> stuff we changed, and made that the postgresql.conf, and keep the annotated
> version around as defaults.conf to use as a reference. That makes it a lot
> easier to copy between versions or incorporate new/modified settings.
>
> Of course, all this will probably be moot when 9.3 comes out, as I believe
> it has the ability to include configuration fragments. Probably another
> good opportunity to clean up your configs.
>
> We jumped from 8.2 to 9.1 in a single upgrade, so while not quite as wide
> as going from 7.x to 9.2, you could probably benefit from a reeval.
>
> The fundamental settings are pretty much the same, so far as I know.
> Settings we always change:
>
> shared_buffers
> work_mem
> maintenance_work_mem
> default_statistics_target
> effective_cache_size
> random_page_cost
> archive_mode
> archive_command
> archive_timeout
> log_checkpoints
> log_min_duration_statement
>
> Settings we usually tweak:
>
> autovacuum_vacuum_scale_factor
> autovacuum_analyze_scale_**factor
> autovacuum_freeze_max_age
>
> Settings that are new, and could assist in setting up streaming or backups:
>
> wal_level
> max_wal_senders
>
> People are getting more and more vocal about increasing cpu_tuple_cost, as
> the default is apparently too low in practice.
>
> Everything else? Salt to taste.
>
> --
> Shaun Thomas
>
>
> Thanks Shaun
Ya I actually didn't upgrade from 7 to 9 in one fell swoop, I've actually
been pretty good at staying up with the releases (thanks to slon), but I
realized the other day when i rolled a new 9.2.4 rpm that I just keep using
my old postgres config. Now I'm sure we modified it somewhat in 8, but that
was probably the last time. So a performance tuning and config file
cleansing is in order :)
Thanks again!
Tory
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-04-10 21:53 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-04-10 21:25 Postgresql.conf file from like 7.x to 9.2 Tory M Blue <tmblue@gmail.com>
2013-04-10 21:42 ` Shaun Thomas <sthomas@optionshouse.com>
2013-04-10 21:53 ` Tory M Blue <tmblue@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox