django.git/django/db/backends/postgresql/operations.py, branch stable/5.2.x

Fixed #35936 -- Used unnest for bulk inserts on Postgres when possible.

2024-12-11T12:56:18Z

This should make bulk_create significantly faster on Postgres when provided only literal values. Thanks James Sewell for writing about this technique, Tom Forbes for validating the performance benefits, David Sanders and Mariusz Felisiak for the review.

Refs #35982 -- Made BaseDatabaseOperations.adapt_decimalfield_value() a no-op.

2024-12-09T08:46:06Z

Fixed #35856 -- Added QuerySet.explain() support for MEMORY/SERIALIZE option on PostgreSQL 17+.

2024-10-30T14:54:48Z

Refs #35295 -- Added BaseDatabaseOperations.bulk_insert_sql().

2024-03-14T10:11:15Z

Co-authored-by: Nick Pope

Fixed #35021 -- Fixed capturing queries when using client-side parameters binding with psycopg 3+.

2024-03-06T10:24:58Z

Fixed #34873 -- Added QuerySet.explain() support for GENERIC_PLAN option on PostgreSQL 16+.

2023-09-26T10:05:26Z

Fixed #34840 -- Avoided casting string base fields on PostgreSQL.

2023-09-22T04:01:11Z

Thanks Alex Vandiver for the report. Regression in 09ffc5c1212d4ced58b708cbbf3dfbfb77b782ca.

Refs #33872 -- Removed django.contrib.postgres.fields.CIText/CICharField/CIEmailField/CITextField.

2023-09-18T20:12:40Z

Per deprecation timeline.

Fixed #16055 -- Fixed crash when filtering against char/text GenericRelation relation on PostgreSQL.

2023-04-18T10:41:14Z

Fixed #33308 -- Added support for psycopg version 3.

2022-12-15T05:17:57Z

Thanks Simon Charette, Tim Graham, and Adam Johnson for reviews. Co-authored-by: Florian Apolloner Co-authored-by: Mariusz Felisiak