herzhang ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=62cbeb9... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiMzAwMjg4... ) / Improvement ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiMzA... ) HSEARCH-4678 ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiMzA... ) select nextval ('hsearch_outbox_event_generator ') performs very slowly on CockroachDB，why not use UUID ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiMzA... ) Issue Type: Improvement Assignee: Unassigned Created: 22/Aug/2022 19:28 PM Environment: CockroachDB 22.1.5 ; hibernate-search-mapper-orm-coordination-outbox-polling: 6.2.0.Alpha1 ; springboot 2.7.2 Priority: Major Reporter: herzhang ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=62cbeb9... ) select nextval ('HSEARCH_OUTBOX_EVENT_GENERATOR') }}is very poor performance for {{CockroachDB ! Can change hsearch_outbox_event Table`s ID from long to {{ UUID type?}} like this: @Id@GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "id") private UUID id; ( https://hibernate.atlassian.net/browse/HSEARCH-4678#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4678#add-comment?atlOrigin... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100205- sha1:4a5192e )