Service settings - advanced parameters

It is also possible to configure a wide variety of service database parameters by toggling Show advanced parameters in the upper-right corner of the Settings tab.

Once toggled, a scrollable (and searchable) list of configurable parameters is displayed.

As with the basic database configuration parameters, any changes are highlighted and the Apply changes (or Restart and apply changes) button is available to click, prompting you to confirm any changes before the Service is modified.

Multiple databases

To create more than one Timescale Cloud database, you need to create a new service for each database. Timescale Cloud does not support multiple databases within the same service. Having a separate service for each database affords each database its own isolated resources.

Another option is to use schemas. Schemas provide a way to organize tables into logical groups. A single database can contain multiple schemas, which in turn contain tables. The main difference between isolating with databases versus schemas is that a user can access objects in any of the schemas in the database they are connected to, so long as they have the corresponding privileges. Schemas can help isolate smaller use cases that do not warrant their own service.

PostgreSQL extensions

You can use PostgreSQL extensions with Timescale Cloud. If you run pg_available_extensions at the command prompt, the returned list of extensions is inaccurate. To see the allowed extensions, use this command instead:

SELECT pae.* FROM current_setting('extwlist.extensions') AS cs(e) CROSS JOIN regexp_split_to_table(e, ',') AS ext(allowed) JOIN pg_available_extensions AS pae ON (allowed=name) ORDER BY 1;

These are the currently supported extensions:

bloomBloom access method - signature file based index
btree_ginSupport for indexing common datatypes in GIN
btree_gistSupport for indexing common datatypes in GiST
citextData type for case-insensitive character strings
cubeData type for multidimensional cubes
dict_intText search dictionary template for integers
dict_xsynText search dictionary template for extended synonym processing
fuzzystrmatchDetermine similarities and distance between strings
hstoreData type for storing sets of (key, value) pairs
intarrayFunctions, operators, and index support for 1-D arrays of integers
isnData types for international product numbering standards
loLarge Object maintenance
ltreeData type for hierarchical tree-like structures
pg_stat_statementsTrack execution statistics of all SQL statements executed
pg_trgmText similarity measurement and index searching based on trigrams
pgcryptoCryptographic functions
pgroutingpgRouting Extension
postgisPostGIS geometry and geography spatial types and functions
postgis_rasterPostGIS raster types and functions
postgis_sfcgalPostGIS SFCGAL functions
postgis_tiger_geocoderPostGIS tiger geocoder and reverse geocoder
postgis_topologyPostGIS topology spatial types and functions
promscalePromscale support functions
segdata type for representing line segments or floating-point intervals
tablefuncFunctions that manipulate whole tables, including crosstab
tcnTriggered change notifications
timescaledb_toolkitTimescaleDB Toolkit
timescaledbEnables scalable inserts and complex queries for time-series data
tsm_system_rowsTABLESAMPLE method which accepts number of rows as a limit
tsm_system_timeTABLESAMPLE method which accepts time in milliseconds as a limit
unaccentText search dictionary that removes accents
uuid-osspGenerate universally unique identifiers (UUIDs)

Found an issue on this page?

Report an issue!


Related Content