Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dXUwM-0002Iv-C4 for pgsql-performance@arkaria.postgresql.org; Tue, 18 Jul 2017 16:01:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dXUwL-000593-0n for pgsql-performance@arkaria.postgresql.org; Tue, 18 Jul 2017 16:01:37 +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_2) (envelope-from ) id 1dXUwK-00057n-FF for pgsql-performance@postgresql.org; Tue, 18 Jul 2017 16:01:36 +0000 Received: from mail-it0-x236.google.com ([2607:f8b0:4001:c0b::236]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dXUwG-0000os-TR for pgsql-performance@postgresql.org; Tue, 18 Jul 2017 16:01:36 +0000 Received: by mail-it0-x236.google.com with SMTP id h199so11548307ith.0 for ; Tue, 18 Jul 2017 09:01:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=mMPdH2eYl9qpfEo+qaXXxfSQquOCbEx8nUwpv8L08F4=; b=fA5534iE5g9sdcHmbzuX3eVWSyzXusUIlRmKGzp1D+qzrwc8sBD1D0B0PUpnj50L/k M6Bof+zy+FtN6n6aadiCaBDVTVMaWE1iznJNRd6ExxuK7XUa3YE+8/dIKYvul9//XZAa 8sctzU/lJAUXkMTA0beeAEYMjmj8dp9bz2NWLPE1SvyxddGm3C17wAP+9xhc2tl0DSoY KquCPlc0x6N7uFO6Y67FuGxnWlG9B9sRlYvcuZAFmGUbwZPt1VAbfPgJYcnqUNY6Xn2M fJ8jG1QDA1+TxPIOSH/VBHbnZ0MuCHz1Z+OgjuzUOqOYqrIITA+hv2+06qlArF5e2QiK drbQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=mMPdH2eYl9qpfEo+qaXXxfSQquOCbEx8nUwpv8L08F4=; b=lz1ZLAqfw8suXa63FTt1lf9+xrwUrse0noKKFqen7kvDfP3Pci1eoWWUtc0RRxlLfw x6VLCtZe5cE46f8Ogz8qmCNMWyKQf2Yj9DM48h2/kJw9xwAtbtaEXlQZuR62Sn6XK5SM QkFval7jWczr+lre9JSHLxbbu64jKZt+IvKi56bIIq4kqNPAqrDFlO0V6ie9dfQfQEUM Asi2n590gYyD5aONKIqKGPTrQLGL8gZcwivIEBxAxWzq1TACaIrkn81ruPIdC9c8x/0p nzWlaQaU/6BzfFJWIqaOf//ViFoZ/dyqvf6VMZ/xUAzBnkpoNvcoZgKbusnc3qr1Un31 ZLaA== X-Gm-Message-State: AIVw111ChJtn1pTNG3MiPegXNHuNe8EPCSMmUsqmTtfYzE0hZDJSnwrk M8nXK/P2t58YQ6wusgnu/1G6hv+lSg== X-Received: by 10.36.61.66 with SMTP id n63mr3256523itn.37.1500393691125; Tue, 18 Jul 2017 09:01:31 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.40.136 with HTTP; Tue, 18 Jul 2017 09:01:29 -0700 (PDT) In-Reply-To: References: From: Claudio Freire Date: Tue, 18 Jul 2017 13:01:29 -0300 Message-ID: Subject: Re: Very poor read performance, query independent To: Charles Nadeau Cc: Igor Neyman , Jeff Janes , "pgsql-performance@postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On Tue, Jul 18, 2017 at 6:20 AM, Charles Nadeau wrote: > Claudio, > > At one moment > during the query, there is a write storm to the swap drive (a bit like this > case: > https://www.postgresql.org/message-id/AANLkTi%3Diw4fC2RgTxhw0aGpyXANhOT%3DXBnjLU1_v6PdA%40mail.gmail.com). > I can hardly explain it as there is plenty of memory on this server. That sounds a lot like NUMA zone_reclaim issues: https://www.postgresql.org/message-id/500616CB.3070408@2ndQuadrant.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance