Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gyIvR-0001d6-3k for pgsql-performance@arkaria.postgresql.org; Mon, 25 Feb 2019 16:16:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gyIvP-0003aI-Mv for pgsql-performance@arkaria.postgresql.org; Mon, 25 Feb 2019 16:16:15 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gyIvP-0003a4-Bl for pgsql-performance@lists.postgresql.org; Mon, 25 Feb 2019 16:16:15 +0000 Received: from mail-it1-x134.google.com ([2607:f8b0:4864:20::134]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gyIvL-0000fE-7s for pgsql-performance@postgresql.org; Mon, 25 Feb 2019 16:16:14 +0000 Received: by mail-it1-x134.google.com with SMTP id v83so3015758itf.1 for ; Mon, 25 Feb 2019 08:16:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=Cq8IL5wyYXJEfM5WTJVqp74J9jPC7JAARsYJWb68w2g=; b=nbSvQJxhtieMfgWJ6Y+7KIFFu5crE25qj6tLJw4OnErbQ9PAQA4arFR97blz5EYhEb J8WEayAZIvlOtF/LxRSLf4YkV2iq7gqAxA0fszgWWTvHFxS7UsfrFkvuJWb4XiFjOzM2 Cf+igMdd2xQGxkL0t6JoV1xG2cERY+/DoNcdyvevxhHR7ji0lAIob0sxJlCPl+u5pE3G /c6oFanoANZ1I7OpcOnkfMKPOrbxxPzh6p3LMM11IxkfixyXoygyTb2x+wKjMaXiFwmi 9oMypD1g3IyCyM+e7XQvk2r8Dnv/s28NdQWPGIaJoKFfJzjKA3UTQq7QiA4U5j8+OIKb Nd+Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=Cq8IL5wyYXJEfM5WTJVqp74J9jPC7JAARsYJWb68w2g=; b=d2ch71B3ih8LP44vGay5z4KYGgqsyzZbQTbQ3ocbsDjL4Z9nm4JunqgNpuf/x6SB5H Jxg/2J0FR7Yqo9h31FIpelzIoZbmMdjgQzWcbLTvQLlNEb5nBj1LxA4xV3xwj4L2LTdi J2/gL49LFS6aktQVTr37/YwHqTfB7A1F1da9mTcuzSqcVhmCLaCjlnJrb/TQfK871zxd +D+2iVJ1JrhIRnFvWeoMYPIWbxNxopkzVaun35nEsEDzw+wDuhGCFFoRnSpT4SPOgKbZ dTjlj8ezsyaul0/LBoMLpzJPlHR+/U+HK1AveFsIlZkLpcEIytA5wSsR+UhHLdd6+4vX xn9Q== X-Gm-Message-State: AHQUAuY4tPu6sERcHzPXsKc76da0JZShQIjBdG5fMjXWRiD0xkHbAlOg 1fxeECtVj9nQi2EWgxZbq8ekbSBhr90= X-Google-Smtp-Source: AHgI3Ia+1meG2Z352oBAmpxE0W741Gyx87mAAlo3yzg3Kf1/ZleAB4z+UybTk6tf1OidG+NQHJ/KJw== X-Received: by 2002:a24:f644:: with SMTP id u65mr10938798ith.162.1551111368934; Mon, 25 Feb 2019 08:16:08 -0800 (PST) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id z10sm4022230iol.30.2019.02.25.08.16.07 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 25 Feb 2019 08:16:08 -0800 (PST) Received: by pryzbyj (Postfix, from userid 1000) id 413A7800C83; Mon, 25 Feb 2019 10:16:07 -0600 (CST) Date: Mon, 25 Feb 2019 10:16:07 -0600 From: Justin Pryzby To: Kim Cc: pgsql-performance@postgresql.org Subject: Re: Query slow for new participants Message-ID: <20190225161607.GQ28750@telsasoft.com> References: <1551091278468-0.post@n3.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1551091278468-0.post@n3.nabble.com> User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, Feb 25, 2019 at 03:41:18AM -0700, Kim wrote: > Is there any way how I can make the queries fast for new participants? This > is a big problem, because for new participants, speed is even more > important. > > Thank you for your help. Could you include information requested here ? https://wiki.postgresql.org/wiki/Slow_Query_Questions Justin