Hacker GitHub

← All repos

pjungwir/aggs_for_arrays

View on GitHub ↗ ★ 50 C

A Postgres extension in C to compute statistics on arrays of numbers

56 mentions on Hacker News by 1 person: 0 stories, 56 comments · first 2015-02-02 · latest 2024-08-03

Mentions per year 56 mentions · busiest year 2015 (13)
20082026
  1. …to Postgres) https://commitfest.postgresql.org/31/2112/ (Adding multiranges to Postgres) https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/aggs_for_vecs https://github.com/pjungwir/active_model_serializers_pg If you'd…
  2. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/aggs_for_vecs https://github.com/pjungwir/active_model_serializers_pg…
  3. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/aggs_for_vecs https://github.com/pjungwir/active_model_serializers_pg…
  4. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/active_model_serializers_pg If you'd like to work together, I'd be…
  5. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/active_model_serializers_pg If you'd like to work together, I'd be…
  6. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/active_model_serializers_pg If you'd like to work together, I'd be…
  7. …ithub.com/pjungwir/active_model_serializers_pg [2] https://github.com/zdennis/activerecord-import [3] https://github.com/pjungwir/aggs_for_arrays [4] https://github.com/pjungwir/aggs_for_vecs [5] https://github.com/pjungwir/floatvec
    comment by pjungwir · 2019-10-12 · in How to write fast code in Ruby on Rails
  8. …yet, but they still do all the divisions; what I really want is a different algorithm.) [0] https://github.com/pjungwir/aggs_for_arrays [1] https://github.com/pjungwir/aggs_for_arrays/blob/master/arra...
  9. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  10. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  11. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  12. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  13. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  14. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  15. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  16. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  17. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  18. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  19. …excellence. You can see some of my recent work here: https://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  20. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  21. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  22. …invalid memory alloc request size 1073741824`. I don't think cstore_fdw has that problem. [0] https://github.com/pjungwir/aggs_for_arrays/ [1] http://www.postgresql-archive.org/Performance-appending-to-a... [2]…
    comment by pjungwir · 2017-10-12 · in Columnar Store for Analytics with Postgres
  23. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  24. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  25. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  26. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  27. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  28. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  29. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  30. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  31. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  32. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  33. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  34. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  35. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  36. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  37. …you I've found a couple opportunities to write C by building Postgres extensions. Here are my two: https://github.com/pjungwir/aggs_for_arrays/ https://github.com/pjungwir/inetrange Both of those are used in production systems and had good…
  38. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  39. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  40. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  41. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  42. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  43. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  44. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  45. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  46. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  47. …that operate on arrays, and brought query times down from ~12 seconds to ~20 milliseconds: https://github.com/pjungwir/aggs_for_arrays/ Another time arrays are handy is when you don't know how many "columns" you need to return. SQL can't…
    comment by pjungwir · 2015-09-11 · in PostgreSQL Magic
  48. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  49. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…
  50. …excellence. You can see some of my recent work here: http://illuminatedcomputing.com/portfolio https://github.com/pjungwir/aggs_for_arrays https://github.com/pjungwir/db_leftovers If you'd like to work together, I'd be happy to discuss…