MIME-Version: 1.0
In-Reply-To: 
 <CAJhrTGzJwsTtbbuD8G24AFgkL2ny52=Ea62k6P=LR+_pi_61qQ@mail.gmail.com>
References: 
 <CAJhrTGxffyaiu1JwhYkY3noy5ukiyREpzv5yT_5CGubVzMXmqw@mail.gmail.com>
 <CAMkU=1x2+kW2KMon7Y7wzK0b0KpxFfdN0SuPODJ6KmHbE6saeQ@mail.gmail.com>
 <CAJhrTGzJwsTtbbuD8G24AFgkL2ny52=Ea62k6P=LR+_pi_61qQ@mail.gmail.com>
From: Jeff Janes <jeff.janes@gmail.com>
Date: Fri, 30 Jun 2017 10:46:45 -0700
Message-ID: 
 <CAMkU=1wU632cTJ4cc57+ExMQxumrDSXR5rbSoL2Fk1Ymrck1zA@mail.gmail.com>
Subject: Re: 
To: Yevhenii Kurtov <yevhenii.kurtov@gmail.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Type: multipart/alternative; boundary="94eb2c12359240c4c40553310098"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--94eb2c12359240c4c40553310098
Content-Type: text/plain; charset="UTF-8"

On Thu, Jun 29, 2017 at 12:11 PM, Yevhenii Kurtov <yevhenii.kurtov@gmail.com
> wrote:

> Hi Jeff,
>
> That is just a sample data, we are going live in Jun and I don't have
> anything real so far. Right now it's 9.6 and it will be a latest stable
> available release on the date that we go live.
>


You need to use your knowledge of the application to come up with some
plausible sample data.

What happens when something succeeds?  Does it get deleted from the table,
or does it get retained but with a certain value of the status column?  If
it is retained, what happens to the priority and times_failed fields?

The performance of your queuing table will critically depend on that.

If you need to keep it once it succeeds, you should probably do that by
deleting it from the queuing table and inserting it into a history table.
It is much easier to keep performance up with that kind of design.

Cheers,

Jeff

--94eb2c12359240c4c40553310098
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote">On T=
hu, Jun 29, 2017 at 12:11 PM, Yevhenii Kurtov <span dir=3D"ltr">&lt;<a href=
=3D"mailto:yevhenii.kurtov@gmail.com" target=3D"_blank">yevhenii.kurtov@gma=
il.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"=
margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"=
ltr">Hi Jeff,<div><br></div><div>That is just a sample data, we are going l=
ive in Jun and I don&#39;t have anything real so far. Right now it&#39;s 9.=
6 and it will be a latest stable available release on the date that we go l=
ive.=C2=A0</div></div></blockquote><div><br></div><div><br></div><div>You n=
eed to use your knowledge of the application to come up with some plausible=
 sample data.</div><div><br></div><div>What happens when something succeeds=
?=C2=A0 Does it get deleted from the table, or does it get retained but wit=
h a certain value of the status column?=C2=A0 If it is retained, what happe=
ns to the priority and times_failed fields?</div><div><br></div><div>The pe=
rformance of your queuing table will critically depend on that. =C2=A0</div=
><div><br></div><div>If you need to keep it once it succeeds, you should pr=
obably do that by deleting it from the queuing table and inserting it into =
a history table.=C2=A0 It is much easier to keep performance up with that k=
ind of design.</div><div><br></div><div>Cheers,</div><div><br></div><div>Je=
ff</div></div></div></div>

--94eb2c12359240c4c40553310098--