[Spacewalk-list] Recommendations for Tuning Spacewalk

[Paul Robert Marino]

The biggest thing with PostgreSQL is ram the more ram the happier it is.
The number of concurrent clients isnt a big deal because they usually
dont all connect at the same time.
The section about pgtune here
https://fedorahosted.org/spacewalk/wiki/PostgreSQLServerSetup isn't a
bad place to start.
Usually I would make a copy of the config and run pgtune against the
copy because it can accidentally create duplicate entries in the
config.
Remember the more ram on the box the better the clients will preform.

Also consider using pgpool. pgpool can be very helpful in reducing the
number of concurrent connections to the database because it can dedup
the connections. in essence if a new connection is made with the same
parameters and there is already one open which is idle and not in a
transaction it will reuse the idle connection instead of creating a
new one. with pgpool you can get away with tuning for far fewer
connection which means your server will be much faster.

finally if you are using an external PostgreSQL server or you have
installed a newer one than the one that came with your distro make
sure to update the JDBC drivers. The rest of the drivers and client
tools do not matter very much but the JDBC drivers do
you can downloat the version specific jdbc drivers here
http://jdbc.postgresql.org/download.html

unfortunately many aspects of PostgreSQL tuning are more art than
science but the basics at least are handled by the pgtune script.
Here is a good page to give you a start on the finer details
https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

Also I highly suggest using table spaces so you don't need to put your
entire database under /var/lib
http://www.postgresql.org/docs/9.2/static/manage-ag-tablespaces.html
You will have to do some selinux fixups on the directory it before
this will work correctly but I find it is well worth the effort.

In addition if you want to go really deep you can look at partitioning
tables which can be really helpful on larger installs but it requires
a quite a more lot more work during upgrades the ensure every thing
goes right.


On Mon, Oct 13, 2014 at 5:03 PM, Glen Collins <glenc2004 at comcast.net> wrote:
> Hello all. Can anyone provide a concise document/URL for tuning spacewalk? I
> have been reading many tuning guides for Postgres but I have not really
> found anything for spacewalk that would give details on how to tune for s
> specific number of clients. I've seen many on here having 2,3 and 4K clients
> without issue. And I'm just curious how to tune for both Spacewalk/Java and
> Postgres to get the most out of the system. I want to be ahead of the game
> than having issue down the road as my environment grows.
>
> Thanks!
>
> Glen Collins
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list