Vol. I · A Postgres Handbook

The Query & the Schema

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

AdvancedAdvanced PostgreSQL

Spring Data JPA & PG: Pessimistic Locking (Part 11)

The query

SQL
-- Q: How does Hibernate interact with PostgreSQL regarding Pessimistic Locking?
@Entity
public class PracticeEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE)
    private Long id;
}
Tested against PostgreSQL 16

Note

“Using GenerationType.SEQUENCE is vastly superior to IDENTITY in PostgreSQL for bulk inserts.