Doug Roeper

Hi @aevyrie, is this PR something you'd consider accepting?

No problem. I'm using this data in tandem with bevy_mod_picking. I was looking at the other backends and saw that rapier exposes the data using a struct called [feature id](https://docs.rs/parry3d/latest/src/parry3d/query/ray/ray.rs.html#82)....

I believe this is actually a symptom of incorrectly ordering the primary keys. This table has a compound primary key: ``` CREATE TABLE document_snippets( source_document_id text, id text, PRIMARY KEY...

The primary keys are sorted [here](https://github.com/elastic/connectors/blob/25cdaab6a227b6b89fab123ded6b61eceab287a7/connectors/sources/postgresql.py#L524), making the order inefficient.

Yes, removing the sort allows the connector to start syncing. For reference, here is a comparison of the costs for misordering the keys: ``` EXPLAIN SELECT * FROM document_snippets ORDER...