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;">> ​Or, better, persuade the app to label the value "</div>
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">​</div>
<div>public.push_guid
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">​" since that is the column's type​...a type you haven't defined for us. If you get to add explicit casts this should be easy...but I'm not familiar with the framework you are using.</div>
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;"> </div>
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;"> </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;"> </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 |
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 |