powerauth-server
powerauth-server copied to clipboard
Consider increasing the sequence allocationSize
Look into increasing the allocationSize
for generated identifiers using DB sequences.
Due to upgrading to Hibernate 6 set to
@Id
@SequenceGenerator(name = "pa_master_keypair", sequenceName = "pa_master_keypair_seq", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.AUTO, generator = "pa_master_keypair")
@Column(name = "id")
private Long id;
This is compatible with the current sequences but could be improved to take advantage of hi-lo algorithms.
Follow-up to #869
This has a very low priority. We keep one master keypair per application. This means that most customers only have one record in the table. Also - and I know this is a very old issue - we might actually adjust the PAS model to promote keypair rotation with a version upgrade, see: https://github.com/wultra/powerauth-server/issues/691.