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
timescaledb Time-series database built on PostgreSQL
1.6.0 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 1.5.1Version of this port present on the latest quarterly branch.
Maintainer: kbowling@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2017-06-30 21:08:56
Last Update: 2020-01-19 20:39:26
SVN Revision: 523590
License: APACHE20 TSL
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (47 items)
  1. /usr/local/share/licenses/timescaledb-1.6.0/catalog.mk
  2. /usr/local/share/licenses/timescaledb-1.6.0/LICENSE
  3. /usr/local/share/licenses/timescaledb-1.6.0/APACHE20
  4. /usr/local/share/licenses/timescaledb-1.6.0/TSL
  5. lib/postgresql/timescaledb-1.6.0.so
  6. lib/postgresql/timescaledb-tsl-1.6.0.so
  7. lib/postgresql/timescaledb.so
  8. share/postgresql/extension/timescaledb--0.1.0--1.6.0.sql
  9. share/postgresql/extension/timescaledb--0.10.0--1.6.0.sql
  10. share/postgresql/extension/timescaledb--0.10.1--1.6.0.sql
  11. share/postgresql/extension/timescaledb--0.11.0--1.6.0.sql
  12. share/postgresql/extension/timescaledb--0.12.0--1.6.0.sql
  13. share/postgresql/extension/timescaledb--0.12.1--1.6.0.sql
  14. share/postgresql/extension/timescaledb--0.2.0--1.6.0.sql
  15. share/postgresql/extension/timescaledb--0.3.0--1.6.0.sql
  16. share/postgresql/extension/timescaledb--0.4.0--1.6.0.sql
  17. share/postgresql/extension/timescaledb--0.4.1--1.6.0.sql
  18. share/postgresql/extension/timescaledb--0.4.2--1.6.0.sql
  19. share/postgresql/extension/timescaledb--0.5.0--1.6.0.sql
  20. share/postgresql/extension/timescaledb--0.6.0--1.6.0.sql
  21. share/postgresql/extension/timescaledb--0.6.1--1.6.0.sql
  22. share/postgresql/extension/timescaledb--0.7.0--1.6.0.sql
  23. share/postgresql/extension/timescaledb--0.7.1--1.6.0.sql
  24. share/postgresql/extension/timescaledb--0.8.0--1.6.0.sql
  25. share/postgresql/extension/timescaledb--0.9.0--1.6.0.sql
  26. share/postgresql/extension/timescaledb--0.9.1--1.6.0.sql
  27. share/postgresql/extension/timescaledb--0.9.2--1.6.0.sql
  28. share/postgresql/extension/timescaledb--1.0.0--1.6.0.sql
  29. share/postgresql/extension/timescaledb--1.0.0-rc1--1.6.0.sql
  30. share/postgresql/extension/timescaledb--1.0.0-rc2--1.6.0.sql
  31. share/postgresql/extension/timescaledb--1.0.0-rc3--1.6.0.sql
  32. share/postgresql/extension/timescaledb--1.0.1--1.6.0.sql
  33. share/postgresql/extension/timescaledb--1.1.0--1.6.0.sql
  34. share/postgresql/extension/timescaledb--1.1.1--1.6.0.sql
  35. share/postgresql/extension/timescaledb--1.2.0--1.6.0.sql
  36. share/postgresql/extension/timescaledb--1.2.1--1.6.0.sql
  37. share/postgresql/extension/timescaledb--1.2.2--1.6.0.sql
  38. share/postgresql/extension/timescaledb--1.3.0--1.6.0.sql
  39. share/postgresql/extension/timescaledb--1.3.1--1.6.0.sql
  40. share/postgresql/extension/timescaledb--1.3.2--1.6.0.sql
  41. share/postgresql/extension/timescaledb--1.4.0--1.6.0.sql
  42. share/postgresql/extension/timescaledb--1.4.1--1.6.0.sql
  43. share/postgresql/extension/timescaledb--1.4.2--1.6.0.sql
  44. share/postgresql/extension/timescaledb--1.5.0--1.6.0.sql
  45. share/postgresql/extension/timescaledb--1.5.1--1.6.0.sql
  46. share/postgresql/extension/timescaledb--1.6.0.sql
  47. share/postgresql/extension/timescaledb.control
Collapse this list.
Dependency lines:
  • timescaledb>0:databases/timescaledb
To install the port: cd /usr/ports/databases/timescaledb/ && make install clean
To add the package: pkg install timescaledb
PKGNAME: timescaledb
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.
Build dependencies:
  1. cmake : devel/cmake
  2. ninja : devel/ninja
  3. postgres : databases/postgresql11-server
Runtime dependencies:
  1. postgres : databases/postgresql11-server
There are no ports dependent upon this port

Configuration Options

USES:

Master Sites:
  1. https://codeload.github.com/timescale/timescaledb/tar.gz/1.6.0?dummy=/

Number of commits found: 43

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
19 Jan 2020 20:39:26
Original commit files touched by this commit  1.6.0
Revision:523590
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.6.0

Approved by:	krion (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D23265
14 Nov 2019 19:54:37
Original commit files touched by this commit  1.5.1
Revision:517609
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.5.1

Changelog https://github.com/timescale/timescaledb/releases/tag/1.5.1

Approved by:	timur (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D22361
03 Nov 2019 19:39:23
Original commit files touched by this commit  1.5.0
Revision:516593
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.5.0

This release adds support for native compression

Changelog https://github.com/timescale/timescaledb/releases/tag/1.5.0

Approved by:	krion (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D22225
14 Sep 2019 07:29:45
Original commit files touched by this commit  1.4.2
Revision:512000
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.4.2

Changelog https://github.com/timescale/timescaledb/releases/tag/1.4.2

Approved by:	krion (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D21613
13 Aug 2019 16:01:59
Original commit files touched by this commit  1.4.1
Revision:508835  Sanity Test Failure
mat search for other commits by this committer
Convert to UCL & cleanup pkg-message (categories d)
04 Aug 2019 09:18:11
Original commit files touched by this commit  1.4.1
Revision:508083
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.4.1

Changelog https://github.com/timescale/timescaledb/releases/tag/1.4.1

Approved by:	timur (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D21157
26 Jul 2019 20:46:57
Original commit files touched by this commit  1.4.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
24 Jul 2019 17:40:19
Original commit files touched by this commit  1.4.0
Revision:507290
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.4.0

Changelog https://github.com/timescale/timescaledb/releases/tag/1.4.0

Approved by:	krion (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D21046
27 Jun 2019 22:16:23
Original commit files touched by this commit  1.3.2
Revision:505246
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.3.2

Changelog https://github.com/timescale/timescaledb/releases/tag/1.3.2

Approved by:	krion (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D20769
24 Jun 2019 05:11:00
Original commit files touched by this commit  1.3.1
Revision:505002
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.3.1

Changelog https://github.com/timescale/timescaledb/releases/tag/1.3.1

Approved by:	krion (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D20634
13 May 2019 06:38:49
Original commit files touched by this commit  1.3.0
Revision:501520
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.3.0

Changelog https://github.com/timescale/timescaledb/releases/tag/1.3.0

Approved by:	krion (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D20252
20 Mar 2019 05:54:15
Original commit files touched by this commit  1.2.2
Revision:496309
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.2.2

Approved by:	timur (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D19635
15 Feb 2019 04:46:16
Original commit files touched by this commit  1.2.1
Revision:492969
kbowling search for other commits by this committer
databases/timescaledb: fix distinfo from r492959

Approved by:	timur (implicit r492959)
Differential Revision:	https://reviews.freebsd.org/D19190
14 Feb 2019 22:53:52
Original commit files touched by this commit  1.2.1
Revision:492959
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.2.1

Changelog https://github.com/timescale/timescaledb/releases/tag/1.2.1

Approved by:	timur (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D19190
14 Feb 2019 04:12:44
Original commit files touched by this commit  1.2.0_1
Revision:492899
kbowling search for other commits by this committer
databases/timescaledb: invert TSL/APACHE_ONLY option

Invert the APACHEONLY negative option to TSL positive option per mat.

Fix pkg-message replacement issue reported by Giacomo Olgeni.

Reported by:	mat (option inversion), Giacomo Olgeni (pkg-message)
Approved by:	timur (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D19079
31 Jan 2019 01:24:30
Original commit files touched by this commit  1.2.0
Revision:491669
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.2.0

This release adds Timescale Licensed code that can be turned off with a new
build time option, APACHEONLY, to retain Apache licensing.

Changelog https://github.com/timescale/timescaledb/releases/tag/1.2.0

Approved by:	timur (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D19035
30 Dec 2018 22:09:33
Original commit files touched by this commit  1.1.1
Revision:488744
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.1.1

Changelog https://github.com/timescale/timescaledb/releases/tag/1.1.1

Approved by:	krion (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D18653
25 Dec 2018 20:25:40
Original commit files touched by this commit  1.1.0
Revision:488341
tcberner search for other commits by this committer
Change cmake default behaviour to outsource.

Ports that build out of source now simply can use "USES=cmake"
instead of "USES=cmake:outsource". Ports that fail to build
out of source now need to specify "USES=cmake:insource".

I tried to only set insource where explictely needed.

PR:		232038
Exp-run by:	antoine
16 Dec 2018 13:07:06
Original commit files touched by this commit  1.1.0
Revision:487587
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.1.0

This release adds support for Postgres 11

Changelog: https://github.com/timescale/timescaledb/releases/tag/1.1.0

Approved by:	krion (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D18576
12 Dec 2018 01:35:36
Original commit files touched by this commit  1.0.0_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
02 Nov 2018 20:25:49
Original commit files touched by this commit  1.0.0
Revision:483846
kbowling search for other commits by this committer
databases/timescaledb: Update to 1.0.0

Changelog https://github.com/timescale/timescaledb/releases/tag/1.0.0

Approved by:	krion (mentor)
Sponsored by:	BBOX.io
Differential Revision:	https://reviews.freebsd.org/D17788
25 Sep 2018 13:15:51
Original commit files touched by this commit  0.12.1
Revision:480662
kbowling search for other commits by this committer
databases/timescaledb: Update to 0.12.1

Approved by:	krion (mentor)
Differential Revision:	https://reviews.freebsd.org/D17309
12 Sep 2018 22:15:53
Original commit files touched by this commit  0.12.0
Revision:479621
kbowling search for other commits by this committer
databases/timescaledb: Update to 0.12.0

Approved by:	krion (mentor)
Differential Revision:	https://reviews.freebsd.org/D17129
15 Aug 2018 19:06:13
Original commit files touched by this commit  0.11.0
Revision:477252
swills search for other commits by this committer
databases/timescaledb: Update to 0.11.0

PR:		230636
Submitted by:	kbowling (maintainer)
29 Jul 2018 22:18:46
Original commit files touched by this commit  0.10.1_1
Revision:475857
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
in the ports tree (via Mk/bsd.default-versions.mk and lang/gcc) which
has now moved from GCC 6 to GCC 7 by default.

This includes ports
 - featuring USE_GCC=yes or USE_GCC=any,
 - featuring USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and those
 - with USES=compiler specifying one of openmp, nestedfct, c11, c++0x,
   c++11-lib, c++11-lang, c++14-lang, c++17-lang, or gcc-c++11-lib.

PR:		222542
16 Jul 2018 12:48:41
Original commit files touched by this commit  0.10.1
Revision:474732
swills search for other commits by this committer
databases/timescaledb: Update to 0.10.1

PR:		229767
Submitted by:	farrokhi
Approved by:	kbowling (maintainer)
02 Jul 2018 15:15:34
Original commit files touched by this commit  0.10.0
Revision:473749
swills search for other commits by this committer
databases/timescaledb: Update to 0.10.0

PR:		229425
Submitted by:	kbowling (maintainer)
11 May 2018 00:40:14
Original commit files touched by this commit  0.9.2
Revision:469605
swills search for other commits by this committer
databases/timescaledb: Update to 0.9.2

PR:		228084
Submitted by:	Matt Magoffin <bugs.freebsd.org@msqr.us>
Approved by:	kbowling (maintainer)
06 Apr 2018 16:08:02
Original commit files touched by this commit  0.9.1
Revision:466650
swills search for other commits by this committer
databases/timescaledb: Update to 0.9.1

PR:		227267
Submitted by:	Matt Magoffin <bugs.freebsd.org@msqr.us>
Approved by:	kbowling (maintainer)
08 Mar 2018 03:01:59
Original commit files touched by this commit  0.9.0
Revision:463860
swills search for other commits by this committer
databases/timescaledb: Update to 0.9.0

PR:		226380
Submitted by:	mahlon@martini.nu (with slight changes)
Approved by:	kbowling (maintainer)
23 Dec 2017 13:11:09
Original commit files touched by this commit  0.8.0
Revision:457049
swills search for other commits by this committer
databases/timescaledb: Update to 0.8.0

PR:		224538
Submitted by:	kbowling
10 Dec 2017 19:36:33
Original commit files touched by this commit  0.7.1
Revision:455906
riggs search for other commits by this committer
Update to upstream version 0.7.1

PR:		224197
Submitted by:	kbowling (maintainer)
05 Dec 2017 10:05:08
Original commit files touched by this commit  0.7.0
Revision:455571
olgeni search for other commits by this committer
databases/timescaledb: use PORTVERSION in pkg-message.in.
23 Nov 2017 10:20:30
Original commit files touched by this commit  0.7.0
Revision:454751
pizzamig search for other commits by this committer
databases/timescaledb: Update to 0.7.0

changelog: https://github.com/timescale/timescaledb/releases/tag/0.7.0
Moreover, switches build to CMake and adds support for pgsql10

PR:		223800
Submitted by:	kbowling@freebsd.org (maintainer)
Approved by:	olivier (mentor)
Differential Revision:	https://reviews.freebsd.org/D13191
18 Oct 2017 15:04:16
Original commit files touched by this commit  0.6.0
Revision:452344
swills search for other commits by this committer
databases/timescaledb: Update to 0.6.0

PR:		223077
Submitted by:	kbowling
27 Sep 2017 14:37:14
Original commit files touched by this commit  0.5.0
Revision:450752
swills search for other commits by this committer
databases/timescaledb: Update to 0.5.0

PR:		222486
Submitted by:	kbowling (maintainer)
10 Sep 2017 20:55:39
Original commit files touched by this commit  0.4.1_1
Revision:449591
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
(via Mk/bsd.default-versions.mk and lang/gcc) which has moved from
GCC 5.4 to GCC 6.4 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, c++11-lib, c++11-lang,
   c++14-lang, c++0x, c11, or gcc-c++11-lib.

PR:		219275
07 Sep 2017 08:49:10
Original commit files touched by this commit  0.4.1
Revision:449389
pizzamig search for other commits by this committer
databases/timescaledb: update to 0.4.1

While I'm here, adding the LICENSE_FILE variable.

PR:		222061
Submitted by:	kbowling@freebsd.org (maintainer)
Approved by:	olivier (mentor)
Differential Revision:	https://reviews.freebsd.org/D12262
27 Aug 2017 09:06:22
Original commit files touched by this commit  0.4.0
Revision:448814
tobik search for other commits by this committer
databases/timescaledb: Update to 0.4.0

Changes:	https://github.com/timescale/timescaledb/releases/tag/0.4.0
PR:		221843
Submitted by:	kbowling (maintainer)
14 Aug 2017 17:02:33
Original commit files touched by this commit  0.3.0
Revision:447952
joneum search for other commits by this committer
- databases/timescaledb: Update from 0.2.0 to 0.3.0
- pet portlint
- Changelog: https://github.com/timescale/timescaledb/blob/master/CHANGELOG.md

PR:		221315
Submitted by:	kbowling (maintainer)
Approved by:	rene (mentor)
Differential Revision:	https://reviews.freebsd.org/D11989
20 Jul 2017 20:29:03
Original commit files touched by this commit  0.2.0
Revision:446290
swills search for other commits by this committer
databases/timescaledb: update to 0.2.0

PR:		220859
Submitted by:	kbowling (maintainer)
05 Jul 2017 06:33:05
Original commit files touched by this commit  0.1.0
Revision:445049
swills search for other commits by this committer
databases/timescaledb: needs a C11 compiler

Submitted by:	kbowling (maintainer, via private communications)
30 Jun 2017 21:08:47
Original commit files touched by this commit  0.1.0
Revision:444782
swills search for other commits by this committer
databases/timescaledb: create port

An open-source time-series database optimized for fast ingest and complex
queries built on PostgreSQL.

WWW: http://www.timescale.com/

PR:		220347
Submitted by:	kbowling

Number of commits found: 43

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
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
libsshFeb 02
mariadb-connector-cFeb 02

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

* - modified, not new

All vulnerabilities

Last updated:
2020-02-14 01:16:43


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38485
Broken 681
Deprecated 242
Ignore 951
Forbidden 3
Restricted 150
No CDROM 72
Vulnerable 23
Expired 4
Set to expire 214
Interactive 0
new 24 hours 6
new 48 hours6
new 7 days27
new fortnight87
new month333

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