DB Upgrade complete

[Mike Bonnet]

On Tue, 2007-07-10 at 01:56 -0500, Mike McGrath wrote:
> We'll have to do some tweaking.  Toshio pointed out that our postgres 
> config is pretty vanilla.  There are probably many tweaks we can do to 
> it so I've included it in this email.  I'm a MySQL guy so any assistance 
> on the postgres side of things would be appreciated.  If you have any 
> questions about our database, our real concern is koji, its the most 
> used database in terms of traffic and it is, by far, our largest.

I've attached some suggested changes to the default postgresql.conf
below.  They are based on reading the tuning docs on postgresql.org and
powerpostgresql.com, particularly the annotated config doc.  Let me know
if there are any questions or comments.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgresql-conf.diff
Type: text/x-patch
Size: 3406 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/fedora-infrastructure-list/attachments/20070710/c8931b2d/attachment.bin>