Skip to main content
Version: 0.1

pg_mooncake on Neon

pg_mooncake is available as an extension on Neon, a fully managed serverless PostgreSQL service. This provides a great way to try the extension on a managed platform with for free.

Enable the Extension​

To enable pg_mooncake in your Neon project:

  1. Log in to your Neon account and select your project
  2. Connect to your Neon database using your preferred PostgreSQL client
  3. Create the extension by running:
SET neon.allow_unstable_extensions='true';
CREATE EXTENSION pg_mooncake;

It is also recommended to load the extension to ensure all functions will run correctly:

LOAD EXTENSION pg_mooncake;

Cloud Storage Credentials​

Neon does not support writing columnstore to their local file system. In order to use pg_mooncake on Neon, you will need to bring your own S3 bucket. Follow the instructions here.

Scale to Zero​

It is recommended to turn off Neon's scale to zero feature while using pg_mooncake. Neon's scale to zero impacts pg_mooncake's caching, and will result in slower queries on the columnstore.

Pricing​

There is no additional charge for using pg_mooncake on Neon. Also, columnstore tables are not stored in Neon's storage, and are stored instead in your object storage bucket.

Only queries on the columnstore table will use Neon's compute resources, and will be charged accordingly.