Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1ae0qu-0003ND-Uu for pgsql-hackers@arkaria.postgresql.org; Thu, 10 Mar 2016 13:42:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ae0qu-0004cZ-HT for pgsql-hackers@arkaria.postgresql.org; Thu, 10 Mar 2016 13:42:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ae0pX-0001qE-Kz for pgsql-hackers@postgresql.org; Thu, 10 Mar 2016 13:40:43 +0000 Received: from mail-wm0-x234.google.com ([2a00:1450:400c:c09::234]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ae0pT-00057f-SK for pgsql-hackers@postgresql.org; Thu, 10 Mar 2016 13:40:43 +0000 Received: by mail-wm0-x234.google.com with SMTP id p65so29113797wmp.0 for ; Thu, 10 Mar 2016 05:40:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:cc:date:in-reply-to:references :mime-version:content-transfer-encoding; bh=3fgi79Uh7eeK2r2WVJ7r7jQzp35he//KeIO01jP5ggk=; b=ErApWlYv5BDZoZFmkUju79pcVNMtBUCq3DwZlN224EtgON9G4beyqixX5/lCtKdjMb SUI/RKiLVxAGJlo0JnLlk1J3rRddjdquSvxF+S6Kv6lvCU3deQ2uTj6Uj1LDatTE/OeD FcJx0q6VBu9Am63MB4TsljKaEygRJr71Aa8v8TjShJTvZ8zquYEf8jUInI+eNaExR3qp HzYWGMdIUnjgIP+KsjLACHMv5KC9MEER1/K4c1a0jJ670O1esKBr3ynkyWOioFBZE3al PIcrkIFM/5sd4v9ioBAjM90zczNRnnoGIFlcxT4FJEnEyQCCCXr0BfmW5VTegjN35wQR 7D+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:message-id:subject:from:to:cc:date:in-reply-to :references:mime-version:content-transfer-encoding; bh=3fgi79Uh7eeK2r2WVJ7r7jQzp35he//KeIO01jP5ggk=; b=Pqta5J5D528wbr7AvUm3YAOeHSNhOlM94rWXKRKMXZHQt53z1R3qJJTdZnAYH+Om7L lX8A6Py0YAxls5TvCWwOyET6R8ftp15XZSMCLpK349uGW57Q+8cqAT6JA16H7hdw/oea yQRCui5V4j4gAZdmYQe3On09KkSz++QZ1Y+euEYz+bhnnGc+ndrHHoVLkwLrr1OPybIM +091oqJLDcStvODPpGzrm9eJ2T8IyUzp39bg8blvfM+dnp1UxVYtGEZtQZH2h1KXxFEy lnKNC5fSoxy1MV+oPlOGvPMEJnCfDb6RVqsgcRyEEwCLpWWpNxgkcqBwDKXrJgj9wWf5 lMdw== X-Gm-Message-State: AD7BkJLyhgSuJz3ma0clViiwfYZpoBcogOuYE7EuSz8p9zLq8u62Io9pR/pGNWDb4027MLEz X-Received: by 10.194.90.100 with SMTP id bv4mr3912527wjb.4.1457617238919; Thu, 10 Mar 2016 05:40:38 -0800 (PST) Received: from development (ip-78-45-216-26.net.upcbroadband.cz. [78.45.216.26]) by smtp.gmail.com with ESMTPSA id e127sm3613504wma.20.2016.03.10.05.40.37 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 10 Mar 2016 05:40:38 -0800 (PST) Message-ID: <1457617234.31876.55.camel@2ndquadrant.com> Subject: Re: Using quicksort for every external sort run From: Tomas Vondra To: Peter Geoghegan Cc: Robert Haas , Jeff Janes , Simon Riggs , Pg Hackers , Heikki Linnakangas , David Rowley , Greg S Date: Thu, 10 Mar 2016 14:40:34 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.12.11 (3.12.11-1.fc21) Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Hi, On Mon, 2015-12-28 at 15:03 -0800, Peter Geoghegan wrote: > On Fri, Dec 18, 2015 at 11:57 AM, Peter Geoghegan wrote: > > BTW, I'm not necessarily determined to make the new special-purpose > > allocator work exactly as proposed. It seemed useful to prioritize > > simplicity, and currently so there is one big "huge palloc()" with > > which we blow our memory budget, and that's it. However, I could > > probably be more clever about "freeing ranges" initially preserved for > > a now-exhausted tape. That kind of thing. > > Attached is a revision that significantly overhauls the memory patch, > with several smaller changes. I was thinking about running some benchmarks on this patch, but the thread is pretty huge so I want to make sure I'm not missing something and this is indeed the most recent version. Is that the case? regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers