notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Why was the website so slow for so long?

The cause of the slowdown was a change to the ZFS dataset. In conjunction with the database server, very little caching was being done. This combination resulted in increased disk I/O as the system churned through the database. Details in the blog post which outlines the various things which changed. Many graphs.

Port details
pgtune Postgresql.conf tuning tips based on hardware and load type
0.9.3_3 databases on this many watch lists=4 search for ports that depend on this port Find issues related to this port Report an issue related to this port 0.9.3Version of this port present on the latest quarterly branch.
Maintainer: gjb@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2009-05-17 10:14:31
Last Update: 2018-02-19 11:10:43
SVN Revision: 462307
License: BSD3CLAUSE
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (6 items)
  1. /usr/local/share/licenses/pgtune-0.9.3_3/catalog.mk
  2. /usr/local/share/licenses/pgtune-0.9.3_3/LICENSE
  3. /usr/local/share/licenses/pgtune-0.9.3_3/BSD3CLAUSE
  4. bin/pgtune
  5. share/pgtune/settings/pg_settings-8.4-32
  6. share/pgtune/settings/pg_settings-8.4-64
Collapse this list.
Dependency lines:
  • pgtune>0:databases/pgtune
To install the port: cd /usr/ports/databases/pgtune/ && make install clean
To add the package: pkg install pgtune
PKGNAME: pgtune
Flavors: there is no flavor information for this port.
distinfo:

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Runtime dependencies:
  1. python2.7 : lang/python27
There are no ports dependent upon this port

Configuration Options

USES:

Master Sites:
  1. http://pgfoundry.org/frs/download.php/2449/
  2. https://www.glenbarber.us/ports/databases/pgtune/

Number of commits found: 12

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
19 Feb 2018 11:10:43
Original commit files touched by this commit  0.9.3_3
Revision:462307
antoine search for other commits by this committer
Reduce dependency on the python2 metaport

PR:		225752
Submitted by:	Yasuhiro KIMURA
15 May 2017 19:39:49
Original commit files touched by this commit  0.9.3_2
Revision:440967
amdmi3 search for other commits by this committer
- Add LICENSE
- Tweak python dependency: runtime only and python 2.x only
- Add NO_ARCH
- Fix shebangfix by removing shebang change from the patch

Approved by:	portmgr blanket
19 Oct 2015 14:50:52
Original commit files touched by this commit  0.9.3_1
Revision:399684
amdmi3 search for other commits by this committer
Improve shebangfix framework

- Support multiple values in *_OLD_CMD, i.e. we can now fix both
"/usr/bin/python" and "/usr/bin/env python" at the same time
- Default *_OLD_CMD values are now always appended, so you don't need to specify
them in individual ports
- Add lua support (depends on USES=lua)
- Add more default values, such as "/usr/bin/env foo" for python, perl, bash,
ruby and lua
- Shebangfix now matches whole words, e.g. we will no longer (erroneously)
replace "/usr/bin/perl5.005" with "${perl_CMD}5.005" (but "/usr/bin/perl -tt" is
still (correctly) replaced with "${perl_CMD} -tt")

Note that *_OLD_CMD items containing spaces must now be quoted (e.g.
perl_OLD_CMD=/bin/perl /usr/bin/perl "/usr/bin/env perl")

Update shebangfix usage according to new rules in many ports:

- Remove *_OLD_CMD for patterns now replaced by default
- Quote custom *_OLD_CMD which contain spaces

Fix shebangfix usage in many ports (irrelevant to infrastructure change):

- Remove redundant SHEBANG_LANG (no need to duplicate default langs)
- Remove redundant *_CMD (such as
python_CMD=${LOCALBASE}/bin/python${PYTHON_VER} when USES=python is present)
- Never use *_OLD_CMD in REINPLACE_CMD matchers, these should always look for
exact string

Approved by:	portmgr (bapt)
Differential Revision:	D3756
20 Oct 2014 10:41:13
Original commit files touched by this commit  0.9.3_1
Revision:371255
bapt search for other commits by this committer
Cleanup plist
19 Oct 2014 08:50:18
Original commit files touched by this commit  0.9.3_1
Revision:371173
mva search for other commits by this committer
- Convert ports from databases/ and deskutils/ to new USES=python

Approved by:	portmgr (implicit)
08 May 2014 17:06:36
Original commit files touched by this commit  0.9.3_1
Revision:353334
gjb search for other commits by this committer
Fix a few nits with databases/pgtune that cause runtime
problems:

 - Add USES=shebangfix
 - Replace USE_PYTHON=yes with USE_PYTHON=2+
 - Fix shebang line to use python2.N
 - Bump PORTREVISION

Reported by:	pathiaki2@yahoo.com (via ports@)
Redports ID:	https://redports.org/buildarchive/20140508164000-29103/
Sponsored by:	The FreeBSD Foundation
27 Feb 2014 13:50:17
Original commit files touched by this commit  0.9.3
Revision:346334
ehaupt search for other commits by this committer
Support staging
20 Sep 2013 16:13:49
Original commit files touched by this commit  0.9.3
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
26 Apr 2013 04:03:23
Original commit files touched by this commit  0.9.3
Revision:316565
gjb search for other commits by this committer
Update MASTERSITES for my server to use https
08 Aug 2011 12:55:47
Original commit files touched by this commit  0.9.3

culot search for other commits by this committer
- Update to 0.9.3
- Update MASTER_SITES
- Pass maintainership to submitter

Submitted by:   gjb@
Approved by:    Matthieu Bouthors <matthieu@labs.fr> (maintainer)
20 Mar 2011 12:54:45
Original commit files touched by this commit  0.9.0

miwi search for other commits by this committer
- Get Rid MD5 support
17 May 2009 10:14:08
Original commit files touched by this commit  0.9.0

miwi search for other commits by this committer
pgtune takes the wimpy default postgresql.conf and expands
the database server to be as powerful as the hardware it's
being deployed on.

WWW: http://pgfoundry.org/projects/pgtune/

PR:             ports/134546
Submitted by:   Matthieu BOUTHORS

Number of commits found: 12

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
weechatFeb 21
webkit2-gtk3Feb 19
dovecotFeb 13
gitlab-ceFeb 13
grub2-bhyveFeb 12
libexifFeb 11
linux-flashplayerFeb 11
nginxFeb 09
nginx-develFeb 09
ksh93Feb 07
ksh93-develFeb 07
clamavFeb 05
py-django111Feb 04
py-django22Feb 04
py-django30Feb 04

8 vulnerabilities affecting 50 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-02-23 08:59:33


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38435
Broken 645
Deprecated 418
Ignore 916
Forbidden 3
Restricted 150
No CDROM 72
Vulnerable 23
Expired 4
Set to expire 390
Interactive 0
new 24 hours 3
new 48 hours11
new 7 days25
new fortnight52
new month311

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2020 Dan Langille. All rights reserved.