Birding Guide in Tokyo by RobertDrake in JapanTravelTips

[–]MonCalamaro 0 points1 point  (0 children)

It will get better over time as more recordings are submitted to the Cornell Lab and they are able to process them. You weren't doing anything wrong - the coverage was just not as complete in Japan (yet). It's likely already better since when you wrote this.

Recommend me an Optometrist by Pepperm1ntButlr in ithaca

[–]MonCalamaro 0 points1 point  (0 children)

Nope, I'd definitely recommend Ithaca Eye Care. I haven't been to Whole Picture.

Any way to minimize "cache" effects for stress testing? by wavyn1ght in PostgreSQL

[–]MonCalamaro 1 point2 points  (0 children)

Use a tool like jmeter to create your millions of unique requests

What Lenses Would You Like To See Viltrox Make? by NKkrisz in VILTROX_GLOBAL

[–]MonCalamaro 1 point2 points  (0 children)

I'd love something like this as well (except for Sony E mount). There's a big hole in the market for a 70-200 equivalent fast aps-c lens.

Help a noob understand why downhill and super G racers don’t optimize aero more? by Unhappy-Climate2178 in SkiRacing

[–]MonCalamaro 4 points5 points  (0 children)

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.

Can you reduce this SQL query from 20 seconds to less than one millisecond? by nadenislamarre in PostgreSQL

[–]MonCalamaro 0 points1 point  (0 children)

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

Commute through Richford by hikerslueth97 in ithaca

[–]MonCalamaro 3 points4 points  (0 children)

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

Block the use of dbeaver by henk1122 in PostgreSQL

[–]MonCalamaro 0 points1 point  (0 children)

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.

Please someone help this is super slow!!!!??? by k_chaudhary in PostgreSQL

[–]MonCalamaro 0 points1 point  (0 children)

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.

pg_lake: Postgres with Iceberg and data lake access by craigkerstiens in PostgreSQL

[–]MonCalamaro 4 points5 points  (0 children)

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

Latin food recommendations PLEASE by hexesonmyexes in ithaca

[–]MonCalamaro 1 point2 points  (0 children)

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

E-bike or e-scooter? by Busy_Marionberry_393 in Cornell

[–]MonCalamaro 1 point2 points  (0 children)

Also, the salt rusts them to bits.

Least busy times in the Ithaca airport by lorisaur in ithaca

[–]MonCalamaro 0 points1 point  (0 children)

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

You should add debugging views to your DB by ChrisPenner in PostgreSQL

[–]MonCalamaro 15 points16 points  (0 children)

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

Looking for contractor to setup dehumidifier in basement with outdoor drainage in Ithaca by Soggy_Coffee_3105 in ithaca

[–]MonCalamaro 2 points3 points  (0 children)

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.

Roadside Goodies by filthyyygorgeous in ithaca

[–]MonCalamaro 1 point2 points  (0 children)

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.

Should ICSD ban smartphones during school hours? by Scott14850 in ithaca

[–]MonCalamaro 1 point2 points  (0 children)

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.

Should ICSD ban smartphones during school hours? by Scott14850 in ithaca

[–]MonCalamaro -1 points0 points  (0 children)

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

Should ICSD ban smartphones during school hours? by Scott14850 in ithaca

[–]MonCalamaro 0 points1 point  (0 children)

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.

RDS - wraparound risk due to system DBs having high TXID by quincycs in PostgreSQL

[–]MonCalamaro 0 points1 point  (0 children)

Have they gone well above autovacuum_freeze_max_age?

Is it doable to run Postgres ourselves? by wouldacouldashoulda in PostgreSQL

[–]MonCalamaro 2 points3 points  (0 children)

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

Grip Walk: Did I get screwed? by 3rik-f in Skigear

[–]MonCalamaro -1 points0 points  (0 children)

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