powerauth-server icon indicating copy to clipboard operation
powerauth-server copied to clipboard

Consider increasing the sequence allocationSize

Open banterCZ opened this issue 1 year ago • 1 comments

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

banterCZ avatar Apr 13 '23 12:04 banterCZ

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.

petrdvorak avatar Apr 18 '23 18:04 petrdvorak