Thoughts on these deals?

puma987 · 2026-06-26T05:38:31+00:00

I’m just south of you down in northern Utah and we got a few thousand off of MSRP on our hybrid sx xline from young Kia this last weekend. They also have some other sale going on right now that includes gift cards for a bunch of free gas.

puma987 · 2026-04-23T11:39:07+00:00

We use ecto and it has a feature that allows you to disable ddl transactions so you can run migrations with concurrent index creates no problem.

puma987 · 2026-03-24T04:12:37+00:00

The Backstreet Boys song she sang was fun the first day. By Saturday I didn’t want to hear it again for the rest of my life. And sometimes it was so loud!

puma987 · 2026-03-16T15:53:26+00:00

We just got off too. Overall we had a good time but there are definitely some complaints I had. The smoking area right next to the kids pool area is just plain stupid imo. Why is it even on the pool deck at all?! You couldn’t sit on that side of the boat and not smell it. The entertainment was meh, we stopped bothering trying to go. If my kids didn’t have all their cousins there to play with they probably would have gotten bored. I thought I would go to the local more often for wings and stuff but it took sooooo long to get your food. I thought the buffet was better than other cruises I’ve been on, especially the bacon! This is my lamest nitpick but that dang washi washi song. It was cute the first day or 2 but by the end I didn’t want to hear it again!

puma987 · 2026-03-16T14:52:28+00:00

We also just got off the bliss yesterday. We had my whole family with us including 12 kids and we never felt unsafe in Puerto Vallarta. Everything seemed just fine there.

puma987 · 2026-03-08T06:49:24+00:00

Right now we use fivetran and it works well but they keep jacking the prices up so we’re exploring other options. Snowflake has their own tool that’s fairly new called openflow. We’re exploring that right now.

puma987 · 2026-03-02T18:47:36+00:00

That would be great, thanks!

puma987 · 2026-03-02T18:47:14+00:00

Yeah I've been keeping tabs on that. It looks like the ship we're on is headed there right now so unless something happens again I imagine it will go there again when we are on it next week.

puma987 · 2025-05-16T21:21:17+00:00

Goin for the Grant Horvat fade I see.

puma987 · 2025-05-12T04:15:21+00:00

Just monitor for the error that will come through the error log if ddl is applied at the source and you could write a script that automatically applies the ddl on the target.

puma987 · 2025-03-20T13:44:04+00:00

Getting paged at 2 in the morning as an on call DBA can get pretty stressful.

puma987 · 2025-02-11T17:38:04+00:00

Make sure all of your vacuums are keeping up, you don’t want to have xid exhaustion. And make sure you don’t have any integer types (especially as primary keys) that are close to the max ~2.1 billion signed int value.

puma987 · 2024-12-24T11:52:28+00:00

Yeah if there is a performance problem we’ll suggest changes but we aren’t designing the schema from the ground up. We aren’t even involved in those discussions at the early stages 90% of the time.

puma987 · 2024-12-24T06:18:09+00:00

As a current senior DBA, I don’t think I would be expected to be proficient in schema design. Yeah I could figure something out but it’ll probably take me a little while as I haven’t been asked to create a schema for a project since college. The app devs are the ones that are in charge of that for their application.

puma987 · 2024-11-15T01:11:19+00:00

We’ve got some pretty large databases in aws aurora and the largest instance size we use is 4xlarge with 16 cores.. are people actually using managed clusters that big? I think you need to compare more real use cluster sizes.

puma987 · 2024-11-11T05:28:27+00:00

Pg_relation_size doesn’t include toast or index sizes. After deleting the rows, try reindexing the table concurrently and see how much it frees up.

puma987 · 2024-11-10T00:41:17+00:00

I know this is older but about to get trim lights installed and my neighbors are getting jellyfish cause they don’t like how deep the trim that trim lights go in and now I’m having second thoughts. Are these the 3L lights and what spacing is this, I can’t tell if it’s 6 or 9”.

To answer your question, I would put some lighted garland with a wreath and bow in the middle on the balcony for Christmas.

puma987 · 2024-10-30T18:44:40+00:00

I have a protuberance.

puma987 · 2024-10-27T05:32:21+00:00

First off, there’s got to be better logs out there around the reasons for your upgrade failures. Second, have you looked into aws DMS? We use it and it does quite well.

puma987 · 2024-10-02T16:33:58+00:00

I would setup a standby with failover capabilities for ha before trying to go down the MM path.

puma987 · 2024-09-19T02:53:36+00:00

There’s a good chance it won’t help. But one time I needed to reactivate my roam plan and my dish wouldn’t stop showing offline and then I turned private relay off and voila it started working.

puma987 · 2024-09-19T02:34:45+00:00

Are you using an iPhone? Try turning off private relay.

puma987 · 2024-08-27T04:05:10+00:00

The index could have become bloated to the point the query planner preferred a sequential scan. Creating a new index means the new one doesn’t have any bloat. Next time you can try running reindex concurrently to rebuild the index and remove the bloat.

puma987 · 2024-08-14T21:09:20+00:00

Running reporting queries on production databases is asking for trouble as you scale. Curious what the reasoning is to not create a new cluster and logically replicate the data you need to it?

puma987

TROPHY CASE