| From: | Thorsten Schöning <tschoening(at)am-soft(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: What's your experience with using Postgres in IoT-contexts? |
| Date: | 2020-10-07 06:28:26 |
| Message-ID: | 1933902504.20201007082826@am-soft.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)Schoening(at)AM-SoFT(dot)de
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thorsten Schöning | 2020-10-07 07:50:54 | Which is the setup with lowest resources you know Postgres is used in? |
| Previous Message | Jayaram | 2020-10-07 02:36:04 | Re: Handling time series data with PostgreSQL |