---
title: "The modern historian for industrial scale"
description: "Industrial historian purpose-built for Ignition and manufacturing. TimescaleDB delivers thousands of rows per second with microsecond query speeds."
url: "https://www.tigerdata.com/timescaledb-for-ignition"
---


# The modern historian for industrial scale

Ignition Enterprise Historian and TimescaleDB. Built to work together.

Designed for the performance and reliability that mission-critical industrial workloads demand, with the native Ignition experience operators and engineers already know.

[Get started with the public beta](#request-private-preview) | [Read the Docs](https://enterprise.tigerdata.com/installation)

## Industrial data is outgrowing traditional historian architectures

The workload changed. The historian architecture needs to change with it.

### More tags (Thousands → millions)

More connected equipment means more time-series streams to ingest and manage.

### Higher frequency (Minutes → sub-second)

Higher-resolution operations create dramatically more writes.

### Longer retention (Weeks → years)

History stays valuable for troubleshooting, optimization, and reporting.

### More demanding apps (Charts → analytics → AI)

The same data now serves more users and more complex queries.

## Ignition Enterprise Historian, powered by TimescaleDB

### Purpose-built for Ignition

Use a dedicated historian with simplified setup, not a general-purpose database you have to design and optimize yourself.

### Powered by enterprise-grade TimescaleDB

Store and query historian data on a production-ready time-series database built to handle high-volume industrial workloads.

### Built and supported together

Developed by Inductive Automation and Tiger Data, with support from both vendors.

## Historian setup, integrated into Ignition

### 01. Deploy

Create a TimescaleDB database cluster in the TimescaleDB Console.

### 02. Select

Choose TimescaleDB as the historian backend in Ignition.

### 03. Connect

Provide the connection information for your TimescaleDB Console.

### 04. Validate & Create

Ignition validates the deployment and configures the historian database.

No separate database design and tuning workflow

## One historian. Three ways to deploy it.

Every deployment includes:

- No tag or user limits
- Enterprise-grade HA and backups
- Operational tooling
- Vendor support

### TimescaleDB for Ignition

For standard Ignition historian deployments

- Single or multiple Ignition gateways
- Designed for medium-scale deployments
- One standard configuration

**Procurement:** Through Inductive Automation

**Pricing model:** Fixed price perpetual license

[Get started](#request-private-preview)

### TimescaleDB Enterprise

For larger, more complex industrial architectures

- Multi-level or complex gateway architectures
- Flexible sizing and greater deployment control
- Can serve as a LiveSync destination

**Procurement:** Through Tiger Data

**Pricing model:** Fixed price by server configuration

[Explore Timescale Enterprise](/timescaledb-enterprise)

### Tiger Cloud

For fully managed historian deployments in the cloud

- Database infrastructure operated by Tiger Data
- HA, backups, and upgrades handled for you
- Available on AWS, Azure, and GCP

**Procurement:** Through Tiger Data

**Pricing model:** Usage-based pricing

[Explore Tiger Cloud](/go/trial)

## Built for a different class of workload

| Criteria | Ignition SQL Historian | Ignition Enterprise Historian |
| --- | --- | --- |
| Database | SQL Server or PostgreSQL | PostgreSQL + TimescaleDB |
| Scale | Small → medium | Small → very large |
| Performance | Moderate ingest and query workloads | High-rate ingest and fast queries across large histories |
| Data scope | Tag history + relational data | Tag history + full operational context |
| Storage | General-purpose row storage | Relational row storage + compressed columnar tag history |
| Query processing | Raw history pulled into Ignition for processing | Filtering and aggregation executed in TimescaleDB |
| Database Operations | Your team configures and operates the database | Built-in HA, backup, monitoring, and lifecycle management |

## Performance benchmarks

Identical test configuration: 16 vCPU / 128 GB RAM.  2.1 billion record dataset.

| Metric | SQL Historian + PostgreSQL | SQL Historian + TimescaleDB Community (OSS) | Enterprise Historian |
| --- | --- | --- | --- |
| On-Disk Footprint | 217 GB | 17 GB | 21 GB |
| Sustained Ingest | 77,500 pts/sec | 86,400 pts/sec | 1,040,000 pts/sec |
| 1 Year Aggregation (Raw) | 131 sec | 78 sec | 9.8 sec |
| 1 Month Aggregation (Raw) | 8.3 sec | 6.2 sec | 0.7 sec |
| Aggregate execution | Computed in Ignition from raw history | Computed in Ignition from raw history | Executed natively in TimescaleDB |

### Why it's faster

### Automated partitioning

Incoming data is automatically partitioned by time, and irrelevant partitions are pruned from historical queries.

### Compressed columnar storage

Tag history is compressed in columnar form, allowing queries to read only the columns they need.

### Native historian ingest

History is written through a historian-specific data path designed for sustained, high-rate ingest.

### Database-side analytics

Filtering and aggregation run inside TimescaleDB, while continuous aggregates maintain common rollups.

[Learn more about TimescaleDB](/timescaledb)

## Deploy TimescaleDB Enterprise

Bring the proven TimescaleDB data engine together with enterprise-grade operations and reliability, across the infrastructure you control.

Install the console to manage deployments across your infrastructure, or try demo mode to run database clusters locally. Docker required.

```sh
curl -fsSL https://enterprise.tigerdata.com/install/timescale-enterprise.sh | sh
```

For more instructions, see the [Installation Documentation](https://enterprise.tigerdata.com/installation).

## FAQ

### What is Ignition Enterprise Historian?

Ignition Enterprise Historian is a new historian experience from Inductive Automation designed to work with TimescaleDB. It combines the native Ignition experience operators and engineers already know with database infrastructure designed for demanding industrial workloads.

### How is Enterprise Historian different from SQL Historian?

SQL Historian connects Ignition to a general-purpose SQL database that your team configures and operates. Enterprise Historian is purpose-built for historian workloads, with database setup, optimization, high availability, backup, monitoring, and lifecycle management built into the experience. It also pushes filtering and aggregation into TimescaleDB instead of pulling raw history into Ignition for processing.

### How does Enterprise Historian with TimescaleDB Enterprise compare to SQL Historian with TimescaleDB Community (OSS)?

With SQL Historian and TimescaleDB Community, TimescaleDB is used as a general-purpose SQL database, and your team is responsible for configuring, tuning, and operating the database environment. With Enterprise Historian and TimescaleDB Enterprise, historian-specific database setup and optimization are integrated into the Ignition experience, while TimescaleDB Enterprise provides production operations around the database, including high availability, backups, monitoring, and lifecycle management.

### How is Enterprise Historian different from Core Historian?

Core Historian is Ignition’s embedded, low-maintenance historian option. Enterprise Historian is designed for deployments that need a separate database foundation for larger or more operationally demanding industrial workloads, including requirements around scale, high availability, backups, and database operations.

### Is this just a TimescaleDB database connector for Ignition?

No. Enterprise Historian is a dedicated historian integration, not simply a generic database connection. Ignition works with the TimescaleDB environment to configure the historian-specific database structures and settings required for the workload.

### What is TimescaleDB for Ignition vs. TimescaleDB Enterprise?

Both are TimescaleDB deployment options that work with Ignition Enterprise Historian. TimescaleDB for Ignition is the streamlined option for standard single- or multi-gateway historian deployments. TimescaleDB Enterprise is designed for larger or more complex architectures that need flexible sizing, greater deployment control, and broader database operations.

### Do I need to know TimescaleDB to use Enterprise Historian?

You should not need deep TimescaleDB expertise. Ignition guides the setup and automates historian-specific database configuration so teams do not have to design and tune the database from scratch. The current setup flow is Deploy → Select → Connect → Validate & Create.

### Where can I run Enterprise Historian? Does it require Tiger Cloud?

No. Tiger Cloud is not required. The architecture supports customer-controlled deployments using TimescaleDB for Ignition or TimescaleDB Enterprise, as well as a fully managed Tiger Cloud option for teams that want Tiger Data to operate the database infrastructure.

### Does it still support relational data?

Yes. TimescaleDB is built on PostgreSQL, so historian data can live alongside relational operational context in the same database. The architecture supports both relational row storage and optimized storage for high-volume tag history.

### Are there tag or user limits?

There are no tag- or user-based licensing limits. The workload a deployment can support depends on its configuration, ingest rate, retention, query patterns, and availability requirements.

### Can I use open-source TimescaleDB?

Open-source TimescaleDB remains available, but the purpose-built Enterprise Historian experience is designed around the supported TimescaleDB for Ignition / TimescaleDB Enterprise deployment paths rather than a DIY open-source database configuration.

### What if I’m already using TimescaleDB Community with SQL Historian?

You can continue using TimescaleDB Community with SQL Historian. Enterprise Historian is a different experience: historian-specific database configuration is integrated into Ignition, and when paired with TimescaleDB Enterprise, the deployment also includes production operations such as high availability, backups, monitoring, and lifecycle management.

### Can I migrate an existing SQL Historian to Enterprise Historian?

The migration approach depends on your existing historian database, data volume, retention requirements, and architecture. If you’re currently using SQL Historian with PostgreSQL, SQL Server, MySQL, or another database, talk to us about your environment and the appropriate migration path.

### What kind of performance can I expect?

Performance depends on the workload and deployment configuration. Enterprise Historian is designed for high-rate ingest and fast queries across large histories. See the benchmark results above for performance measured using the published test configuration.

### Is Ignition Enterprise Historian generally available?

Not yet. It’s available now in public preview. Get started today and get updates on General Availability of the offering.
