Postgres

Open source data warehouse

  1. Dive deeper than traditional analytics tools by querying raw data with SQL

  2. Analyze all your web, mobile, and other data sources together in a single place

  3. With one code implementation, send your data off to hundreds of tools

Postgres

How Postgres works

PostgreSQL, or Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications.

PostgreSQL is ACID-compliant and transactional. PostgreSQL has updatable views and materialized views, triggers, foreign keys; supports functions and stored procedures, and other expandability. Developed by the PostgreSQL Global Development Group, free and open-source.

Connect and load customer data into Postgres in minutes. Simply connect Postgres, track events in your app, and we’ll load your data.

Connect Postgres.
Connect Postgres.
Track events in your app.
Track events in your app.
We'll load your data.
We'll load your data.
Postgres

Get more out of Postgres with Segment

Start using Postgres in minutes instead of months.

Optimized for analytics

We transform the data before loading it so it’s easy to query.

  • Fully managed schema: We dynamically update your schema when you send new properties.

  • Perfect for analytics: Tables for events and columns for properties to make writing SQL easier.

  • Faster queries: Compressed data types to keep your database small and queries fast.

Connect to your Postgres

  • Explore your raw data using business intelligence tools to visualize and analyze customer data

Sync data from any source

  • Website: Analytics.js javascript library

  • Server: Server-side libraries like Node, Go, PHP, Ruby

  • Mobile: Our iOS and Android libraries

  • Cloud: Cloud services like Salesforce, Facebook Ads and more

Learn more about Postgres and Segment

Integrate Postgres with Segment

Segment makes it easy to set up Postgres.