Performance: Pre- vs. post-import statements to disable/enable periodic refreshes

[amotl]

@michabbb added an aftermath question if there is the possibility in ingestr to invoke pre- vs. post-import statements, for example to disable indexing before a bulk import, and re-enabling it afterwards.

Personally, I guess this could be a feature of the dlt adapters instead of ingestr itself? Could you provide any form of guidance about this topic, @karakanb?

@turtleDev replied:

This might be relevant here: https://dlthub.com/docs/dlt-ecosystem/destinations/destination

From a design perspective, it would be nicer if cratedb could handle index supression within a transaction on its own. That way clients could transparently perform bulk insert without having to write own hooks.