agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Andreas Kretschmer <andreas@a-kretschmer.de>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: ivo liondov <ivo.liondov@gmail.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: delete taking long time
Date: Wed, 16 Mar 2016 02:34:52 +0100 (CET)
Message-ID: <62238924.9201.1458092092795.JavaMail.open-xchange@oxweb01.ims-firmen.de> (raw)
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
>
> 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
view thread (12+ messages) latest in thread
Message-ID: <62238924.9201.1458092092795.JavaMail.open-xchange@oxweb01.ims-firmen.de>
Permalink: ../62238924.9201.1458092092795.JavaMail.open-xchange@oxweb01.ims-firmen.de/
Also on: postgresql.org/message-id/62238924.9201.1458092092795.JavaMail.open-xchange@oxweb01.ims-firmen.de
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andreas@a-kretschmer.de, david.g.johnston@gmail.com, ivo.liondov@gmail.com
Subject: Re: delete taking long time
In-Reply-To: <62238924.9201.1458092092795.JavaMail.open-xchange@oxweb01.ims-firmen.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox