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 1ihHIM-0004fx-NK for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Dec 2019 18:10:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ihHIL-0004N7-AM for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Dec 2019 18:10:05 +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 1ihHIL-0004N0-1x for pgsql-bugs@lists.postgresql.org; Tue, 17 Dec 2019 18:10:05 +0000 Received: from mail-wr1-x441.google.com ([2a00:1450:4864:20::441]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ihHII-0004SH-97 for pgsql-bugs@lists.postgresql.org; Tue, 17 Dec 2019 18:10:04 +0000 Received: by mail-wr1-x441.google.com with SMTP id g17so12353651wro.2 for ; Tue, 17 Dec 2019 10:10:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=G1c9rCal0jQ0FkCw7Z+liMz6EljalHp1Ha501LtYGUk=; b=blajADqlGOf7tHRLxTdnks/FxYnON76BWy4gdtmzo83MVVMwvFSauHzYfLtvgTje32 /nTQ5KJ1ZiUdXpgmspKz+0+k2MCcnlSGx2/l28HANE/1PeiBfSPfI4EM7SYSKbU0KSJ2 sEsBOL8BMT5pFc0RlhU6bh8BMVT658Utnmqy5pBQcb9wH9X/12b5teSxUmtQi7d9RCVK itkjLCewU1HEO01IWkA1w49SM3j3+yeh8xFThzKom1GGkh1ycc9lRiM8oebRUNItPG9S 2g79v45XJwmgw0JKWbioFgH5CVaZVkXNRnWBYtCE8K1mDvF00YTM35e6z4+2hM6sJ5MT 5e/w== 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; bh=G1c9rCal0jQ0FkCw7Z+liMz6EljalHp1Ha501LtYGUk=; b=jpRtl73NThMjKctglsWARkvYxRlDXEjK2l6TuUAgBCMR3BcRurapCk5zJKwkXX/Em4 zZwHnCD9J0eJFXSTGehxv+NCgiWc0WyMXZups5CiyAAzm7lSRmrBv+AHBBBgUBqzqxwN BdwxUOVHD8dEbonBqqw+I2OXDo7dC505Zf3fbF01e/xGhudR6jpwjh9CnNlSDqb8G90z xvklLiTqOjVXx/ukcyyjqo5Uat9mtNkYNsfTD5EM4MyGzTJZnbBFRX/NjJbVf0hD8uGX +ec+Annp4jEDwLS/KldWWfenmEp3IInkM70ksmbzLucnOa0HBLwESnWKYj9epYECWd7d I95A== X-Gm-Message-State: APjAAAXdWdMM7GOV/XwTceODvvj6++oQJ8D7CuG6ypigcCJQBkYk3WcY +wYA8U8oOG6ULMZr0ixe/XX5vw== X-Google-Smtp-Source: APXvYqzcDmEocQiPIkxUqz6fbGF7DxsiI62Hnq7G1H3hImpgzGmytwwPJvYCwUa1QZkWVpAXiZuy4A== X-Received: by 2002:a5d:6350:: with SMTP id b16mr39169275wrw.132.1576606201061; Tue, 17 Dec 2019 10:10:01 -0800 (PST) Received: from localhost (static-84-42-175-93.net.upcbroadband.cz. [84.42.175.93]) by smtp.gmail.com with ESMTPSA id v8sm25994765wrw.2.2019.12.17.10.09.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 17 Dec 2019 10:09:59 -0800 (PST) Date: Tue, 17 Dec 2019 19:09:57 +0100 From: Tomas Vondra To: Roman Cervenak Cc: Tom Lane , pgsql-bugs@lists.postgresql.org Subject: Re: Memory leak (possibly connected to postgis) leading to server crash Message-ID: <20191217180957.akh7vyex5guxqs7r@development> References: <20191206110154.v7yshqsn32zyxx4q@development> <20191206124119.qe2xaffcbkcbmve3@development> <18069.1576082949@sss.pgh.pa.us> <20191213132036.3m27dlquaxoorkja@development> <20191217125035.wdplskovliz7d5lh@development> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, Dec 17, 2019 at 02:20:41PM +0100, Roman Cervenak wrote: >.NET core is cross platform, you can run it under windows or linux, just >install .net core runtime. That's possible, but I have zero experience with .net core, and unfortunately I have no system with it installed. I've tried running it under mono I just installed, but quickly ran into issue that I don't know how to solve. I'm willing to spend time investigating the issue, but this seems a bit too much ... >I did not try to run loop with fixed params, I tried to mimic my production >workload (which is not random of course, but highly variable by location). >You can certainly try. > Can you capture a couple of queries, and share those? I'll run that under valgrind and see if that produces something interesting. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services