@spec delete(module(), String.t(), String.t()) :: :ok | {:error, term()}

Deletes all index entries for a post across all fields.

First reads the terms from search_post_fields so we know which partition keys to target for deletion in search_post_terms. Then deletes from both tables.

Returns :ok on success or {:error, reason} on failure.

@spec delete_field(module(), String.t(), String.t(), non_neg_integer()) ::
  :ok | {:error, term()}

Deletes all index entries for a specific field of a post.