Architecture

Operating System

Software License

Interface

Indexes

Other Objects

Tables and Views

Deployment Model

Database Capabilities

Features

Support Features

String

Max Blob Clob Size

Max DB Size

Max Table Size

Relational Model

Compare by Operating System
Windows
Linux
UNIX

Proprietary

Compare by Interface
GUI
Multiple
SQL

Defragmentation

Trigger

Temporary Table

On Premise

Blobs and Clobs

Compare by Features
ACID
Backup
Encryption of Data
High Availability
Internet Protocol Support
Multi-Core Support
Network Protocols Supported
Referential Integrity
Transactions
Unicode
XML Format Support

24/7
Forums
Knowledge base
Phone
Wiki

CHARACTER
CLOB

4 GB

8 exabytes

32,000

Object-relational Model

Compare by Operating System
Windows
Mac OS X
Linux
BSD

PostgreSQL

GUI Compare GUI Database Management SystemSQL Compare SQL Database Management System

Bitmap
Expression
Full-text
GIN
GiST
Hash
Partial
R-/R+ Tree
Reverse

Cursor
Data Domain
External Routine
Function
Procedure
Trigger

Materialized Views
Temporary Table

On Premise

Blobs and Clobs
Common Table Expressions
Except
Inner Joins
Inner Selects
Intersect
Merge Joins
Outer Joins
Parallel Query
Union
Windowing Functions

Compare by Features
ACID
Backup
Custom Functions
Database Imports
Export Data
Extensibility
High Availability
Highly Scalable
Import Data
Java Support
Multi-Core Support
Parallel Processing
Real Time Access to Database
Referential Integrity
Templates
Transactions
Unicode
XML Format Support

Email
FAQ
Live chat
Mailing List
Tips and hints
White papers

CHAR
CHARACTER
CHARACTER VARYING
TEXT
VARCHAR

1 GB (text, bytea) - stored inline or 4 TB (stored in pg_largeobject)

Unlimited

32 TB