Re: [PATCH] Incremental sort (was: PoC: Partial sort)

From: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
To: James Coleman <jtc331(at)gmail(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Rafia Sabih <rafia(dot)pghackers(at)gmail(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Shaun Thomas <shaun(dot)thomas(at)2ndquadrant(dot)com>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Andreas Karlsson <andreas(at)proxel(dot)se>
Subject: Re: [PATCH] Incremental sort (was: PoC: Partial sort)
Date: 2020-07-09 19:06:43
Message-ID: da260600-c214-8531-dd55-6f334726bdc5@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 7/2/20 11:47 AM, James Coleman wrote:
> It seems like the consensus over at another discussion on this topic
> [1] is that we ought to go ahead and print the zeros [for machine
> readable output formats], even though that creates some interesting
> scenarios like the fact that disk sorts will print 0 for memory even
> though that's not true.
>
> The change has already been made and pushed for hash disk spilling, so
> I think we ought to use Justin's patch here.

Do people agree with James analysis? From the RMT perspective, we would
like to get this open item wrapped up for the next beta, given[1] is now
resolved.

Thanks!

Jonathan

[1]
https://www.postgresql.org/message-id/CAApHDvpBQx4Shmisjp7oKr%3DECX18KYKPB%3DKpdWYxMKQNvisgvQ%40mail.gmail.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2020-07-09 19:07:10 Re: Postgres is not able to handle more than 4k tables!?
Previous Message Jonathan S. Katz 2020-07-09 19:03:11 Re: output columns of \dAo and \dAp