Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

IntermediateBasic SELECT

Empty a table quickly

SQL

TRUNCATE TABLE user_sessions RESTART IDENTITY CASCADE;

Tested against PostgreSQL 16

Note

“TRUNCATE is much faster than DELETE (it does not scan rows). RESTART IDENTITY resets SERIAL sequences. CASCADE truncates referencing tables.