Re: PostgreSQL 12: Feature Highlights

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--dT6SBCQVpGmyErePGLn2qkyaIeCPBkW3p
Content-Type: multipart/mixed; boundary="CZPIiJ4Yc0VCtqsoDgy2MF1NzsxDZGq0k";
 protected-headers="v1"
From: "Jonathan S. Katz" <[email protected]>
To: Amit Langote <[email protected]>,
 [email protected]
Message-ID: <[email protected]>
Subject: Re: PostgreSQL 12: Feature Highlights
References: <[email protected]>
 <[email protected]>
 <[email protected]>
In-Reply-To: <[email protected]>

--CZPIiJ4Yc0VCtqsoDgy2MF1NzsxDZGq0k
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: quoted-printable

On 5/14/19 10:31 PM, Amit Langote wrote:
> Hi Jonathan,
>=20
> Thanks for the updated draft.
>=20
> On 2019/05/15 11:03, Jonathan S. Katz wrote:
>> Without further ado:
>>
>> # Feature Highlights
>>
>> 1. Indexing
>>
>> - Improvements overall performance to standard (B-tree) indexes with
>> writes as well as with bloat
>> - REINDEX CONCURRENTLY
>> - GiST indexes now support covering indexes (INCLUDE clause)
>> - SP-GiST indexes now support K-NN queries
>> - WAL overhead reduced on GiST, GIN, & SP-GiST index creation
>>
>> 2. Partitioning Improvements
>>
>> - Improved partition pruning, which improves performance on queries ov=
er
>> tables with thousands of partitions that only need to use a few partit=
ions
>> - Improvements to COPY performance and ATTACH PARTITION
>> - Allow foreign keys to reference partitioned tables
>=20
> About the 1st item in "Partitioning Improvements", it's not just partit=
ion
> pruning that's gotten better.  How about writing as:
>=20
>  - Improved performance of processing tables with thousands of partitio=
ns
>    for operations that only need to touch a small number of partitions

Thanks, I will use some wording like this:

- Improved performance of processing tables with thousands of partitions
for operations that only need to use a small number of partitions

>=20
> Per discussion upthread, that covers improvements to both partition
> pruning and tuple routing.
>=20
> Also, could the title "2. Partitioning Improvements" be trimmed down to=

> "2. Partitioning", to look like "1. Indexing" for consistency?

These are just my rough notes and do not reflect how it will read in the
PR itself; however I will keep that in mind.

Thanks,

Jonathan


--CZPIiJ4Yc0VCtqsoDgy2MF1NzsxDZGq0k--

--dT6SBCQVpGmyErePGLn2qkyaIeCPBkW3p
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlzewy4ACgkQ8QSccp8c
ZSdb7g/+J3inv5LEUfIidAGjg3HonjkZImjiTyldRPISsj8BAfhRD058eV2OaEUC
UU8cYiayOVDVzg1Rfn66b90XDG/9Xz1f3rcEyG+eCZoUkMx+6ys7QrQlMQ2lmrFU
1NTxIZG2U1AHR8i7THNANeEp43nrbc331g+CDyD0thtUun7/RZ+AfT5/hi/mMk81
ThZ+vPDbBFq/hNsnjWRIPFaTFJG/RZiEhKCyrg+8chqwBOa2wRUXX59navLu1pKR
7I3iS/yjjjJkJcEfzRT42/oPCuDrxXoxU7/S6CtY9LxmdsjrYW1Ux9Wdq1ntZEb3
MTyK37KczHHTWz/NL/AvfHl0/ZJc09uXXRYKqu3f6fnrXKb5nqPrrnn8X2Fb/FH4
SsHRDjzkz+KOo0gY5bCGxG4aP6bovpdHuBWM/dxXUyPfW39n1xWCRBwaFu7ILMwj
VFTaCZIE4OS1q6Z2edaQJiRT2aMJ9Gyvv3tcfftxYDd7cu/Hxz7ZJS4F7uwWIbeM
NI/yl6n042Y77jXEWWdTjE79IRBfH+WuuxgBQRqLNEpYh3kc9exT1IjnuFo/BPcR
+DLmQXsq5nJkbn0+M3QYzry0wBVSyWFZVe5awRdeM0SoACXKaAJzYiOq5ZPrPcdC
KO8o0sZCeeeRIBkigYsIAkw0nvxj8GGtHI9FgQrnmk3c4PGI9ws=
=dQOQ
-----END PGP SIGNATURE-----

--dT6SBCQVpGmyErePGLn2qkyaIeCPBkW3p--