Add documentation of `pg_hint_plan` enablement

[tstirrat15]

We have index hints for postgres in place, but they require pg_hint_plan to be enabled. We should make sure this is written down somewhere.