Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://mastodon.acm.org/users/smarr/statuses/112072285009357611">Stefan Marr (smarr@mastodon.acm.org)'s status on Monday, 11-Mar-2024 23:48:47 JST</a><a href="https://mastodon.acm.org/@smarr" title="smarr@mastodon.acm.org"><img src="https://gnusocial.jp/avatar/248531-48-20240311144845.webp" width="48" height="48" alt="Stefan Marr" style="position: absolute; left: 0; top: 0;">Stefan Marr</a><div><a href="https://mastodon.acm.org/@freemo/112071647470613264" rel="in-reply-to">in reply to</a><ul><li></ul></div></section><article><p><a href="https://mastodon.acm.org/@freemo">@freemo</a> hm, I would assume there's an index on the primary key:<br><a href="https://github.com/smarr/ReBenchDB/blob/2414426bb93a9c170004a97207593217f02f622b/src/backend/db/db.sql#L152" rel="nofollow noreferrer">https://github.com/smarr/ReBenchDB/blob/2414426bb93a9c170004a97207593217f02f622b/src/backend/db/db.sql#L152</a></p><p>Would you have a suggestion what other indexes might be helpful here? Thanks.</p></article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/2813562#notice-5581702">In conversation</a><time datetime="2024-03-11T23:48:47+09:00" title="Monday, 11-Mar-2024 23:48:47 JST">about a year ago</time> <span>from <span><a href="https://mastodon.acm.org/@smarr/112072285009357611" rel="external" title="Sent from mastodon.acm.org via ActivityPub">mastodon.acm.org</a></span></span><a href="https://mastodon.acm.org/@smarr/112072285009357611">permalink</a><h4>Attachments</h4><ol><li><article><header><div>No result found on File_thumbnail lookup.</div><h5><a href="https://github.com/smarr/ReBenchDB/blob/2414426bb93a9c170004a97207593217f02f622b/src/backend/db/db.sql#L152Would">https://github.com/smarr/ReBenchDB/blob/2414426bb93a9c170004a97207593217f02f622b/src/backend/db/db.sql</a></h5><div></div></header><div></div><footer></footer></article></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
Stefan Marr (smarr@mastodon.acm.org)'s status on Monday, 11-Mar-2024 23:48:47 JSTStefan Marr
in reply to
- Jeffrey Phillips Freeman
@freemo hm, I would assume there's an index on the primary key:
https://github.com/smarr/ReBenchDB/blob/2414426bb93a9c170004a97207593217f02f622b/src/backend/db/db.sql#L152
Would you have a suggestion what other indexes might be helpful here? Thanks.
In conversationabout a year ago from mastodon.acm.orgpermalink
Attachments
1. No result found on File_thumbnail lookup.
  https://github.com/smarr/ReBenchDB/blob/2414426bb93a9c170004a97207593217f02f622b/src/backend/db/db.sql

Public

Embed Notice

HTML Code

Corresponding Notice