Time |
Nick |
Message |
07:27 |
|
rjackson_isl_hom joined #evergreen |
07:50 |
|
BDorsey joined #evergreen |
08:06 |
|
mantis1 joined #evergreen |
09:07 |
|
jvwoolf joined #evergreen |
10:01 |
berick |
miker: JBoyer: now with analyze: https://gist.github.com/berick/ec95e8756e5287373ca46d3335a558b9 |
10:02 |
JBoyer |
berick++ |
10:08 |
berick |
neat seeing "parallel worker for PID" w/ PG 10 |
10:10 |
|
Dyrcona joined #evergreen |
10:20 |
csharp_ |
"SQL, now with ANALYZE!" |
10:21 |
csharp_ |
berick: I get excited when I see those procs too :-) |
10:21 |
csharp_ |
holy crazznap: Execution time: 127095178.213 ms |
10:22 |
csharp_ |
35.3041666667 hours (thanks to DuckDuckGo) |
10:25 |
Dyrcona |
That's what happens when you do a Cartesian product of two very large tables, provided you don't run out of memory first. |
10:26 |
Dyrcona |
Which reminds me...I've got something running on a test vm that I should check. It's probably finished by now. |
10:27 |
Dyrcona |
I used time on it: 2719m34.212s |
10:33 |
Dyrcona |
45 hours 19 minutes. |
10:37 |
Dyrcona |
PostgreSQL and kernel updates..... |
10:37 |
Dyrcona |
Hmm.. When is Pg 15 supposed to be released.... |
10:39 |
Dyrcona |
Pg 10 is EOL this November. |
10:42 |
Dyrcona |
Pg 15 release planned "in the third quarter of 2022." I can't find anything more specific than that, though Beta 3 was just released. |
11:39 |
|
BDorsey joined #evergreen |
11:51 |
|
jihpringle joined #evergreen |
11:54 |
Dyrcona |
Well, no errors in the test record load since I fixed the encoding in the Perl code. |
13:21 |
|
stephengwills left #evergreen |
14:15 |
|
BDorsey joined #evergreen |
22:33 |
|
bshum joined #evergreen |
22:48 |
|
bshum joined #evergreen |