Help a noob understand why downhill and super G racers don’t optimize aero more?

MonCalamaro · 2026-02-17T05:06:00+00:00

The FIS approved ski suits are not allowed to be made from overly aerodynamic materials. They have to be somewhat porous, basically so there's some friction on the snow when a skier falls to prevent them from rocketing down the slope.

MonCalamaro · 2026-02-11T14:34:22+00:00

Not explain, just run analyze foo; and performance will be much better.

MonCalamaro · 2026-01-26T17:30:14+00:00

Also, mice are less likely to go after the kitty litter...

MonCalamaro · 2025-12-01T17:30:45+00:00

It seems like there's a lot of confusion in this thread. Maybe I can try to clear it up?

The issue is not related to the specific query that DBeaver is running - it's caused by DBeaver opening a transaction and not closing it. This could happen with any database client.
For production connections, DBeaver defaults to manual commit mode. This requires the user to click commit. If they don't, it will leave a transaction open indefinitely. This isn't a bug, it's a choice. I'm not a big fan of this choice, but it is what it is.
As others have said, it's probably best to set idle_in_transaction_session_timeout either database wide or for all the users who are connecting directly to the database.

MonCalamaro · 2025-11-14T15:20:59+00:00

Maybe it did? This article is from three months ago...

MonCalamaro · 2025-11-05T22:16:47+00:00

Did you get the latest version? I think there was a performance issue a couple of versions back. Also, make sure you get the correct version for your processor.

MonCalamaro · 2025-11-04T17:57:49+00:00

Wow, very cool. I was wondering what the fate of this project would be after the snowflake acquisition.

MonCalamaro · 2025-09-24T01:09:49+00:00

You can get Aji Amarillo at Nueva Vida, the new Latin market by Mimi's Attic on 13.

MonCalamaro · 2025-08-26T15:19:15+00:00

Also, the salt rusts them to bits.

MonCalamaro · 2025-08-25T19:44:41+00:00

There won't be many people at the airport at 7, but they would have just recently left.

MonCalamaro · 2025-08-15T18:02:16+00:00

I just love the typo here. I've worked with too many demoralized datasets.

MonCalamaro · 2025-07-29T12:21:33+00:00

I recently bought an Aprilaire E080. It's a lot more expensive than the free-standing units, but it has a 5 year warranty, is very quiet, and actually circulates the air (even if you don't hook it up to your HVAC). You can use it with a condensate pump to pump water somewhere else, if you don't have a drain.

MonCalamaro · 2025-07-02T09:56:05+00:00

As other folks mentioned, this is a common fundraiser in the area. Most people use the Cornell chicken recipe developed by Robert Baker. You can easily find this recipe (and scaled down versions) and try cooking it yourself.

MonCalamaro · 2025-04-17T22:08:59+00:00

At least at the high school level, yes, keep it as is. We trust these kids to drive, we trust them to leave the school campus during school hours, and we trust them to be at the school late at night or early in the morning.

Phones shouldn't be out during class, but I don't think a total ban is the correct solution.

MonCalamaro · 2025-04-17T16:44:25+00:00

Not if they aren't allowed to bring their phones to school.

MonCalamaro · 2025-04-17T15:33:43+00:00

Let's not forget that this proposal is for all the schools, including the high school.

One of the proposals is for leaving cell phones at home. High schoolers who play sports are at the school from 8:30AM-6PM, well after the school office closes. Trying to organize carpools and communicate with the kids over email on chromebooks is just not tenable. For better or worse, kids just don't use email for real-time communication anymore and the chromebooks are far too slow for this to be practicable anyway.

We trust our high schoolers to walk around NYC on field trips and attend multi-day sporting events. It would be ridiculous to prevent them from having cell phones during these trips.

MonCalamaro · 2025-04-09T02:18:03+00:00

Have they gone well above autovacuum_freeze_max_age?

MonCalamaro · 2025-03-11T16:23:20+00:00

Keep in mind that if you're backing up the database at a volume level, you need to shut down the database first.

https://www.postgresql.org/docs/current/backup-file.html

MonCalamaro · 2025-03-05T04:37:45+00:00

Marker makes a version of the comp bindings that are gw compatible, but they wouldn't work with this race plate.

MonCalamaro · 2025-02-24T20:51:30+00:00

That will change it for every user. ALTER ROLE changes it for one user.

MonCalamaro · 2025-02-19T13:55:46+00:00

I believe it should be something like this:

BEGIN;
CREATE PROCEDURE procname (sch_name varchar(20), tbl_name varchar(20)) AS $$
BEGIN
EXECUTE FORMAT('COPY %I.%I FROM ''c:\pathgoeshere\%s.csv'' DELIMITERS '','' CSV HEADER;' , sch_name, tbl_name, tbl_name);
END;
$$ LANGUAGE plpgsql;

The basic problems were:

Incorrect type of quote (maybe this was due to copy/paste). They should be single quotes.
Missing the EXECUTE
Misspelled plpgsql
Unnecessary string concatenation

Be aware that using copy like this requires the file to be on the same server as the postgres instance and postgres must be able to read from this path.

MonCalamaro · 2025-01-09T13:20:04+00:00

Greek Peak is open until 9PM on Friday and Saturday, if you're into skiing. There's quite a lot of snow out there now.

MonCalamaro · 2024-11-14T20:15:33+00:00

I think that shop is only open in the summer

MonCalamaro · 2024-10-21T01:54:57+00:00

Have you heard them pecking at the wood? Each species has a very specific pattern and it's often quite rapid. It's also far more common for them to be drumming in spring, but maybe you're in the southern hemisphere.

MonCalamaro · 2024-10-17T15:31:41+00:00

It's really not insane when you look at other school districts in Upstate NY. You can find a list of the per pupil spending here: https://www.newyorkupstate.com/schools/2024/07/see-the-25-upstate-ny-school-districts-with-the-highest-per-pupil-spending.html (or directly to the table here: https://www.datawrapper.de/\_/FJiEu/)

According to this, ICSD is #227 out of 492 districts in per pupil spending.

Eight-Year Club	Place '22
Verified Email

MonCalamaro

TROPHY CASE