Will Postgres use a multi-column index when setting multiple colums not null?

Typically, when I set a column not null, if it doesn’t have an index then I add it first, so that postgres can (hopefully) use the index while doing the table scan while locking the table, so that the table is locked for a shorter amount of time.

I want to set several columns not null, like so:

alter table foos   alter column bar1 set not null   alter column bar2 set not null   alter column bar3 set not null   alter column bar4 set not null; 

If I make a multicolumn index for these columns, will postgres use it when scanning the locked table before making this alteration?

CREATE INDEX CONCURRENTLY my_index on foos (bar1, bar2, bar3, bar4); 

What if I made a partial index on IS NULL (or, IS NOT NULL)

CREATE INDEX CONCURRENTLY my_index on foos (bar1, bar2, bar3, bar4) where bar1 is null and bar2 is null and bar3 is null and bar4 is null; 

setting up constrained maximization

I am trying to enter the maximization problem with constraints below:

$ $ \begin{aligned} & \underset{x_0, x_1}{\text{max}} & & \Big[a(C-x)+(1-a)(z-y)\Big] \ & \text{s.t.} & & a u(x_1)+(1-a)u(y)-h \geq 0 \ & & & (a-b)(u(x)-u(y)) \geq 0 \end{aligned} $ $

as:

Maximize[{a(C-x)+(1-a)(z-y), au(x)+(1-a)u(y)-h >= 0, (a-b)(u(x)-u(z))>=0}, {x,y}] 

Is this the correct way to enter the problem- especially the u(x) and u(y) terms?

Can anyone read the inscription on the 3rd edition Forgotten Realms Campaign Setting cover?

The cover for the book in question has inscriptions in the espruar script on its outer circle. According to one of the authors, it means: “ We remember cities now in ruin and forests murdered, yet still we sing to the stars and hope for renewal.”

I’m trying to find out how it’s pronounced in elven. Does anyone have a copy of the book, or a good quality image that they can read?

Can Blades in the Dark be played in a custom setting?

I’m looking at systems for my next campaign. Currently I really like the look of Blades in the Dark however I have one concern before I invest in buying the rulebook.

Every review of the system I have read talks about how great the setting of Duskvol is and how much of the world building is done for you. It also seems that some of the playbooks and factions are heavily tied to the setting. Particularly the ghosts seem integral to the system.

Ideally I wanted to use this system in a homebrew city within my own world that I currently use to run a pathfinder game. My setting wouldn’t have ghost and would likely be a lower technology level than the default setting.

How well does Blades in the Dark adapt to a custom setting?

Is there a lore explanation why each setting might have different deities?

As far as I know, the multiverse of D&D 5E consists in different worlds all residing in the Material Plane, but the rest of the planes (Transitive Planes, Inner Planes, Outer Planes…) are shared between them.

Is there a lore explanation why each setting might have different deities? Since deities exist in planes other than the Material Plane, shouldn’t those deities be the same in every setting?

Setting up a Destination Goal in Google Analytics using Regex

I want to set up a destination goal in GA to determine when a user reaches the end of a flow, or basically has completed a process.

The problem, the URL changes depending on the activity of the user so we have a URL like this (below) which can vary.

apply/UserAccount?execution=e1s2

The S2 represents the last stage in the flow, which is the page I’m trying to capture. However the e1 could be any number depending on the other activities of the user.

Can someone help with writing a Regex to make sure GA captures the every time a user reaches the last page regardless of the execution number? Is there a way to ignore the “E1” value and simply match the rest? I am completely new to this part so I’d be embarrassed to share what I’ve tried 🙂

Are there any PL2 options that are viable in a PL20 setting?

I’ve been doing a thought experiment involving Inventing in Mutants and Masterminds 3e. The way Inventing works is a DC 10+pp Technology check to design something at the rate of 1hrs/pp followed by a DC 10+pp Technology check to build it at the rate of 4hrs/pp. However, by pairing it with Quicken, you decrease the time rank tasks take you by the ranks in Quicken. This becomes a significant boon once you hit PL 20. If you invest the minimum 51pp required, you can design and create a 30pp invention in less than a second (practically a free action), OR spend 6 seconds to design and construct anywhere between 12 to 25 unique 30pp inventions (depending on if your DM considers 30hrs as Rank 14 or 15 time).

Now that many temporary devices being constructed in such a short amount of time can be devastating under the right circumstances, but I am more interested in the Construct spawning side of the equation.Being able to spawn 12-25 independent constructs a turn (or 6-12 if your GM limits you to a standard action with Inventing) while having access to usable materials sounds like a serious threat. However, both the PL limits of something with 30pp and the arsenal a PL 20 character has at their disposal make this a very ill-advised option. I know that just making regular devices with Inventing is most likely the most efficient thing I could do with the synergy I proposed, but are there any options a PL2 Construct can take that function decently in a PL20 setting?

What major changes will 5e bring in the Forgotten Realms campaign setting?

As I understand it 4e takes the Forgotten Realms storyline up to around 1469 DR. How far will 5e take it, if at all?

Will there be many changes to the story?

I am using many realms characters, such as Jarlaxle, in my campaign.. my campaign takes place in 1499 DR and I try to follow the Forgotten Realms Campaign Setting as closely as possible; will I expect drastic changes in things like deities come 5e? Or will 5e be more about mechanical changes, etc.?

What D&D setting or universe resemble’s Warcraft’s Outlands?

A few years ago I wrote a homebrew campaign. For a few levels of the campaign, the players are teleported from a city within the Forgotten Realms setting into another dimension of the multi-verse. I described the dimension as a group of floating planets, islands, and rocks, near to the stars and other celestial bodies. I based a lot of it on the Outlands, from World of Warcraft’s The Burning Crusade.

enter image description here

enter image description here

You could fly around from island to island using native giant squid as means of transportation. Fractured planets with unconventional physics could be found, from floating islands, to actual spherical islands (with gravity), to islands with a river that flowed against gravity.

I am currently formatting my campaign for publishing, and I was wondering whether there is already a similar dimension, plane, or setting in the D&D multiverse which I could use as a base and modify from there. I prefer basing things on D&D lore instead of Warcraft one because I feel it will be better for readers that want to explore additional lore.

As there ever been something similar in published D&D settings?

Is there a Forgotten Realms campaign setting book for D&D 5e?

To immerse myself into the world of the Forgotten Realms I wanted to pick up a book or source materials of the lore. Is there a comparable book like it exists for Pathfinder with the Inner Sea World Guide?

In my research I found a 4th edition book called Forgotten Realms Player’s Guide (2008) and 3.x Forgotten Realms Campaign Setting (2001)

The newest I’ve found is the Sword Coast Adventurer’s Guide but I don’t know how in-depth that is.

Are these worth picking up or is there newer or even better information out there? I know opinion questions aren’t allowed – I’m just asking if there’s a definitive source of up-to-date published lore, that’s not a wiki