Search code, repositories, users, issues, pull requests...
pg_analytica automatically exports specified columns from your table into columnar format at regular intervals. The columnar storage allows for blazing-fast querying compared to traditional row-based storage.
The extension relies on the parquet_fdw extension to query the exported columnar data. Follow the installation instructions on the repo.
Ensure that the extension is loaded before proceeding with next steps. Running the query below within a psql session should show that the extension is installed.
The extension periodically exports data from registered tables in columnar format to provide speed ups in querying. To register a table for export use the command below in the psql session where the extension was loaded.
The ingestion background worker periodically finds registered tables eligible for export and exports the data. The worker only needs to be launched once.
Once the export process is complete, you will be able to query the table. To check if your table is ready for export see if your table is listed in the result for the following query.
