This helps protect our community. Learn more

Lesser known features of PostgreSQL | Citus Con: An Event for Postgres 2022

589K subscribers

1.2K views 3 years ago #PostgreSQL #Database #CitusCon

Video of a talk by Haki Benita at Citus Con: An Event for Postgres. Haki presents a few lesser known, but useful PostgreSQL features you may have never heard about! For example, do you know how you can get the number of inserted and update rows in an upsert? How to create reproducible random data for testing and demonstrations? Match a text against multiple patterns without complicated condition? How about using \copy with multi-line queries? All that and more Postgres database tips in this talk from the EMEA livestream at Citus Con. Haki Benita is a technical lead and DBA specializing in databases, web development, and performance tuning. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:56 Lesser known features from PG 10+ ⏩ 02:40 # of updated & inserted rows at upsert ⏩ 07:18 Sleeping ⏩ 09:07 Match against multiple patterns ⏩ 11:55 Generate reproducible random data ⏩ 14:26 Dollar quoting ⏩ 17:51 Prevent setting the value of an auto-gener

…

...more

Lesser known features of PostgreSQL | Citus Con: An Event for Postgres 2022

51Likes

1,220Views

2022Apr 26

Introduction

0:00

Lesser known features from PG 10

1:56

of updated & inserted rows at upsert

2:40

Sleeping

7:18

Transcript

Follow along using the transcript.

Microsoft Developer

589K subscribers

Lesser known features of PostgreSQL | Citus Con: An Event for Postgres 2022

Chapters View all

Introduction

Introduction

Introduction

Lesser known features from PG 10

Lesser known features from PG 10

Lesser known features from PG 10

of updated & inserted rows at upsert

of updated & inserted rows at upsert

of updated & inserted rows at upsert

Sleeping

Sleeping

Sleeping

Match against multiple patterns

Match against multiple patterns

Match against multiple patterns

Generate reproducible random data

Generate reproducible random data

Generate reproducible random data

Dollar quoting

Dollar quoting

Dollar quoting

Prevent setting the value of an auto-generated key

Prevent setting the value of an auto-generated key

Prevent setting the value of an auto-generated key

Microsoft Developer

Lesser known features of PostgreSQL | Citus Con: An Event for Postgres 2022

Comments 2

Chapters

Introduction

Introduction

Introduction

Lesser known features from PG 10

Lesser known features from PG 10

Lesser known features from PG 10

of updated & inserted rows at upsert

of updated & inserted rows at upsert

of updated & inserted rows at upsert

Sleeping

Sleeping

Sleeping

Match against multiple patterns

Match against multiple patterns

Match against multiple patterns

Generate reproducible random data

Generate reproducible random data

Generate reproducible random data

Dollar quoting

Dollar quoting

Dollar quoting

Prevent setting the value of an auto-generated key

Prevent setting the value of an auto-generated key

Prevent setting the value of an auto-generated key

Add constraints without validating immediately

Add constraints without validating immediately

Add constraints without validating immediately

PSQL tips

PSQL tips

PSQL tips

Q&A with Haki & Claire

Q&A with Haki & Claire

Q&A with Haki & Claire

Description

Chapters View all

Introduction

Introduction

Introduction

Lesser known features from PG 10

Lesser known features from PG 10

Lesser known features from PG 10

of updated & inserted rows at upsert

of updated & inserted rows at upsert

of updated & inserted rows at upsert

Sleeping

Sleeping

Sleeping

Microsoft Developer

Transcript

Localization on PostgreSQL | Citus Con: An Event for Postgres 2022

Chapters

Chapters