Question regarding adding additional indexes

[dtmeadows]

Hey there,

First off, thanks for pg-boss! Our team has really enjoyed getting it up and running.

One issue we ran into is that we're running a custom query to find jobs in a certain state. I think in an ideal world, we'd modify this query to support the indexes that PGBoss has added out of the gate, but for our own internal reasons we need to query things in a certain pattern.

Besides the normal performance issues of adding an extra index, are there any concerns with adding an additional index to pg-boss tables? In our case we'd be adding an index on state to the jobs table.

Thanks again!

[timgit]

As long as it's not a unique index, pg-boss shouldn't be affected by new indexes, other than the typical performance tradeoffs.