Date: Wed, 16 Mar 2016 02:34:52 +0100 (CET)
From: Andreas Kretschmer <andreas@a-kretschmer.de>
Reply-To: Andreas Kretschmer <andreas@a-kretschmer.de>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: ivo liondov <ivo.liondov@gmail.com>,
	"pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Message-ID: 
 <62238924.9201.1458092092795.JavaMail.open-xchange@oxweb01.ims-firmen.de>
In-Reply-To: 
 <CAKFQuwZ_E08T37A_eTtky2pQ95Ruc65MyywLp-yKjhVPUdgEMw@mail.gmail.com>
References: 
 <CAJ2MONRiYczFWzL5_6bh3ZV_pcnN2zzg2Q+GDW1r_VXS=-SRtw@mail.gmail.com>
 <503958962.9182.1458090747344.JavaMail.open-xchange@oxweb01.ims-firmen.de>
 <CAKFQuwZ_E08T37A_eTtky2pQ95Ruc65MyywLp-yKjhVPUdgEMw@mail.gmail.com>
Subject: Re: delete taking long time
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Importance: Medium
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org


> 
> Given the lack of indexes on the one table that is shown I suspect this is
> the most likely cause (FK + indexes)
> 

right, there should be an index on ts. If it is a 9.5 AND the rows are ordered
on ts a BRIN-index would be fine.
If not - a normal index. How many rows contains the table?

-- 
Andreas Kretschmer
http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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