pramsey

9 ms·

31.
by pramsey 3y ago
Similar to https://github.com/vibhorkum/pg_background
32.
by pramsey 3y ago
This is the most true-to-myself comment I've seen so far. I've only ever bought Toyota cars, but my next car will be an EV and Toyota's offerings are... subpar, and barely there. I trust Toyota build quality and manufacturing
33.
by pramsey 3y ago
If you let the JSON blobs grow past the page size the cost of recovering TOAST tuples can be 10x reading main storage. Also JSON is fundamentally de-normalized so you can incur scan and read costs just from hauling out duplicate values wher
34.
by pramsey 4y ago
update pg_index set indisvalid = false where indexrelid = 63514;
35.
by pramsey 4y ago
Article says he's working on multi-variate calculus now, which implies he was able to dredge up enough of his 50-year-old knowledge of basic calculus to even understand what the teacher is saying. Impressive.
36.
by pramsey 4y ago
Valhalla in particular in an in-memory router, so it's holding the whole transportation graph in memory. Not sure about the tiling and geocoding pieces. Most organizations with a "need to serve the world" requirement presumab
37.
by pramsey 4y ago
Yes! Actually, I was thinking "WAL" is constantly thrown around without explanation too.
38.
by pramsey 4y ago
Nice to know, in this dark age, there are still true Heroes walking among us.
39.
Why is Dec 30, 1899 the Microsoft zero date?(social.msdn.microsoft.com)
1 points by pramsey 4y ago|0 comments
40.
Real-time Postgres events with pg_eventserv(crunchydata.com)
5 points by pramsey 4y ago|0 comments
41.
by pramsey 4y ago
No support for geometry or ranges, alas! "Datastream doesn't support columns of the Geometric data types or Range data types. The values in these columns will be replaced with NULL values."
42.
Generate Unlimited Crypto Using Postgres(crunchydata.com)
1 points by pramsey 4y ago|0 comments
43.
by pramsey 4y ago
Good point! I guess the prudent FAANG engineer would buy a total market fund and then short a portion of their employer to net out the overexposure. Would sure feel odd though!
44.
by pramsey 4y ago
Also, you can `CREATE EXTENSION postgis` on it, and all that works too!
45.
Finding missing records with Postgres anti-joins(crunchydata.com)
5 points by pramsey 4y ago|0 comments
46.
Tech company Esri will pay $2.3M to settle pay discrimination claims(hrdive.com)
2 points by pramsey 4y ago|0 comments
47.
by pramsey 4y ago
You can check if your data remain correlated after your updates. It's possible they do: SELECT correlation FROM pg_stats WHERE tablename = 'mytable' AND attname = 'mytimestamp';
48.
Choosing a PostgreSQL Number Format(crunchydata.com)
3 points by pramsey 4y ago|0 comments
49.
by pramsey 4y ago
I had a good time with the pq module for a pgsql/python [1] queue. There's a certain brutal simplicity to just having one persistent process, the database, to manage. [1] https://pypi.org/project/pq/
50.
Postgres Indexes, Selectivity, and Statistics(crunchydata.com)
30 points by pramsey 4y ago|0 comments
51.
by pramsey 4y ago
Right? The emotion of the response seems completely out of scale to the ambition of the reform proposed. "Maybe polygons?"
52.
by pramsey 4y ago
1000 times yes! I am a spatial data expert but only a some-time OSM editor and I still have yet to figure out how to create a polygonal feature more complex than a single building footprint. The theoretical advantage of a unified topology m
53.
by pramsey 4y ago
Yes, a postgrest container would have also worked just fine for this one.
54.
by pramsey 4y ago
The app is built with containers running inside Postgres. Wasn't sure whether to lead with the cool map or the cool tech.
55.
Instant Heatmap with pg_featureserv(crunchydata.com)
46 points by pramsey 4y ago|4 comments
56.
SQL Comments Trick Improves Postgres Traceability(crunchydata.com)
4 points by pramsey 4y ago|0 comments
57.
by pramsey 4y ago
GeoParquet just embeds the geometry as WKB, so getting PostGIS geometry is as simple as going "SELECT geom::geometry FROM my_parq_fdw_table". The spec doesn't yet have anything to say about how to get a good spatial sort or c
58.
by pramsey 4y ago
Agg pushdown is a thing in FDW, I hadn't really thought about the extent to which pulling rows into PgSQL and then summarizing them is a waste of time. I imagine actually implementing agg pushdown in the parquet_fdw might be too much t
59.
by pramsey 4y ago
There is the cstore extension, which is pretty much "native" (at some point these terms start to lose meaning... it's running in the same process space and transaction aware, etc.)
60.
by pramsey 4y ago
Parquet is a column-based file format. PostgreSQL is a SQL query engine, and the default storage is row-oriented, but the engine can do all kinds of fun things, hence the parquet_fdw extension and the cstore extension for example.

More ›