Snowflake Postgres¶
关于 Snowflake Postgres¶
Snowflake Postgres 允许您直接在 Snowflake 中创建、管理和使用 Postgres 实例。每个实例都在由 Snowflake 管理的专用虚拟机上运行一个 Postgres 数据库服务器。您可以使用任意 Postgres 客户端直接连接到这些实例。Snowflake Postgres 将 Postgres 可靠且值得信赖的事务性数据库功能引入 Snowflake 数据平台。
关于 Postgres¶
PostgreSQL (also referred to as Postgres) is a mature, open-source relational database management system that has been actively developed for more than 30 years. As a general-purpose transactional database, Postgres is designed for operational applications that require highly-concurrent read/write operations, and low-latency data processing. Postgres offers a wide array of data types, including JSONB, and sophisticated indexing capabilities. Postgres is increasingly becoming the database of choice for a wide range of use cases, and is supported by an ecosystem of community-sponsored developer tools and extensions that offer enhanced capabilities. With its proven reliability and performance, and active developer community, Postgres is a great addition to the Snowflake AI Data Cloud platform that supports an expanded set of customer workloads.
架构¶
Postgres is a mature, battle-tested database known for its reliability and performance, but it follows a more traditional architectural model than the rest of the Snowflake platform. To bring Postgres into Snowflake, we designed an approach that preserves its operational strengths while integrating it with Snowflake’s security, management, and connectivity capabilities.
Snowflake Postgres provisions a dedicated Postgres instance with attached disks to deliver best-in-class transactional performance. Each Postgres instance runs in a fully isolated private network and supports private connectivity via firewall rules or Private Link. Snowflake Postgres also offers built-in connection pooling via PgBouncer to support high-concurrency application workloads.
Snowflake Postgres is fully compatible with existing Postgres tooling and workloads, enabling you to lift-and-shift applications to Snowflake with no code changes, and use everything that works with your Postgres instances today, including ORMs and all supported SQL clients.
区域可用性¶
Snowflake Postgres 已在以下 区域 推出。
云区域 |
云区域 ID |
|---|---|
Amazon Web Services (AWS) |
|
US 东部（弗吉尼亚北部） |
us-east-1 |
US East (Ohio) |
us-east-2 |
US 西部（俄勒冈州） |
us-west-2 |
加拿大（中部） |
ca-central-1 |
EU (Ireland) |
eu-west-1 |
Europe (London) |
eu-west-2 |
EU（法兰克福） |
eu-central-1 |
亚太地区（东京） |
ap-northeast-1 |
亚太地区（新加坡） |
ap-southeast-1 |
亚太地区（悉尼） |
ap-southeast-2 |
Microsoft Azure |
|
US 东部 2（弗吉尼亚州） |
eastus2 |
US 中部（爱荷华州） |
centralus |
US 西部 2（华盛顿） |
westus2 |
加拿大中部（多伦多） |
canadacentral |
欧洲北部（爱尔兰） |
northeurope |
UK 南部（伦敦） |
uksouth |
West Europe (Netherlands) |
westeurope |
东南亚（新加坡） |
southeastasia |
日本东部（东京） |
japaneast |
澳大利亚东部（悉尼） |
australiaeast |
Postgres 主要版本¶
Postgres 主要版本 16-18 目前可用。创建新实例时，我们将自动使用最新的次要版本。
何时使用 Postgres¶
Choose Postgres when you need a high-throughput, high-concurrency operational database, you have a use case that can benefit from specific Postgres capabilities, or have an existing Postgres application.
客户可配置的安全控制¶
客户负责管理以下控制措施，以确保适合其 Postgres 实例特定内容的安全级别：
保护、保密和轮换 Postgres 实例凭据，包括密码和连接字符串。
保持适当的密码唯一性、长度、复杂性和有效期；
配置基于用户和角色的访问控制，包括用户访问的范围和持续时间。