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
postgresql93-plv8js PL/v8js procedural language for PostgreSQL database
1.4.2 databases Deleted on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port 1.4.2Version of this port present on the latest quarterly branch. NOTE: Slave port - quarterly revision is most likely wrong.
Maintainer: vanilla@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2014-10-05 07:06:13
Last Update: 2014-12-07 10:35:02
SVN Revision: 374185
License: PostgreSQL
Description:
SVNWeb : Homepage

There is no configure plist information for this port.

Dependency lines:
  • postgresql93-plv8js>0:databases/postgresql93-plv8js
No installation instructions: this port has been deleted.
The package name of this deleted port was: postgresql93-plv8js
PKGNAME: postgresql93-plv8js
Flavors: there is no flavor information for this port.
distinfo:
There is no distinfo for this port.

Master port: databases/postgresql-plv8js

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

Configuration Options
Master Sites:
  1. http://api.pgxn.org/dist/plv8/1.4.2/
  2. http://distcache.FreeBSD.org/ports-distfiles/
Port Moves
  • port moved to databases/postgresql-plv8js on 2014-12-07
    REASON: Breaks index when PGSQL_DEFAULT=9.3 and master port can be used for pgsql 9.3

Number of commits found: 3

Commit History - (may be incomplete: see SVNWeb link above for full details)
This is a slave port. You may also want to view the commits to the master port: databases/postgresql-plv8js
DateByDescription
07 Dec 2014 10:35:02
Original commit files touched by this commit  1.4.2
Revision:374185
marino search for other commits by this committer
Remove port databases/postgresql93-plv8js (avoids broken index)

This port was added on 5 October 2014.  The intention for its existence
was to provide a way to use plv8js with pgsql 9.3 instead of the default
pgsql 9.2.  It was implemented in such a way that if PGSQL_DEFAULT is
set to 9.3, the index breaks with a duplicate origin with datbases/
postgresql-plv8js.  It's possible to adjust the plv8js ports by converting
the version into an option and using typical master/slave techniques, but
I can't come up with a good reason to do this at all.

I don't think this port ever should have been created.  Anyone that would
need this port would have needed to set PGSQL_DEFAULT anyway (which
already works).  In the worst case, WANT_PGSQL could be based through a
command line.  Perhaps the motivation was to have a binary package to
avoid building it, but this reason disappears soon when the default
version of pgsql is bumped to 9.3.  Based on all those reasons, I think
it is better to remove the port outright (pointing to master port) rather
than adjust it to avoid a broken index.

PR:	195281
05 Oct 2014 14:37:25
Original commit files touched by this commit  1.4.2
Revision:370089
antoine search for other commits by this committer
Remove trailing /
05 Oct 2014 07:06:08
Original commit files touched by this commit  1.4.2
Revision:370037
lwhsu search for other commits by this committer
- Turn postgresql-plv8js version aware and add postgresql93-plv8js

Approved by:	vanilla (via skype)

Number of commits found: 3

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
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
samba410Jan 27
webkit2-gtk3Jan 26
py-pillowJan 24
giteaJan 18
drm-current-kmodJan 15
drm-devel-kmodJan 15
drm-fbsd11.2-kmodJan 15
drm-fbsd12.0-kmodJan 15
mariadb101-serverJan 15
mariadb102-serverJan 15
mariadb103-serverJan 15
mariadb104-serverJan 15
mariadb55-serverJan 15
mysql56-serverJan 15
mysql57-serverJan 15

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

* - modified, not new

All vulnerabilities

Last updated:
2020-01-27 01:40:43


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38563
Broken 678
Deprecated 447
Ignore 948
Forbidden 3
Restricted 150
No CDROM 72
Vulnerable 26
Expired 2
Set to expire 419
Interactive 0
new 24 hours 142
new 48 hours144
new 7 days167
new fortnight217
new month340

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