pgMustard v2 released

--0000000000001e494f0595a512e4
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hello all!

We're pleased to announce version 2 of pgMustard, a tool that gives
performance advice from query plans!

Improvements since v1:

   -

   Tips are far more selectively shown, based on their time-saving potentia=
l
   -

   More types of problem can be identified, including table bloat, index
   inefficiency, and lossy bitmap scans
   -

   Streamlined the UI to make it quicker and easier to diagnose issues
   -

   Lots of smaller fixes and improvements


Requirements:

   -

   JSON format query plans
   -

   PostgreSQL 9.6 and newer
   -

   English language only
   -

   Web application, no installation or database access required
   -

   GitHub or Google account, for authentication


It is commercial software and has a free trial: https://www.pgmustard.com/

If you have any slow queries to speed up, we=E2=80=99d love to hear how you=
 get on.

Cheers,

Michael and Dave

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

<div dir=3D"ltr"><p id=3D"gmail-docs-internal-guid-33dba489-7fff-c323-471c-=
3d9bec89cd71" style=3D"line-height:1.38;margin-top:0pt;margin-bottom:0pt" d=
ir=3D"ltr"><span style=3D"font-size:11pt;font-family:Arial;color:rgb(0,0,0)=
;background-color:transparent;font-weight:400;font-style:normal;font-varian=
t:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"=
>Hello all!</span></p><br><p style=3D"line-height:1.38;margin-top:0pt;margi=
n-bottom:0pt" dir=3D"ltr"><span style=3D"font-size:11pt;font-family:Arial;c=
olor:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:nor=
mal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-=
space:pre-wrap">We&#39;re pleased to announce version 2 of pgMustard, a too=
l that gives performance advice from query plans!</span></p><br><p style=3D=
"line-height:1.38;margin-top:0pt;margin-bottom:0pt" dir=3D"ltr"><span style=
=3D"font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:tran=
sparent;font-weight:400;font-style:normal;font-variant:normal;text-decorati=
on:none;vertical-align:baseline;white-space:pre-wrap">Improvements since v1=
:</span></p><ul style=3D"margin-top:0px;margin-bottom:0px"><li style=3D"lis=
t-style-type:disc;font-size:11pt;font-family:Arial;color:rgb(0,0,0);backgro=
und-color:transparent;font-weight:400;font-style:normal;font-variant:normal=
;text-decoration:none;vertical-align:baseline;white-space:pre" dir=3D"ltr">=
<p style=3D"line-height:1.38;margin-top:0pt;margin-bottom:0pt" dir=3D"ltr">=
<span style=3D"font-size:11pt;font-family:Arial;color:rgb(0,0,0);background=
-color:transparent;font-weight:400;font-style:normal;font-variant:normal;te=
xt-decoration:none;vertical-align:baseline;white-space:pre-wrap">Tips are f=
ar more selectively shown, based on their time-saving potential</span></p><=
/li><li style=3D"list-style-type:disc;font-size:11pt;font-family:Arial;colo=
r:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal=
;font-variant:normal;text-decoration:none;vertical-align:baseline;white-spa=
ce:pre" dir=3D"ltr"><p style=3D"line-height:1.38;margin-top:0pt;margin-bott=
om:0pt" dir=3D"ltr"><span style=3D"font-size:11pt;font-family:Arial;color:r=
gb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;fo=
nt-variant:normal;text-decoration:none;vertical-align:baseline;white-space:=
pre-wrap">More types of problem can be identified, including table bloat, i=
ndex inefficiency, and lossy bitmap scans</span></p></li><li style=3D"list-=
style-type:disc;font-size:11pt;font-family:Arial;color:rgb(0,0,0);backgroun=
d-color:transparent;font-weight:400;font-style:normal;font-variant:normal;t=
ext-decoration:none;vertical-align:baseline;white-space:pre" dir=3D"ltr"><p=
 style=3D"line-height:1.38;margin-top:0pt;margin-bottom:0pt" dir=3D"ltr"><s=
pan style=3D"font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-c=
olor:transparent;font-weight:400;font-style:normal;font-variant:normal;text=
-decoration:none;vertical-align:baseline;white-space:pre-wrap">Streamlined =
the UI to make it quicker and easier to diagnose issues=C2=A0</span></p></l=
i><li style=3D"list-style-type:disc;font-size:11pt;font-family:Arial;color:=
rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;f=
ont-variant:normal;text-decoration:none;vertical-align:baseline;white-space=
:pre" dir=3D"ltr"><p style=3D"line-height:1.38;margin-top:0pt;margin-bottom=
:0pt" dir=3D"ltr"><span style=3D"font-size:11pt;font-family:Arial;color:rgb=
(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font=
-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pr=
e-wrap">Lots of smaller fixes and improvements</span></p></li></ul><br><p s=
tyle=3D"line-height:1.38;margin-top:0pt;margin-bottom:0pt" dir=3D"ltr"><spa=
n style=3D"font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-col=
or:transparent;font-weight:400;font-style:normal;font-variant:normal;text-d=
ecoration:none;vertical-align:baseline;white-space:pre-wrap">Requirements:<=
/span></p><ul style=3D"margin-top:0px;margin-bottom:0px"><li style=3D"list-=
style-type:disc;font-size:11pt;font-family:Arial;color:rgb(0,0,0);backgroun=
d-color:transparent;font-weight:400;font-style:normal;font-variant:normal;t=
ext-decoration:none;vertical-align:baseline;white-space:pre" dir=3D"ltr"><p=
 style=3D"line-height:1.38;margin-top:0pt;margin-bottom:0pt" dir=3D"ltr"><s=
pan style=3D"font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-c=
olor:transparent;font-weight:400;font-style:normal;font-variant:normal;text=
-decoration:none;vertical-align:baseline;white-space:pre-wrap">JSON format =
query plans</span></p></li><li style=3D"list-style-type:disc;font-size:11pt=
;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weigh=
t:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-a=
lign:baseline;white-space:pre" dir=3D"ltr"><p style=3D"line-height:1.38;mar=
gin-top:0pt;margin-bottom:0pt" dir=3D"ltr"><span style=3D"font-size:11pt;fo=
nt-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:4=
00;font-style:normal;font-variant:normal;text-decoration:none;vertical-alig=
n:baseline;white-space:pre-wrap">PostgreSQL 9.6 and newer</span></p></li><l=
i style=3D"list-style-type:disc;font-size:11pt;font-family:Arial;color:rgb(=
0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-=
variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre=
" dir=3D"ltr"><p style=3D"line-height:1.38;margin-top:0pt;margin-bottom:0pt=
" dir=3D"ltr"><span style=3D"font-size:11pt;font-family:Arial;color:rgb(0,0=
,0);background-color:transparent;font-weight:400;font-style:normal;font-var=
iant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wr=
ap">English language only</span></p></li><li style=3D"list-style-type:disc;=
font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transpar=
ent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:n=
one;vertical-align:baseline;white-space:pre" dir=3D"ltr"><p style=3D"line-h=
eight:1.38;margin-top:0pt;margin-bottom:0pt" dir=3D"ltr"><span style=3D"fon=
t-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent=
;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none=
;vertical-align:baseline;white-space:pre-wrap">Web application, no installa=
tion or database access required</span></p></li><li style=3D"list-style-typ=
e:disc;font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:t=
ransparent;font-weight:400;font-style:normal;font-variant:normal;text-decor=
ation:none;vertical-align:baseline;white-space:pre" dir=3D"ltr"><p style=3D=
"line-height:1.38;margin-top:0pt;margin-bottom:0pt" dir=3D"ltr"><span style=
=3D"font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:tran=
sparent;font-weight:400;font-style:normal;font-variant:normal;text-decorati=
on:none;vertical-align:baseline;white-space:pre-wrap">GitHub or Google acco=
unt, for authentication</span></p></li></ul><br><p style=3D"line-height:1.3=
8;margin-top:0pt;margin-bottom:0pt" dir=3D"ltr"><span style=3D"font-size:11=
pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-wei=
ght:400;font-style:normal;font-variant:normal;text-decoration:none;vertical=
-align:baseline;white-space:pre-wrap">It is commercial software and has a f=
ree trial: </span><a style=3D"text-decoration:none" href=3D"https://www.pgm=
ustard.com/"><span style=3D"font-size:11pt;font-family:Arial;color:rgb(17,8=
5,204);background-color:transparent;font-weight:400;font-style:normal;font-=
variant:normal;text-decoration:underline;vertical-align:baseline;white-spac=
e:pre-wrap">https://www.pgmustard.com/</span></a></p><br><p style=3D"line-h=
eight:1.38;margin-top:0pt;margin-bottom:0pt" dir=3D"ltr"><span style=3D"fon=
t-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent=
;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none=
;vertical-align:baseline;white-space:pre-wrap">If you have any slow queries=
 to speed up, we=E2=80=99d love to hear how you get on.</span></p><br><p st=
yle=3D"line-height:1.38;margin-top:0pt;margin-bottom:0pt" dir=3D"ltr"><span=
 style=3D"font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-colo=
r:transparent;font-weight:400;font-style:normal;font-variant:normal;text-de=
coration:none;vertical-align:baseline;white-space:pre-wrap">Cheers,</span><=
/p><p style=3D"line-height:1.38;margin-top:0pt;margin-bottom:0pt" dir=3D"lt=
r"><span style=3D"font-size:11pt;font-family:Arial;color:rgb(0,0,0);backgro=
und-color:transparent;font-weight:400;font-style:normal;font-variant:normal=
;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">Michael=
 and Dave</span></p></div>

--0000000000001e494f0595a512e4--