Increase performance in pgvector using HNSW indexes
6 September 2023
•
11 minute read
Increase performance in pgvector by using embedding vectors with fewer dimensions
3 August 2023
There's been a lot of talk about pgvector performance lately, so we took some datasets and pushed pgvector to the limits to find out its strengths and limitations.
13 July 2023
13 minute read
Exploring history of Postgres pluggable storage and the possibility of landing it in the Postgres core.
1 May 2023
4 minute read
New Features in the v1.2 release of pg_graphql
21 April 2023
6 minute read
Creating validated data types in Postgres
17 February 2023
10 minute read
An example of how to build an AI-powered search engine using OpenAI's embeddings and PostgreSQL.
6 February 2023
15 minute read
A Postgres extension to store encrypted secrets and encrypt data.
16 December 2022
8 minute read
Describes new features of PostgREST 11 pre-release
5 minute read
We're making PITR available for more projects, with a new Dashboard UI that makes it simple to use.
3 minute read
Announcing the v1.0 release of pg_graphql
Describes the release of Postgres 15, new features and reasons to use it
A framework for building Postgres Foreign Data Wrappers which connects to Stripe, Firebase, Clickhouse, and more.
15 December 2022
17 minute read
Embedding Yjs and Automerge into Postgres for collaborative applications.
10 December 2022
9 minute read
Using pgsodium's Transparent Column Encryption to encrypt data and provide your users with row-level encryption.
1 December 2022
14 minute read
How to turn Postgres into an easy-to-use NoSQL database that retains all the power of SQL
24 November 2022
18 minute read
A time-tested method for contributing to the core Postgres code
27 October 2022
Comparing one of the most popular Postgres features against alternatives
14 October 2022
We're open sourcing postgres-wasm, a PostgresQL server that runs inside a browser, with our friends at Snaplet.
3 October 2022
Turns out the question of which identifier to use as a Primary Key is complicated -- we're going to dive into some of the complexity and inherent trade-offs, and figure things out
8 September 2022
Today we're releasing pg_jsonschema, a Postgres extension for JSON validation.
19 August 2022
Different approaches for tracking visitor counts with PostgreSQL.
18 July 2022
33 minute read
Using RLS to create seed files for local PostgreSQL testing.
28 June 2022
PostgreSQL has a robust set of features which we can leverage to create a generic auditing solution in 150 lines of SQL.
8 March 2022
Using Postgres Hooks to protect functionality in your Postgres database.
2 July 2021
Running repetitive tasks with your Postgres database.
5 March 2021
Understand the top PostgreSQL Interview Questions
27 February 2021
7 minute read
Creating and using a view in PostgreSQL.
18 November 2020
Have you ever wanted to restore your database's state to a particular moment in time? This post explains how, using WAL-G.
2 August 2020
What are PostgreSQL templates and what are they used for?
9 July 2020
What are physical and logical backups in Postgres?
7 July 2020
