House Rule – Upcasting Enlarge / Reduce to extend duration

The party is deep into my 5e-updated classic Greyhawk Giants series.

The hill giants and their orc and goblin minions have attacked the Sterish city of Headwater and have taken about a quarter of the city. The party is about to embark on a mission to go behind enemy lines, kidnap and assassinate a stone giant who is critical to the hill giants’ city / siege offensive as being their only trained engineer. While the party’s patron recognizes that the stone giant needs to die, she also recognizes that at present the Stone Giant Thane has not joined the giant alliance and wants to keep it that way. Thus, she is requesting that they carry the body of the slain giant honorably back to his Thane in an effort to preserve a fragile peace between the humans and the stone giants. I would like the party to be able to accept this mission, without it becoming either a logistical challenge involving wagons and draft animals, or without loaning them a portable hole.

Instead, I would like to provide them with a version of the Enlarge / Reduce spell which is in all aspects identical to the original except that it can be upcast to extend the duration.

I figure the giant is 17 feet high and 1000 pounds; after reduce it would be 8.5 feet and a manageable 125 pounds.

For this version of Enlarge / Reduce I am proposing that:

When cast at 3rd level against living creatures, it lasts 10 minutes

When cast at 3rd level against objects, it lasts 1 hour

When cast at 4th level against living creatures, it lasts 1 hour (similar to polymorph)

When cast at 4th level against objects, it lasts 8 hours

When cast at 5th level against living creatures, it lasts 8 hours (much less than geas)

When cast at 5th level against objects, it lasts 24 hours

The party Wizard is currently 8th level and getting close to 9th. Requiring her to use both her fourth level slots and maintain concentration for the duration of travel every day in order to move swiftly and stealthily into the mountains with the body is just the right level of challenge for the group.

My only concern is that allowing this version of the spell to the party wizard permanently will have some unforeseen interaction with some other spell, ability, or item that I will later regret. This question, for example, asks about upcasting enlarge to permit two changes in creature size, and answers identify the interaction with levitation and grappling being problematic. I am interested in a similar troubleshooting review.

How can I reduce time and cost to create magic items?

According to the rules, creating magic items (like Wondrous items) takes a day per 1000gp item price and cost half the price.

In the Epic level handbook there is an epic feat called Efficient Item Creation that allows you to create 10000gp per day.

Are there other ways to reduce time taken, money cost or xp cost when creating magic items? I don’t care whether they are epic or not, and a bit of cheese can be allowed.

Does Heavy Armor reduce your speed?

I noticed in the PHB, page 20, under Speed for Dwarves:

Speed. Your base walking speed is 25 feet. Your speed is not reduced by wearing heavy armor.

However, I cannot find anywhere in PHB that mentions that wearing Heavy Armor imposes any speed reduction.

Does anyone know if I’ve missed something, or if this is actually some inconsistency in the book and Heavy Armor in fact doesn’t impose any speed reduction?

Are there any poisons which reduce ability scores?

In D&D 5e, there are a number of poisons listed in the Dungeon Master’s Guide page 258. Most of these poisons deal poison damage or inflict conditions. I know that in Pathfinder there are many poisons which reduce ability scores, but I notice an absence of such poisons in this DMG list for D&D 5e. As a DM I’m considering introducing a wider variety of poisons, which also means considering a wider variety of effects.

Are there any examples of poisons in other D&D 5e materials which reduce ability scores?

Does a Spell Gem Reduce the Casting Time of Any Imbued Spell to a Single Action? [duplicate]

In my Out of the Abyss game the party has acquired a spell gem. Their first use of it with a spell they imbued was to cast Prayer of Healing (casting time: 10 minutes) in the middle of a battle with a Demon Queen. I was fine with this, as I remembered the usage time for a Spell Gem being 1 Action.

However, one of the players (a GM himself) said, “That cannot be right, the casting time shouldn’t change.” So we checked exact wording after the session. (And compared it to a Ring of Spell Storing for good measure.)

While holding the gem, you can cast the spell from it as an action if you know the spell or if the spell is on your class’s spell list. Doing so doesn’t require any components and doesn’t require attunement.

(Emphasis mine.)

That seems pretty straightforward. It is limited to casters who would have access to the spell (unlike Ring of Spell Storing), but only a single action. Perhaps Prayer of Healing should not have been allowed to be cast into the gem in the first place?

You can imbue the gem with a spell if you’re attuned to it and it’s empty. To do so, you cast the spell while holding the gem. The spell is stored in the gem instead of having any effect. Casting the spell must require either 1 action or 1 minute or longer, and the spell’s level must be no higher than the gem’s maximum.

(Emphasis mine.)

That seems quite clear that a Prayer of Healing is able to be cast into a Spell Gem. In fact, I believe it means any spell that is not cast as a Reaction or Bonus Action, since I am not aware of any spell with a casting time of more than an Action but less than 1 minute.

This sent the player off to query D&D Beyond for spells they would not normally be able to cast in the middle of a battle, and specifically (because of the thrashing they had just taken) Hallow, Planar Binding, and Glyph of Warding.

That did give me pause when we read it, and made me wonder if RAW were not exactly RAI. But while I might argue that the target would need to be in range for the duration of the initial cast for Planar Binding, I don’t think that’s RAI. And of those three mentioned, I think only Hallow would have had a large impact on the battle they just lost.

So perhaps it is not so destabilizing as I first thought. Do you think RAW are RAI (or did we misinterpret them somehow?)

Reduce Count(*) time in Postgres for Many Records


EXPLAIN ANALYZE select count(*) from product; 

ROWS: 534965


Finalize Aggregate  (cost=53840.85..53840.86 rows=1 width=8) (actual time=5014.774..5014.774 rows=1 loops=1)   ->  Gather  (cost=53840.64..53840.85 rows=2 width=8) (actual time=5011.623..5015.480 rows=3 loops=1)         Workers Planned: 2         Workers Launched: 2         ->  Partial Aggregate  (cost=52840.64..52840.65 rows=1 width=8) (actual time=4951.366..4951.367 rows=1 loops=3)               ->  Parallel Seq Scan on product prod  (cost=0.00..52296.71 rows=217571 width=0) (actual time=0.511..4906.569 rows=178088 loops=3) Planning Time: 34.814 ms Execution Time: 5015.580 ms 

How can we optimize the above query to get the counts very quickly?

This is a simple query, however, its variations can include different conditions and join with other tables.

I want to use the output of Solve and/or Reduce in next steps. But the output comes in the form of a rule [duplicate]

In a program I want to use the output of Solve and/or Reduce in next steps. But the output comes in the form of a rule, where what I want is the numerical solution. Here is an example. Say I write s=Solve[x+2==5,x]. In the next step I want to use this solution, so I write: y=2 s +3. This returns {{3+2(x->3)}}. This is a very basic need, but hours combing through the documentation leads nowhere.

Using output from Solve or Reduce as a value in subsequent equation

I’m trying to run a simulation. I will number sentences to make response easier. (1) Here is my first equation:

𝑗[LBar_, y_, x1_, σ_, X2M_, w_, X1M_]:=(LBar(𝜎−1)⁄𝜎 + 𝑦(𝜎−1)⁄𝜎−x1(𝜎−1)⁄𝜎)𝜎⁄(𝜎−1)−(𝑦−X2M+𝑤(LBar+X1M)−𝑤x1) 

(2) I insert some parameter values and Reduce:

Reduce[𝜕x1(𝑗[100,𝑦,x1,13⁄,42,.23,80])==0 && x1>0, x1, Reals] 

(3) This produces output:

x1 == 119.575 

(4) When I try to call the output value (119.575) I run into problems. (5) For instance

2 % 

results in:

2 (x1 == 119.575) 

(6) and

j[100, 80, %[[2]], 1/3, 42, .23, 80] 

produces this output:

-79.4 + 1/Sqrt[41/160000 - 1/239.149[[2]]^2] + 0.23 239.149[[2]]