Time |
Nick |
Message |
07:45 |
|
kworstell-isl joined #evergreen |
07:46 |
|
cbrown joined #evergreen |
08:35 |
|
redavis joined #evergreen |
08:51 |
|
mmorgan joined #evergreen |
09:03 |
|
dguarrac joined #evergreen |
09:07 |
csharp_ |
still alive in GA! |
09:12 |
redavis |
csharp_++ |
09:12 |
redavis |
That is the best news of this nascent day. |
09:29 |
Bmagic |
csharp_++ |
09:31 |
Bmagic |
@coffee csharp_ |
09:31 |
* pinesol |
brews and pours a cup of Colombia El Castillo Micro-Lot Nelson Melo, and sends it sliding down the bar to csharp_ |
09:31 |
Bmagic |
@coffee [someone] |
09:31 |
* pinesol |
brews and pours a cup of El Salvador Los Planes Pacamara, and sends it sliding down the bar to berick |
09:31 |
Bmagic |
@coffee [someone] |
09:31 |
* pinesol |
brews and pours a cup of El Salvador Montecarlos Tablon Crater, and sends it sliding down the bar to Jaysal |
09:31 |
Bmagic |
@tea [someone] |
09:31 |
* pinesol |
brews and pours a pot of Earl Grey Decaffeinated Black Tea, and sends it sliding down the bar to dguarrac (http://ratetea.com/tea/bigelow/earl-grey-decaf/87/) |
09:31 |
Bmagic |
@tea [someone] |
09:31 |
* pinesol |
brews and pours a pot of Chamomile Lemon (Sweet Meadows), and sends it sliding down the bar to dmoore_doppel (http://ratetea.com/tea/numi/chamomile-lemon/504/) |
09:31 |
Bmagic |
@tea [someone] |
09:31 |
* pinesol |
brews and pours a pot of Magic Summer Organic Tea, and sends it sliding down the bar to pinesol (http://ratetea.com/tea/organic-herbie/magic-summer-organic-tea/9533/) |
09:31 |
berick |
woot. just soupy dregs here |
09:36 |
dguarrac |
Bmagic: Thanks! |
09:36 |
dguarrac |
pinesol: Decaf? On Friday? |
09:36 |
pinesol |
dguarrac: PHRASING!!! |
09:38 |
Bmagic |
haha |
10:49 |
|
kworstell_isl joined #evergreen |
10:57 |
sleary |
Equinox folks are all OK. Some are having intermittent power outages. |
10:57 |
redavis |
sleary++ |
11:04 |
Bmagic |
sleary++ |
11:05 |
Bmagic |
from the ashes, Evergreen will arise anew |
11:07 |
berick |
Evergreen 4.0 codename Phoenix |
11:08 |
Bmagic |
berick++ # perfect |
11:15 |
redavis |
But...it'd be great to forego the ashes... |
11:15 |
redavis |
Maybe just some burning of incense or something? |
11:15 |
redavis |
A beautiful sage smellin' phoenix? |
11:57 |
|
Dyrcona joined #evergreen |
12:01 |
* Dyrcona |
has a day off, and I'm sitting in the Salem, Mass. public library, working on Evergreen.... Well, answering some related emails. |
12:05 |
|
jihpringle joined #evergreen |
12:11 |
csharp_ |
Dyrcona++ # look forward to being up there soon |
12:13 |
Dyrcona |
csharp_: I know a few places to hang out in the evening, despite living about 30 miles inland. |
12:16 |
|
cbrown joined #evergreen |
12:17 |
Dyrcona |
https://thecastlebeverly.com/ <- This might be a nice stop for Tuesday or Wednesday evening. |
12:27 |
Dyrcona |
I have been there for a poetry night last year. Haven't played games there, yet. |
12:36 |
|
jihpringle21 joined #evergreen |
13:35 |
|
kworstell-isl joined #evergreen |
14:18 |
|
smayo joined #evergreen |
14:52 |
|
kmlussier joined #evergreen |
15:02 |
jeffdavis |
The Vandelay slowness I mentioned yesterday seems to be because the reporter.old_super_simple_record view is super slow, the bbb_simple_rec_trigger on biblio.record_entry (which does a lookup on that view) gets called during overlay, and for some reason vandelay.overlay_bib_record doesn't finish until the trigger is done even though it's an AFTER trigger. |
15:15 |
jeffdavis |
reporter.old_super_simple_record lookups are also super quick in our old environment, but super slow in the new one, which is maybe the immediate problem. |
15:42 |
eeevil |
jeffdavis: is JIT enabled in the new env? IIRC, that was one of the views that gets much worse when PG tries to apply JIT optimizations |
15:52 |
jeffdavis |
hmm, no it's not, and oddly the jit_above_cost setting has disappeared from postgres.conf in our old environment too... |
15:55 |
jeffdavis |
eeevil++ # that did it, thank you! |
15:55 |
eeevil |
disabling JIT? cool, glad it was "easy" :) |
16:07 |
|
jihpringle joined #evergreen |
16:25 |
csharp_ |
jeffdavis++ eeevil++ |
17:00 |
Bmagic |
jeffdavis: JIT! I was about to ask that as I was reading and I see eeevil beat me to it. That is the exact function that suffers the most from JIT being turned on. It manifested for me when saving a bib in the staff client. It was so slow, that the interface would fail to save the marc record. |
17:00 |
Bmagic |
function/table/view |
17:04 |
Bmagic |
I found the conversation http://irc.evergreen-ils.org/evergreen/2023-10-30 and http://irc.evergreen-ils.org/evergreen/2023-10-31 |
17:05 |
|
mmorgan left #evergreen |
17:07 |
jeffdavis |
I even commented on the bug at the time saying that disabling JIT fixed the issue for us (LP 2042158). Some days my memory is like a whaddayacallit. |
17:07 |
pinesol |
Launchpad bug 2042158 in Evergreen "Postgres 12+ needs to have JIT disabled" [High,Fix released] https://launchpad.net/bugs/2042158 |
17:48 |
Bmagic |
jeffdavis++ |
20:48 |
|
kmlussier left #evergreen |
21:50 |
pinesol |
News from commits: LP2081758 Self Check with invalid email <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=4099971e96c875571daa6ed0cfff40a188d564b1> |