Guten Tag Tony Shelver, am Dienstag, 6. Oktober 2020 um 16:33 schrieben Sie: > Each vehicle reports position to the database at least every 30 seconds > when moving, along with any other data as it happens. So it's quite a bit. > H2 seemed to handle it fine for a limited number of vehicles, but we moved > it to PG once we moved to production. But where does Postgres run in your setup? :-) On the tracked vehicle itself with limited resources most likely or do you simply send things over network to some cloud/server/...? Your first paragraph reads like the former, but the second like the latter. :-) If it's on the vehicle, I would be interested to somewhat know which hardware you use, to compare what I have in mind. Thanks! Mit freundlichen Grüßen, Thorsten Schöning -- Thorsten Schöning E-Mail: Thorsten.Schoening@xxxxxxxxxx AM-SoFT IT-Systeme http://www.AM-SoFT.de/ Telefon...........05151- 9468- 55 Fax...............05151- 9468- 88 Mobil..............0178-8 9468- 04 AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow