Drone postgres indexes

Drone Support
1

Just realized after poking around that Drone isn’t creating any indexes within the database when its backed by postgres. Is that intentional? Do you ever see issues with large drone databases? I would think that ends up getting pretty slow as table sizes increase?

If you’re looking for someone to do some optimization in that area, I would love to do it. Just felt odd and wanted to reach out first.

2

Have you taken a look at the ddl file? Drone creates a bunch of indexes for postgres: https://github.com/drone/drone/blob/master/store/datastore/ddl/postgres/ddl_gen.go

3

Ahhh, there they are. I’m not sure why they weren’t showing up before. Thanks. A facepalm moment apparently :slight_smile: