Re: Index not used

From: meike(dot)talbach(at)women-at-work(dot)org
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index not used
Date: 2016-06-19 09:59:26
Message-ID: trinity-d77fd0af-d639-4976-91e2-2091df205856-1466330366743@3capp-gmx-bs09
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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>

Attachment Content-Type Size
unknown_filename text/html 1.6 KB

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2016-06-19 16:55:16 Re: Savepoint and Releasepoint in Logs
Previous Message Tom Lane 2016-06-17 15:22:08 Re: 9.6 query slower than 9.5.3