Show HN: pg_netstat, a Postgres extension to monitor database network traffic

Re:Show HN: pg_netstat, a Postgres extension to monitor data... by londons_explore on Tuesday September 13, 2022 @10:35AM (#32824803)

Nearly all usecases for this seem to be recreating a time series database...

Postgres isn't a great TSDB - the indexes don't understand columns that will only have updates at one end, it doesn't do column compression, range queries are expensive, etc.

Perhaps it's time to just set up a time series database... Like influxDB.

[ Parent | on HN ]

Re:Show HN: pg_netstat, a Postgres extension to monitor data... by jpgvm on Tuesday September 13, 2022 @10:54AM (#32825055)

Or just use TimescaleDB which is competitive on most axes but already PG.

[ Parent | on HN ]

Re:Show HN: pg_netstat, a Postgres extension to monitor data... by LoriP on Wednesday September 14, 2022 @09:02AM (#32836561)

Thanks for the mentions (and for using TimescaleDB).

If anyone's curious about TimescaleDB, it's packaged as an extension to Postgres, optimizing for performance, storage, and analysis of time series data. Implementing columnar compression algorithms is a big part of the secret sauce that makes TimescaleDB a popular choice with Postgres and SQL developers. You can read more about that on the Timescale blog (I'm Timescale's community manager btw). https://www.timescale.com/blog/search/?query=compression

If anyone's curious, the youtube channel may be a good place to start, especially this playlist https://www.youtube.com/playlist?list=PLsceB9ac9MHTtM1XWONMR...

[ Parent | on HN ]

Re:Show HN: pg_netstat, a Postgres extension to monitor data... by _joel on Tuesday September 13, 2022 @11:20AM (#32825459)

+1 for Timescale. Used it for a few RNN projects and it's been great.

[ Parent | on HN ]

Re:Show HN: pg_netstat, a Postgres extension to monitor data... by GordonS on Tuesday September 13, 2022 @12:28PM (#32826481)

And I +1 your +1, we've been using it in prod for 2 years or so.

[ Parent | on HN ]

Re:Show HN: pg_netstat, a Postgres extension to monitor data... by dengolius on Wednesday September 14, 2022 @02:33AM (#32833941)

I recommend to use VictoriaMetrics instead of using InfluxDB for many reasons. PostgreSQL is good SQL database for different purposes but as TSDB on a big installations it works not really well.

[ Parent | on HN ]

Re:Show HN: pg_netstat, a Postgres extension to monitor data... by mritchie712 on Tuesday September 13, 2022 @10:57AM (#32825124)

or clickhouse!

[ Parent | on HN ]

Re:Show HN: pg_netstat, a Postgres extension to monitor data... by dengolius on Wednesday September 14, 2022 @02:35AM (#32833950)

+1 have a good experience with using it

[ Parent | on HN ]