PG Edge Cache, Postgres & OpenAI, citext to Collations, Compression Options | Scaling Postgres 254

Episode 254 February 26, 2023 00:13:14
PG Edge Cache, Postgres & OpenAI, citext to Collations, Compression Options | Scaling Postgres 254
Scaling Postgres
PG Edge Cache, Postgres & OpenAI, citext to Collations, Compression Options | Scaling Postgres 254

Feb 26 2023 | 00:13:14

/

Hosted By

Creston Jamison

Show Notes

In this episode of Scaling Postgres, we discuss PG Edge Cache, using Postgres & OpenAI, migrating citext to case-insenstive collations and PG16 compression options.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com

 

Other Episodes

Episode 0

December 20, 2020 00:14:06
Episode Cover

PgMiner Botnet, Collation Index Corruption, postgresql.conf, Custom Data Types | Scaling Postgres 145

In this episode of Scaling Postgres, we discuss the PGMiner botnet attack, how collation changes can cause index corruption, managing your postgresql.conf and implementing...

Listen

Episode 224

July 18, 2022 00:13:57
Episode Cover

Column Performance, BRIN Win, Unique and Null, Parallel Distinct | Scaling Postgres 224

In this episode of Scaling Postgres, we discuss how too many columns in a table can affect performance, at what point BRIN indexes win...

Listen

Episode 268

June 04, 2023 00:11:38
Episode Cover

Faster Copy, psql Variables, backup_label, Bad Encoding | Scaling Postgres 268

  In this episode of Scaling Postgres, we discuss faster COPY in Postgres 16, how to use psql variables, the importance of backup_label and issues...

Listen