public inbox for [email protected]  

help / color / mirror / Atom feed
From: [email protected]
To: [email protected]
Subject: Re: Index not used
Date: Sun, 19 Jun 2016 11:59:26 +0200
Message-ID: <trinity-d77fd0af-d639-4976-91e2-2091df205856-1466330366743@3capp-gmx-bs09> (raw)
In-Reply-To: <CAKFQuwYCa_JYLjY9htZhcGLq_XYiF8ropdX+Y=F=8xg+7ZRgNg@mail.gmail.com>
References: <trinity-5d1ea92f-3085-43a8-917c-d93b522487c2-1466063926243@3capp-gmx-bs63>
	<[email protected]>
	<CAKFQuwYCa_JYLjY9htZhcGLq_XYiF8ropdX+Y=F=8xg+7ZRgNg@mail.gmail.com>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">&gt; &#8203;Or, better, persuade the app to label the value &quot;</div>

<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">&#8203;</div>

<div>public.push_guid
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">&#8203;&quot; since that is the column&#39;s type&#8203;...a type you haven&#39;t defined for us.&nbsp; If you get to add explicit casts this should be easy...but I&#39;m not familiar with the framework you are using.</div>

<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">&nbsp;</div>

<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">&nbsp;</div>

<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">push_guid was a CHARACTER(36) column. I ended up converting it to CHARACTER VARYING(36).</div>

<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">Index is now being used and performance is as expected.</div>

<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">&nbsp;</div>

<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">Thanks a lot</div>

<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">Meike</div>
</div></div></body></html>





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: [email protected]
  Cc: [email protected]
  Subject: Re: Index not used
  In-Reply-To: <trinity-d77fd0af-d639-4976-91e2-2091df205856-1466330366743@3capp-gmx-bs09>

* 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