Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fuf3P-0003Zw-J4 for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 14:33:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fuf3N-00015S-9b for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 14:33:09 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fuf3M-00015L-Uu for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 14:33:09 +0000 Received: from mail-qt0-x242.google.com ([2607:f8b0:400d:c0d::242]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fuf3J-00081R-2J for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 14:33:07 +0000 Received: by mail-qt0-x242.google.com with SMTP id o15-v6so1903685qtk.6 for ; Tue, 28 Aug 2018 07:33:04 -0700 (PDT) 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:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=rejZOWSA4GRGH5CkQ0uBPeGE5XAI65jR4tGXT1jdvWU=; b=AphEmXkmBxWQEkimiIfkWOxs6kKhVByrvcoMK4gf5LUacZ7ckGFGTW7paxD3nByVSc WAG027JJZm4PfVOmP+y+hsGjKrb9i+QTjuXcaIbXAnfHbqZYSZgmqgM29rTpoBr+geX6 BqVO55lpTl46g5mKoZoEAIxlGhBefTh1WXnF5mQWZfGyt9u/WTU6mU5HADjXA3yFdViD bOaztpXxP3vT+26W1ioojG6XawfFCWbF2BySlKilfa2843osoPEYAgPOWb8NjRMhDUXc EbIPSB/tolKsLc1y3yqLGoqZR65QUcBJue/879DRgcgfl2CxDJgVaPW+GssOfQZIZQDw XSvQ== 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:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=rejZOWSA4GRGH5CkQ0uBPeGE5XAI65jR4tGXT1jdvWU=; b=VG9PuGcy4T3W+JMxRaav+h5ZEq2f1Na/EjkhSqUBSuy3h9CSHo9+rvV3W+ZuQOhITG akFsmeGS9YPX90wJYki2aRdMfh1oZxvq8kQFk9VKNJP1nbU+/ZsM6tSWtALc8D8M+DEn pEEJBaN712MRNIl18ZD7b+EZqXbgqNmJq2YL7AvtuDn4SGSDnj75wOV2+4eS67hQImjr csSADYUdc5qksvV6iODEoVFK85KhyetxHp3gwK1IlWipEt29uD3Njo+sz0SO5iJbaNWA DxjeG98467Sop98Kyp9/Jieby6jLkUDK8BIauH6PgQnuvT5lJoog3iIgSyD+JQNylMng wUwQ== X-Gm-Message-State: APzg51B/tnVw16vF88gnf7AyYI2cNqryQWgVvuwixCV7dUT+Pb3Rqmby csvMnRYOAyJu7ysb9V3UMZz/21+5mNATC69n7MUw3lA1reZV23gRHqtzV76+yVcLmuBRExk6N6R 4vXrCz75VGrEWSKbDcD1KLSCL6XX8m0X1RPBN+BEOOANBcPMuFSTM8SCkvtdGXFVMObiPmXy13V WjmqqoY91Lev4= X-Google-Smtp-Source: ANB0VdYRNaOoV+tSI9BSuIiTv4SLRBUydjS3PV8QyIaJu7B8t0+NZhUJMHNLc+cu6lV3yjwsJLNBvA== X-Received: by 2002:a0c:e292:: with SMTP id r18-v6mr1870538qvl.62.1535466783461; Tue, 28 Aug 2018 07:33:03 -0700 (PDT) Received: from alvin.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id x14-v6sm614359qkf.59.2018.08.28.07.33.02 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Tue, 28 Aug 2018 07:33:02 -0700 (PDT) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 3625A819; Tue, 28 Aug 2018 11:33:01 -0300 (-03) Date: Tue, 28 Aug 2018 11:33:01 -0300 From: Alvaro Herrera To: wambacher@posteo.de Cc: pgsql-admin@lists.postgresql.org Subject: Re: tuple concurrently updated Message-ID: <20180828143301.g5gsjo7onyys2gyg@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2018-Aug-28, wambacher@posteo.de wrote: > updates are done using a program, that is without my control: osm2pgsql. > > this program does everthing which is necessary including locking. and > it't running for years on many, many openstreetmap servers. > > because there was a crash before, it must be a data corruption problem, > not programming error. It's curious that you reply to my email and not respond to a single of the questions I posed, and instead answered questions I didn't ask. Perhaps you thought I asked them because I was bored? > > What is the definition of the table? It sounds like there's some GIS > > datatype -- Right? Are there any triggers or some other fun fact about > > this delete? What is the isolation level in effect when the delete > > runs? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services