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
postgresql-plproxy PL/Proxy - Function-based sharding for PostgreSQL
2.9 databases on this many watch lists=1 search for ports that depend on this port Find issues related to this port Report an issue related to this port 2.9Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2007-07-26 21:20:55
Last Update: 2019-09-25 21:40:03
SVN Revision: 512812

People watching this port, also watch: postgis-jdbc, postgresql-libpqxx3

License: ISCL
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (13 items)
  1. /usr/local/share/licenses/postgresql-plproxy-2.9/catalog.mk
  2. /usr/local/share/licenses/postgresql-plproxy-2.9/LICENSE
  3. /usr/local/share/licenses/postgresql-plproxy-2.9/ISCL
  4. lib/postgresql/plproxy.so
  5. share/postgresql/extension/plproxy--2.3.0--2.9.0.sql
  6. share/postgresql/extension/plproxy--2.4.0--2.9.0.sql
  7. share/postgresql/extension/plproxy--2.5.0--2.9.0.sql
  8. share/postgresql/extension/plproxy--2.6.0--2.9.0.sql
  9. share/postgresql/extension/plproxy--2.7.0--2.9.0.sql
  10. share/postgresql/extension/plproxy--2.8.0--2.9.0.sql
  11. share/postgresql/extension/plproxy--2.9.0.sql
  12. share/postgresql/extension/plproxy--unpackaged--2.9.0.sql
  13. share/postgresql/extension/plproxy.control
Collapse this list.
Dependency lines:
  • postgresql-plproxy>0:databases/postgresql-plproxy
To install the port: cd /usr/ports/databases/postgresql-plproxy/ && make install clean
To add the package: pkg install postgresql-plproxy
PKGNAME: postgresql-plproxy
Flavors: there is no flavor information for this port.
distinfo:
Packages:
postgresql-plproxy
ABIlatestquarterly
FreeBSD:11:aarch642.82.9
FreeBSD:11:amd642.92.9
FreeBSD:11:i3862.92.9
FreeBSD:12:aarch642.82.9
FreeBSD:12:amd642.92.9
FreeBSD:12:i3862.92.9
FreeBSD:13:aarch642.9-
FreeBSD:13:amd642.9-
FreeBSD:13:i3862.9-
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. bison : devel/bison
  2. gmake : devel/gmake
Library dependencies:
  1. libpq.so.5 : databases/postgresql11-client
There are no ports dependent upon this port

Configuration Options

USES:

Master Sites:
  1. https://codeload.github.com/plproxy/plproxy/tar.gz/plproxy_2_9?dummy=/

Number of commits found: 31

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
25 Sep 2019 20:40:03
Original commit files touched by this commit  2.9
Revision:512812
sunpoet search for other commits by this committer
Update to 2.9

Changes:	https://github.com/plproxy/plproxy/blob/master/NEWS.md
		https://plproxy.github.io/changelog.html
19 Aug 2019 20:51:06
Original commit files touched by this commit  2.8_2
Revision:509332
sunpoet search for other commits by this committer
Fix bison warning

src/parser.y:63.1-25: warning: deprecated directive, use '%define api.prefix
{plproxy_yy}' [-Wdeprecated]
   63 | %name-prefix="plproxy_yy"
      | ^~~~~~~~~~~~~~~~~~~~~~~~~
16 Aug 2019 18:09:24
Original commit files touched by this commit  2.8_2
Revision:509088
sunpoet search for other commits by this committer
Fix build with PostgreSQL 10 and 11
04 Aug 2019 16:09:59
Original commit files touched by this commit  2.8_2
Revision:508100
sunpoet search for other commits by this committer
Remove outdated post-patch:
26 Jul 2019 20:46:57
Original commit files touched by this commit  2.8_2
Revision:507372
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330
12 Dec 2018 01:35:36
Original commit files touched by this commit  2.8_1
Revision:487272
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590
24 Jun 2018 00:54:27
Original commit files touched by this commit  2.8
Revision:473169
linimon search for other commits by this committer
Workaround the following problem on aarch64 by setting LLD_UNSAFE=yes:

  cc: error: invalid linker name in argument '-fuse-ld=bfd'

Neither emaste nor I can figure out exactly where the offending stanza is
coming in.  It will take someone with more knowledge of gmake debug flags,
and possibly the src build infrastructure, to figure it out.

While here, pet portlint.

Approved by:	portmgr (tier-2 blanket)
17 May 2018 18:29:40
Original commit files touched by this commit  2.8
Revision:470229
sunpoet search for other commits by this committer
Simplify Makefile

- Update COMMENT
- Update pkg-descr
- Take maintainership
17 May 2018 09:56:55
Original commit files touched by this commit  2.8
Revision:470213
tz search for other commits by this committer
Drop MAINTAINERship for these ports:

- databases/postgresql-plproxy
- devel/fpp
- devel/gnu-efi
- games/nlarn
- games/wesnoth
- mail/phpmailer
- mail/tlb
- ports-mgmt/pkg-plist
- sysutils/battray
- textproc/xml-parse.el
22 Feb 2018 12:19:27
Original commit files touched by this commit  2.8
Revision:462585
tz search for other commits by this committer
databases/postgresql-plproxy: Update from 2.7 to 2.8

Changelog: https://plproxy.github.io/changelog.html
03 May 2017 12:16:49
Original commit files touched by this commit  2.7
Revision:440009
mat search for other commits by this committer
Simplify USE_GITHUB usage.

Sponsored by:	Absolight
14 Mar 2017 13:46:15
Original commit files touched by this commit  2.7
Revision:436153
tz search for other commits by this committer
databases/postgresql-plproxy: Update from 2.5 to 2.7

Changelog: https://plproxy.github.io/changelog.html

This adds support for PostgreSQL 9.5

Also:
- take maintainership
- change MASTERSITE to GitHub
- remove obsoleted check for PostgreSQL 9.1 (no longer in ports)
- update homepage of project

PR: 201796, 217515
03 Jun 2015 17:27:31
Original commit files touched by this commit  2.5_1
Revision:388460
amdmi3 search for other commits by this committer
- Add LICENSE_FILE
- Strip library
05 Dec 2014 00:30:20
Original commit files touched by this commit  2.5
Revision:373992
feld search for other commits by this committer
Update "BSD" licenses in databases category
20 Oct 2014 10:41:13
Original commit files touched by this commit  2.5
Revision:371255
bapt search for other commits by this committer
Cleanup plist
25 Aug 2014 17:53:27
Original commit files touched by this commit  2.5
Revision:366114
crees search for other commits by this committer
Convert pgsql ports to use USES+=pgsql

Reviewed by:	bapt
05 Aug 2014 13:57:34
Original commit files touched by this commit  2.5
Revision:364100
wg search for other commits by this committer
postgresql-plproxy: support stage and fix pkg-plist
20 Sep 2013 16:13:49
Original commit files touched by this commit  2.5
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)
14 Aug 2013 22:35:54
Original commit files touched by this commit  2.5
Revision:324744  Sanity Test Failure
ak search for other commits by this committer
- Remove MAKE_JOBS_SAFE variable

Approved by:	portmgr (bdrewery)
07 Jul 2013 00:15:47
Original commit files touched by this commit  2.5
Revision:322415
jgh search for other commits by this committer
- convert from USE_GMAKE to USES=gmake
- trim historical headers

With hat: pgsql@
29 Apr 2013 14:21:24
Original commit files touched by this commit  2.5
Revision:316819
miwi search for other commits by this committer
- Update to 2.5

PR:		178159
Submitted by:	ports fury
22 Apr 2013 13:27:48
Original commit files touched by this commit  2.4
Revision:316230
bapt search for other commits by this committer
Reassign skv@ ports to the heap

Feature safe:	yes
08 Mar 2013 11:32:12
Original commit files touched by this commit  2.4
Revision:313635
bapt search for other commits by this committer
Convert USE_BISON to USES= bison

It brings bison as a build dependency in case it is set the following way:
USES= bison or USES= bison:build

it brings bison as a run dependency in case it is set the following way:
USES= bison:run

it brings bison both as a run and build dependency in case it the set the
following way:
USES= bison:both

While here trim some headers
Convert some USE_GNOME= gnomehack to USES= pathfix
14 Jun 2012 19:25:00
Original commit files touched by this commit  2.4

skv search for other commits by this committer
Update to 2.4

Changes:        http://pgfoundry.org/frs/shownotes.php?release_id=1947
PR:             ports/168669
Submitted by:   Anton Yuzhaninov
27 Feb 2011 08:18:53
Original commit files touched by this commit  2.2

skv search for other commits by this committer
Update to 2.2

Changes:        http://pgfoundry.org/frs/shownotes.php?release_id=1778
09 Jul 2010 13:35:01
Original commit files touched by this commit  2.1

skv search for other commits by this committer
Update to 2.1

Changes:        http://pgfoundry.org/frs/shownotes.php?release_id=1214
                http://pgfoundry.org/frs/shownotes.php?release_id=1228
                http://pgfoundry.org/frs/shownotes.php?release_id=1284
                http://pgfoundry.org/frs/shownotes.php?release_id=1509
                http://pgfoundry.org/frs/shownotes.php?release_id=1635
04 Sep 2008 14:24:15
Original commit files touched by this commit  2.0.5

skv search for other commits by this committer
Update to 2.0.5.
19 Jun 2008 02:54:54
Original commit files touched by this commit  2.0.2_1

pav search for other commits by this committer
- This port has been BROKEN for more than 6 months.  It will be removed unless
  fixed in next two months.

With hat:       portmgr
06 Jun 2008 13:17:10
Original commit files touched by this commit  2.0.2_1

edwin search for other commits by this committer
Bump portrevision due to upgrade of devel/gettext.

The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).

PR:             ports/124340
Submitted by:   edwin@
Approved by:    portmgr (pav)
18 Aug 2007 01:08:36
Original commit files touched by this commit  2.0.2

kris search for other commits by this committer
BROKEN: Does not build
26 Jul 2007 21:20:37
Original commit files touched by this commit  2.0.2

skv search for other commits by this committer
Add postgresql-plproxy 2.0.2, PL/Proxy is database partitioning system.

Number of commits found: 31

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
chromiumMay 24
piwigoMay 23
drupal7May 22
tomcat-develMay 22
tomcat7May 22
tomcat85May 22
tomcat9May 22
unboundMay 22
zabbix3-proxyMay 20
zabbix3-serverMay 20
rubygem-actionpack52May 19
rubygem-actionpack60May 19
rubygem-actionview52May 19
rubygem-actionview60May 19
rubygem-activestorage52May 19

14 vulnerabilities affecting 165 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-05-24 19:56:04


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 39415
Broken 82
Deprecated 622
Ignore 372
Forbidden 5
Restricted 147
No CDROM 76
Vulnerable 24
Expired 17
Set to expire 577
Interactive 0
new 24 hours 3
new 48 hours14
new 7 days38
new fortnight83
new month251

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