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
pgroonga Open-source fulltext search engine for PostGRESQL
2.2.5_1 databases 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 2.2.5Version of this port present on the latest quarterly branch.
Maintainer: bofh@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2017-09-19 19:48:39
Last Update: 2020-05-03 23:24:19
SVN Revision: 533884
Also Listed In: textproc
License: PostgreSQL
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (161 items)
  1. /usr/local/share/licenses/pgroonga-2.2.5_1/catalog.mk
  2. /usr/local/share/licenses/pgroonga-2.2.5_1/LICENSE
  3. /usr/local/share/licenses/pgroonga-2.2.5_1/PostgreSQL
  4. include/postgresql/server/contrib/pgroonga_check/pgrn-alias.h
  5. include/postgresql/server/contrib/pgroonga_check/pgrn-auto-close.h
  6. include/postgresql/server/contrib/pgroonga_check/pgrn-column-name.h
  7. include/postgresql/server/contrib/pgroonga_check/pgrn-command-escape-value.h
  8. include/postgresql/server/contrib/pgroonga_check/pgrn-compatible.h
  9. include/postgresql/server/contrib/pgroonga_check/pgrn-convert.h
  10. include/postgresql/server/contrib/pgroonga_check/pgrn-create.h
  11. include/postgresql/server/contrib/pgroonga_check/pgrn-ctid.h
  12. include/postgresql/server/contrib/pgroonga_check/pgrn-database.h
  13. include/postgresql/server/contrib/pgroonga_check/pgrn-full-text-search-condition.h
  14. include/postgresql/server/contrib/pgroonga_check/pgrn-global.h
  15. include/postgresql/server/contrib/pgroonga_check/pgrn-groonga-tuple-is-alive.h
  16. include/postgresql/server/contrib/pgroonga_check/pgrn-groonga.h
  17. include/postgresql/server/contrib/pgroonga_check/pgrn-highlight-html.h
  18. include/postgresql/server/contrib/pgroonga_check/pgrn-index-status.h
  19. include/postgresql/server/contrib/pgroonga_check/pgrn-jsonb.h
  20. include/postgresql/server/contrib/pgroonga_check/pgrn-keywords.h
  21. include/postgresql/server/contrib/pgroonga_check/pgrn-match-positions-byte.h
  22. include/postgresql/server/contrib/pgroonga_check/pgrn-match-positions-character.h
  23. include/postgresql/server/contrib/pgroonga_check/pgrn-normalize.h
  24. include/postgresql/server/contrib/pgroonga_check/pgrn-options.h
  25. include/postgresql/server/contrib/pgroonga_check/pgrn-pg.h
  26. include/postgresql/server/contrib/pgroonga_check/pgrn-portable.h
  27. include/postgresql/server/contrib/pgroonga_check/pgrn-query-expand.h
  28. include/postgresql/server/contrib/pgroonga_check/pgrn-query-extract-keywords.h
  29. include/postgresql/server/contrib/pgroonga_check/pgrn-search.h
  30. include/postgresql/server/contrib/pgroonga_check/pgrn-sequential-search.h
  31. include/postgresql/server/contrib/pgroonga_check/pgrn-tokenize.h
  32. include/postgresql/server/contrib/pgroonga_check/pgrn-value.h
  33. include/postgresql/server/contrib/pgroonga_check/pgrn-variables.h
  34. include/postgresql/server/contrib/pgroonga_check/pgrn-wal.h
  35. include/postgresql/server/contrib/pgroonga_check/pgrn-writable.h
  36. include/postgresql/server/contrib/pgroonga_check/pgroonga.h
  37. include/postgresql/server/contrib/pgroonga_check/xxhash.h
  38. include/postgresql/server/extension/pgroonga/pgrn-alias.h
  39. include/postgresql/server/extension/pgroonga/pgrn-auto-close.h
  40. include/postgresql/server/extension/pgroonga/pgrn-column-name.h
  41. include/postgresql/server/extension/pgroonga/pgrn-command-escape-value.h
  42. include/postgresql/server/extension/pgroonga/pgrn-compatible.h
  43. include/postgresql/server/extension/pgroonga/pgrn-convert.h
  44. include/postgresql/server/extension/pgroonga/pgrn-create.h
  45. include/postgresql/server/extension/pgroonga/pgrn-ctid.h
  46. include/postgresql/server/extension/pgroonga/pgrn-database.h
  47. include/postgresql/server/extension/pgroonga/pgrn-full-text-search-condition.h
  48. include/postgresql/server/extension/pgroonga/pgrn-global.h
  49. include/postgresql/server/extension/pgroonga/pgrn-groonga-tuple-is-alive.h
  50. include/postgresql/server/extension/pgroonga/pgrn-groonga.h
  51. include/postgresql/server/extension/pgroonga/pgrn-highlight-html.h
  52. include/postgresql/server/extension/pgroonga/pgrn-index-status.h
  53. include/postgresql/server/extension/pgroonga/pgrn-jsonb.h
  54. include/postgresql/server/extension/pgroonga/pgrn-keywords.h
  55. include/postgresql/server/extension/pgroonga/pgrn-match-positions-byte.h
  56. include/postgresql/server/extension/pgroonga/pgrn-match-positions-character.h
  57. include/postgresql/server/extension/pgroonga/pgrn-normalize.h
  58. include/postgresql/server/extension/pgroonga/pgrn-options.h
  59. include/postgresql/server/extension/pgroonga/pgrn-pg.h
  60. include/postgresql/server/extension/pgroonga/pgrn-portable.h
  61. include/postgresql/server/extension/pgroonga/pgrn-query-expand.h
  62. include/postgresql/server/extension/pgroonga/pgrn-query-extract-keywords.h
  63. include/postgresql/server/extension/pgroonga/pgrn-search.h
  64. include/postgresql/server/extension/pgroonga/pgrn-sequential-search.h
  65. include/postgresql/server/extension/pgroonga/pgrn-tokenize.h
  66. include/postgresql/server/extension/pgroonga/pgrn-value.h
  67. include/postgresql/server/extension/pgroonga/pgrn-variables.h
  68. include/postgresql/server/extension/pgroonga/pgrn-wal.h
  69. include/postgresql/server/extension/pgroonga/pgrn-writable.h
  70. include/postgresql/server/extension/pgroonga/pgroonga.h
  71. include/postgresql/server/extension/pgroonga/xxhash.h
  72. include/postgresql/server/extension/pgroonga_database/pgrn-alias.h
  73. include/postgresql/server/extension/pgroonga_database/pgrn-auto-close.h
  74. include/postgresql/server/extension/pgroonga_database/pgrn-column-name.h
  75. include/postgresql/server/extension/pgroonga_database/pgrn-command-escape-value.h
  76. include/postgresql/server/extension/pgroonga_database/pgrn-compatible.h
  77. include/postgresql/server/extension/pgroonga_database/pgrn-convert.h
  78. include/postgresql/server/extension/pgroonga_database/pgrn-create.h
  79. include/postgresql/server/extension/pgroonga_database/pgrn-ctid.h
  80. include/postgresql/server/extension/pgroonga_database/pgrn-database.h
  81. include/postgresql/server/extension/pgroonga_database/pgrn-full-text-search-condition.h
  82. include/postgresql/server/extension/pgroonga_database/pgrn-global.h
  83. include/postgresql/server/extension/pgroonga_database/pgrn-groonga-tuple-is-alive.h
  84. include/postgresql/server/extension/pgroonga_database/pgrn-groonga.h
  85. include/postgresql/server/extension/pgroonga_database/pgrn-highlight-html.h
  86. include/postgresql/server/extension/pgroonga_database/pgrn-index-status.h
  87. include/postgresql/server/extension/pgroonga_database/pgrn-jsonb.h
  88. include/postgresql/server/extension/pgroonga_database/pgrn-keywords.h
  89. include/postgresql/server/extension/pgroonga_database/pgrn-match-positions-byte.h
  90. include/postgresql/server/extension/pgroonga_database/pgrn-match-positions-character.h
  91. include/postgresql/server/extension/pgroonga_database/pgrn-normalize.h
  92. include/postgresql/server/extension/pgroonga_database/pgrn-options.h
  93. include/postgresql/server/extension/pgroonga_database/pgrn-pg.h
  94. include/postgresql/server/extension/pgroonga_database/pgrn-portable.h
  95. include/postgresql/server/extension/pgroonga_database/pgrn-query-expand.h
  96. include/postgresql/server/extension/pgroonga_database/pgrn-query-extract-keywords.h
  97. include/postgresql/server/extension/pgroonga_database/pgrn-search.h
  98. include/postgresql/server/extension/pgroonga_database/pgrn-sequential-search.h
  99. include/postgresql/server/extension/pgroonga_database/pgrn-tokenize.h
  100. include/postgresql/server/extension/pgroonga_database/pgrn-value.h
  101. include/postgresql/server/extension/pgroonga_database/pgrn-variables.h
  102. include/postgresql/server/extension/pgroonga_database/pgrn-wal.h
  103. include/postgresql/server/extension/pgroonga_database/pgrn-writable.h
  104. include/postgresql/server/extension/pgroonga_database/pgroonga.h
  105. include/postgresql/server/extension/pgroonga_database/xxhash.h
  106. lib/postgresql/pgroonga.so
  107. lib/postgresql/pgroonga_check.so
  108. lib/postgresql/pgroonga_database.so
  109. share/postgresql/extension/pgroonga--1.0.0--1.0.1.sql
  110. share/postgresql/extension/pgroonga--1.0.1--1.0.2.sql
  111. share/postgresql/extension/pgroonga--1.0.2--1.0.3.sql
  112. share/postgresql/extension/pgroonga--1.0.3--1.0.4.sql
  113. share/postgresql/extension/pgroonga--1.0.4--1.0.5.sql
  114. share/postgresql/extension/pgroonga--1.0.5--1.0.6.sql
  115. share/postgresql/extension/pgroonga--1.0.6--1.0.7.sql
  116. share/postgresql/extension/pgroonga--1.0.7--1.0.8.sql
  117. share/postgresql/extension/pgroonga--1.0.8--1.0.9.sql
  118. share/postgresql/extension/pgroonga--1.0.9--1.1.0.sql
  119. share/postgresql/extension/pgroonga--1.1.0--1.1.1.sql
  120. share/postgresql/extension/pgroonga--1.1.1--1.1.2.sql
  121. share/postgresql/extension/pgroonga--1.1.2--1.1.3.sql
  122. share/postgresql/extension/pgroonga--1.1.3--1.1.4.sql
  123. share/postgresql/extension/pgroonga--1.1.4--1.1.5.sql
  124. share/postgresql/extension/pgroonga--1.1.5--1.1.6.sql
  125. share/postgresql/extension/pgroonga--1.1.6--1.1.7.sql
  126. share/postgresql/extension/pgroonga--1.1.7--1.1.8.sql
  127. share/postgresql/extension/pgroonga--1.1.8--1.1.9.sql
  128. share/postgresql/extension/pgroonga--1.1.9--1.2.0.sql
  129. share/postgresql/extension/pgroonga--1.2.0--1.2.1.sql
  130. share/postgresql/extension/pgroonga--1.2.1--1.2.2.sql
  131. share/postgresql/extension/pgroonga--1.2.2--1.2.3.sql
  132. share/postgresql/extension/pgroonga--1.2.3--2.0.0.sql
  133. share/postgresql/extension/pgroonga--2.0.0--2.0.1.sql
  134. share/postgresql/extension/pgroonga--2.0.1--2.0.2.sql
  135. share/postgresql/extension/pgroonga--2.0.2--2.0.3.sql
  136. share/postgresql/extension/pgroonga--2.0.3--2.0.4.sql
  137. share/postgresql/extension/pgroonga--2.0.4--2.0.5.sql
  138. share/postgresql/extension/pgroonga--2.0.5--2.0.6.sql
  139. share/postgresql/extension/pgroonga--2.0.6--2.0.7.sql
  140. share/postgresql/extension/pgroonga--2.0.7--2.0.8.sql
  141. share/postgresql/extension/pgroonga--2.0.8--2.0.9.sql
  142. share/postgresql/extension/pgroonga--2.0.9--2.1.0.sql
  143. share/postgresql/extension/pgroonga--2.1.0--2.1.1.sql
  144. share/postgresql/extension/pgroonga--2.1.1--2.1.2.sql
  145. share/postgresql/extension/pgroonga--2.1.2--2.1.3.sql
  146. share/postgresql/extension/pgroonga--2.1.3--2.1.4.sql
  147. share/postgresql/extension/pgroonga--2.1.4--2.1.5.sql
  148. share/postgresql/extension/pgroonga--2.1.5--2.1.6.sql
  149. share/postgresql/extension/pgroonga--2.1.6--2.1.7.sql
  150. share/postgresql/extension/pgroonga--2.1.7--2.1.8.sql
  151. share/postgresql/extension/pgroonga--2.1.8--2.1.9.sql
  152. share/postgresql/extension/pgroonga--2.1.9--2.2.0.sql
  153. share/postgresql/extension/pgroonga--2.2.0--2.2.1.sql
  154. share/postgresql/extension/pgroonga--2.2.1--2.2.2.sql
  155. share/postgresql/extension/pgroonga--2.2.2--2.2.3.sql
  156. share/postgresql/extension/pgroonga--2.2.3--2.2.4.sql
  157. share/postgresql/extension/pgroonga--2.2.4--2.2.5.sql
  158. share/postgresql/extension/pgroonga--2.2.5.sql
  159. share/postgresql/extension/pgroonga_database--2.2.5.sql
  160. share/postgresql/extension/pgroonga_database.control
  161. share/postgresql/extension/pgroonga.control
Collapse this list.
Dependency lines:
  • pgroonga>0:databases/pgroonga
To install the port: cd /usr/ports/databases/pgroonga/ && make install clean
To add the package: pkg install pgroonga
PKGNAME: pgroonga
Flavors: there is no flavor information for this port.
distinfo:
Packages:
pgroonga
ABIlatestquarterly
FreeBSD:11:aarch642.0.92.2.5
FreeBSD:11:amd642.2.5_12.2.5
FreeBSD:11:i3862.2.5_12.2.5
FreeBSD:12:aarch642.0.92.2.5
FreeBSD:12:amd642.2.5_12.2.5
FreeBSD:12:i3862.2.5_12.2.5
FreeBSD:13:aarch642.2.5-
FreeBSD:13:amd642.2.5_1-
FreeBSD:13:i3862.2.5_1-
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake : devel/gmake
  2. pkgconf>=1.3.0_1 : devel/pkgconf
  3. as : devel/binutils
Library dependencies:
  1. libgroonga.so : textproc/groonga
  2. libpq.so.5 : databases/postgresql11-client
There are no ports dependent upon this port

Configuration Options

USES:

Master Sites:
  1. http://packages.groonga.org/source/pgroonga/

Number of commits found: 19

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
03 May 2020 22:24:19
Original commit files touched by this commit  2.2.5_1
Revision:533884
bofh search for other commits by this committer
databases/pgroonga: Fix packaging on pgsql=10 and earlier

PR:		246113
Reported by:	bokutin@bokut.in
30 Mar 2020 16:04:23
Original commit files touched by this commit  2.2.5
Revision:529900
bofh search for other commits by this committer
databases/pgroonga: Update version 2.2.2=>2.2.5

Relnotes:	https://pgroonga.github.io/news/#version-2-2-5
29 Nov 2019 17:38:52
Original commit files touched by this commit  2.2.2
Revision:518668
bofh search for other commits by this committer
databases/pgroonga: Update version 2.2.1=>2.2.2
13 Aug 2019 16:01:59
Original commit files touched by this commit  2.2.1
Revision:508835  Sanity Test Failure
mat search for other commits by this committer
Convert to UCL & cleanup pkg-message (categories d)
01 Aug 2019 10:44:21
Original commit files touched by this commit  2.2.1
Revision:507769
bofh search for other commits by this committer
databases/pgroonga: Update version 2.2.0=>2.2.1
26 Jul 2019 20:46:57
Original commit files touched by this commit  2.2.0_1
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
10 Jun 2019 19:21:44
Original commit files touched by this commit  2.2.0
Revision:503922
bofh search for other commits by this committer
databases/pgroonga: Update version 2.1.9=>2.2.0
24 May 2019 02:23:46
Original commit files touched by this commit  2.1.9
Revision:502415
bofh search for other commits by this committer
databases/pgroonga: Update version 2.1.8=>2.1.9

- UNBREAK
11 May 2019 08:23:16
Original commit files touched by this commit  2.1.8
Revision:501232
antoine search for other commits by this committer
Mark BROKEN

src/pgroonga.c:77:6: error: redefinition of 'PGrnGroongaInitialized' with a
different type: 'bool' vs 'bool' (aka 'char')
bool PGrnGroongaInitialized = false;
     ^
src/pgroonga.h:94:13: note: previous declaration is here
extern bool PGrnGroongaInitialized;
            ^
src/pgroonga.c:7094:1: error: conflicting types for 'PGrnIndexIsPGroonga'
PGrnIndexIsPGroonga(Relation index)
^
src/pgroonga.h:97:6: note: previous declaration is here
bool PGrnIndexIsPGroonga(Relation index);
     ^

Reported by:	pkg-fallout
10 May 2019 06:07:06
Original commit files touched by this commit  2.1.8
Revision:501157
tobik search for other commits by this committer
databases/pgroonga: Fix MECAB option description
13 Jan 2019 09:18:52
Original commit files touched by this commit  2.1.8
Revision:490118
bofh search for other commits by this committer
databases/pgroonga: Update version 2.1.7=>2.1.8

Relnotes:	https://pgroonga.github.io/news/
31 Dec 2018 17:35:50
Original commit files touched by this commit  2.1.7
Revision:488804
bofh search for other commits by this committer
databases/pgroonga: Updare version 2.1.6=>2.1.7

Relnotes:https://pgroonga.github.io/news/
19 Dec 2018 08:30:04
Original commit files touched by this commit  2.1.6
Revision:487786
bofh search for other commits by this committer
databases/pgroonga: Update version 2.0.9=>2.1.6

- Pet portlint

Relnotes:https://pgroonga.github.io/news/#version-2-1-6
12 Dec 2018 01:35:36
Original commit files touched by this commit  2.0.9_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
23 Jul 2018 20:51:17
Original commit files touched by this commit  2.0.9
Revision:475202
bofh search for other commits by this committer
databases/pgroonga: Update version 2.0.5=>2.0.9

Relnotes:	https://pgroonga.github.io/news/
24 Jun 2018 00:54:27
Original commit files touched by this commit  2.0.5
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)
22 Apr 2018 22:39:09
Original commit files touched by this commit  2.0.5
Revision:468063
bofh search for other commits by this committer
databases/pgroonga: Update version 2.0.2=>2.0.5

Relnotes:	https://pgroonga.github.io/news/
08 Jan 2018 10:41:35
Original commit files touched by this commit  2.0.2
Revision:458404
bofh search for other commits by this committer
databases/pgroonga: Update version 2.0.1=>2.0.2

Relnotes:	https://pgroonga.github.io/news/#version-2-0-2
19 Sep 2017 19:48:30
Original commit files touched by this commit  2.0.1
Revision:450158
bofh search for other commits by this committer
[NEW] databases/pgroonga: Open-source fulltext search engine for PostGRESQL

PGroonga is a PostgreSQL extension. PGroonga provides a new index access
method that uses Groonga.

Groonga is an embeddable super fast full text search engine. It can be
embedded into MySQL. Mroonga is a storage engine that is based on Groonga.
Groonga can also work as standalone search engine.

PostgreSQL supports full text search against languages that use only
alphabet and digit. It means that PostgreSQL doesn't support full text
search against Japanese, Chinese and so on. You can use super fast full
text search feature against all languages by installing PGroonga into your
PostgreSQL!

WWW: https://pgroonga.github.io/

Number of commits found: 19

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.