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
20082026
-
…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…
comment by pjungwir · 2024-08-03 · in Ask HN: Freelancer? Seeking freelancer? (August 2024) -
…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…
comment by pjungwir · 2022-07-05 · in Ask HN: Freelancer? Seeking freelancer? (July 2022) -
…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…
comment by pjungwir · 2021-11-08 · in Ask HN: Freelancer? Seeking freelancer? (November 2021) -
…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…
comment by pjungwir · 2020-08-03 · in Ask HN: Freelancer? Seeking freelancer? (August 2020) -
…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…
comment by pjungwir · 2020-01-02 · in Ask HN: Freelancer? Seeking Freelancer? (January 2020) -
…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…
comment by pjungwir · 2019-12-03 · in Ask HN: Freelancer? Seeking Freelancer? (December 2019) -
…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 -
…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...
comment by pjungwir · 2019-03-23 · in Calculating the mean of a list of numbers (2016) -
…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…
comment by pjungwir · 2019-02-01 · in Ask HN: Freelancer? Seeking Freelancer? (February 2019) -
…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…
comment by pjungwir · 2019-01-02 · in Ask HN: Freelancer? Seeking freelancer? (January 2019) -
…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…
comment by pjungwir · 2019-01-01 · in Ask HN: Freelancer? Seeking freelancer? (January 2019) -
…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…
comment by pjungwir · 2018-12-03 · in Ask HN: Freelancer? Seeking freelancer? (December 2018) -
…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…
comment by pjungwir · 2018-11-01 · in Ask HN: Freelancer? Seeking freelancer? (November 2018) -
…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…
comment by pjungwir · 2018-10-01 · in Ask HN: Freelancer? Seeking freelancer? (October 2018) -
…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…
comment by pjungwir · 2018-09-03 · in Ask HN: Freelancer? Seeking freelancer? (September 2018) -
…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…
comment by pjungwir · 2018-08-01 · in Ask HN: Freelancer? Seeking freelancer? (August 2018) -
…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…
comment by pjungwir · 2018-07-02 · in Ask HN: Freelancer? Seeking freelancer? (July 2018) -
…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…
comment by pjungwir · 2018-06-01 · in Ask HN: Freelancer? Seeking freelancer? (June 2018) -
…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…
comment by pjungwir · 2018-05-01 · in Ask HN: Freelancer? Seeking freelancer? (May 2018) -
…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…
comment by pjungwir · 2018-04-02 · in Ask HN: Freelancer? Seeking freelancer? (April 2018) -
…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…
comment by pjungwir · 2018-01-02 · in Ask HN: Freelancer? Seeking freelancer? (January 2018) -
…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 -
…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…
comment by pjungwir · 2017-09-02 · in Ask HN: Freelancer? Seeking freelancer? (September 2017) -
…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…
comment by pjungwir · 2017-08-02 · in Ask HN: Freelancer? Seeking freelancer? (August 2017) -
…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…
comment by pjungwir · 2017-07-03 · in Ask HN: Freelancer? Seeking freelancer? (July 2017) -
…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…
comment by pjungwir · 2017-06-02 · in Ask HN: Freelancer? Seeking freelancer? (June 2017) -
…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…
comment by pjungwir · 2017-05-05 · in Ask HN: Freelancer? Seeking freelancer? (May 2017) -
…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…
comment by pjungwir · 2017-04-03 · in Ask HN: Freelancer? Seeking freelancer? (April 2017) -
…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…
comment by pjungwir · 2017-03-01 · in Ask HN: Freelancer? Seeking freelancer? (March 2017) -
…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…
comment by pjungwir · 2017-02-01 · in Ask HN: Freelancer? Seeking freelancer? (February 2017) -
…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…
comment by pjungwir · 2017-01-02 · in Ask HN: Freelancer? Seeking freelancer? (January 2017) -
…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…
comment by pjungwir · 2016-12-01 · in Ask HN: Freelancer? Seeking freelancer? (December 2016) -
…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…
comment by pjungwir · 2016-11-01 · in Ask HN: Freelancer? Seeking freelancer? (November 2016) -
…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…
comment by pjungwir · 2016-10-03 · in Ask HN: Freelancer? Seeking freelancer? (October 2016) -
…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…
comment by pjungwir · 2016-09-01 · in Ask HN: Freelancer? Seeking freelancer? (September 2016) -
…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…
comment by pjungwir · 2016-08-01 · in Ask HN: Freelancer? Seeking freelancer? (August 2016) -
…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…
comment by pjungwir · 2016-07-29 · in Ask HN: Improve C language skills after K&R? -
…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…
comment by pjungwir · 2016-07-01 · in Ask HN: Freelancer? Seeking freelancer? (July 2016) -
…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…
comment by pjungwir · 2016-06-01 · in Ask HN: Freelancer? Seeking freelancer? (June 2016) -
…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…
comment by pjungwir · 2016-05-02 · in Ask HN: Freelancer? Seeking freelancer? (May 2016) -
…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…
comment by pjungwir · 2016-04-03 · in Ask HN: Freelancer? Seeking freelancer? (April 2016) -
…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…
comment by pjungwir · 2016-03-01 · in Ask HN: Freelancer? Seeking freelancer? (March 2016) -
…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…
comment by pjungwir · 2016-01-02 · in Ask HN: Freelancer? Seeking freelancer? (January 2016) -
…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…
comment by pjungwir · 2015-12-02 · in Ask HN: Freelancer? Seeking freelancer? (December 2015) -
…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…
comment by pjungwir · 2015-11-02 · in Ask HN: Freelancer? Seeking freelancer? (November 2015) -
…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…
comment by pjungwir · 2015-10-01 · in Ask HN: Freelancer? Seeking freelancer? (October 2015) -
…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 -
…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…
comment by pjungwir · 2015-09-01 · in Ask HN: Freelancer? Seeking freelancer? (September 2015) -
…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…
comment by pjungwir · 2015-08-03 · in Ask HN: Freelancer? Seeking freelancer? (August 2015) -
…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…
comment by pjungwir · 2015-07-01 · in Ask HN: Freelancer? Seeking freelancer? (July 2015)