Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M47431=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1eGFho-00012y-Ls
	for pgsql-admin@arkaria.postgresql.org; Sun, 19 Nov 2017 02:51:37 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M47431=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1eGFhn-0006Q1-3h
	for pgsql-admin@arkaria.postgresql.org; Sun, 19 Nov 2017 02:51:35 +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 <dba@propaas.com>)
	id 1eGFfr-00035J-KZ
	for pgsql-admin@postgresql.org; Sun, 19 Nov 2017 02:49:35 +0000
Received: from mail-io0-x22c.google.com ([2607:f8b0:4001:c06::22c])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <dba@propaas.com>)
	id 1eGFfn-00062J-Nh
	for pgsql-admin@postgresql.org; Sun, 19 Nov 2017 02:49:34 +0000
Received: by mail-io0-x22c.google.com with SMTP id t11so12492352iof.13
        for <pgsql-admin@postgresql.org>;
 Sat, 18 Nov 2017 18:49:30 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=propaas-com.20150623.gappssmtp.com; s=20150623;
        h=to:from:subject:message-id:date:user-agent:mime-version
         :content-transfer-encoding:content-language;
        bh=Fih+WI11p3f5rHxlnX3BFOZY6UtnKy91DqZjrq1zU7M=;
        b=Lz9xoTpEUKPTuhbv36mNhEoLQR8M4Gi8n2GG4MadiFjJsOcsCw1PUTUHKfcDep1EL5
         n2zP1dfKS+a4qc0UBg5j1whFwEiPRIuwkYIxipoa62kxKQimrw1q8IXHO0nVSqzGzaLE
         cTBDtqoV9b5POHrDfpdtQdTAXgSMwLLcl8nufYKbWIVfmQso9lWaxI8Etd4YxGWqac8x
         mBZJdRnzbBCTHEfHx6MDYEy+mwbGbik3uVhnb19dwDsa+o9HMk1TIriwkSDOrxCK5UmO
         wqYMdtFlj3KSK1qmlh0/WHOHIVGsoJF/wiCAe6ynuZpVfyHMX7Y2dt+U6rbUYYdeDzlF
         bhHQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:to:from:subject:message-id:date:user-agent
         :mime-version:content-transfer-encoding:content-language;
        bh=Fih+WI11p3f5rHxlnX3BFOZY6UtnKy91DqZjrq1zU7M=;
        b=cVSu+9+vGeFSdxMNrbGm4TYOs0c1Kdqwc+Yz+IjtD2i1mfh28lyeKGVeGJQwBl1Wnb
         0+5zlm6/kxkSR9tZwuS0aqNp1zBfJ+rZEZRDg3TGqB9CXejT4/Bho/SEhK+NPzNl6NT+
         jby1z+BS9xDZMcSnGkRbSpa5pEIwSAZ45D89SUmOArw+xJ//07B/iC44SooKcVvz98bz
         qDxB/+ljZn8v83RBMdoQzNyCVO+acSt+WELpHswarsaNjcaGRzxZaqsPGWBpRs04z9N/
         55hyhnjZ1l4bu9eax0MhAf8i7ljonOqipc2iKvNCOgaV6k9oeXF/bNVUz0EVZfDJoQef
         XcnA==
X-Gm-Message-State: AJaThX5/RLCxWuIQNeaAGk4/MHHi61i3V47q52vZk4ZovFGAfPKKGaQ3
	VJ3XTtJ4EMv93TYsCNFRIa+Ctw==
X-Google-Smtp-Source: 
 AGs4zMaDvjHFvalZUiEv9IZrEzrXoi3PGHjZuC4+8kyLLUDP50bnH4TJbEbZDgve7u3vVXs6NdlVJw==
X-Received: by 10.107.62.10 with SMTP id l10mr8503106ioa.178.1511059768291;
        Sat, 18 Nov 2017 18:49:28 -0800 (PST)
Received: from [10.1.0.106] (50-243-150-81-static.hfc.comcastbusiness.net.
 [50.243.150.81])
        by smtp.gmail.com with ESMTPSA id
 r65sm3734035ith.1.2017.11.18.18.49.27
        (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
        Sat, 18 Nov 2017 18:49:27 -0800 (PST)
To: pgsql-admin <pgsql-admin@postgresql.org>
From: PropAAS DBA <dba@propaas.com>
Subject: Partitioning & ORM apps
Message-ID: <46231efa-8a34-17bf-81d2-3c68e05d3565@propaas.com>
Date: Sat, 18 Nov 2017 19:49:26 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.4.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi All;


we want to deploy partitioning for historical data archiving & 
performance however the app uses an ORM and depends on the number of 
rows affected from the inserts, updates & deletes which of course always 
come back as zero rows for the partition base or master table.

We talked about letting daily data go into the base table and 'moving' 
it nightly but this could still lead to an update/delete for rown in the 
child tables, thus the same issue remains.


Anyone know of a workaround? Maybe it can be done with 
insert/update/delete trigger functions?


Thanks in advance




-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin