« first day (4282 days earlier)
← previous day
next day →
last day (590 days later) »
Paul White
12:07 AM
Z probably prefers the new CE as well eh
Erik Darling
12:30 AM
Sucks to your assmar
6 hours later…
Zikato
6:50 AM
Morning
Paul White
7:08 AM
morning
5 hours later…
Michael Green
12:06 PM
@ErikDarling
l-hit.com/en/340649
^^ Australian band.
2 hours later…
Vérace
2:07 PM
A chairde - Morning all!
1 hour later…
Hannah Vernon
3:11 PM
@ErikDarling is that some new kind of gibberish?
Or am I just not up on my memes
Vérace
Dear God! How long should it take to put a composite PK (1 INT, 1 timestamp) on a 31M record (secs in a year) table - SATA SSD?
Erik Darling
3:43 PM
@MichaelGreen hah. at least it wasn’t weezer.
@HannahVernon it’s fairly easy to track down
Zikato
I had to track it down as well. It's from Lord of the Flies and the "assmar" is supposed to mean "asthma"
Hannah Vernon
4:21 PM
Cheers
1 hour later…
Erik Darling
5:44 PM
The transcript has a few funny hits for assmar
John K. N.
6:01 PM
@Vérace I wrote a script to find corrupt items in pg_toast tables.
Vérace
6:34 PM
@JohnK.N. So you think TOAST-ability is a goodie? How do other systems cope with oversize records - whatever the definition of "oversize" may be! I hope you've released your script into the wild as F/LOSS? :-)
ypercubeᵀᴹ
@Vérace most would do something similar. If a row does not fit in the page size, it has to be stored somewhere.
eg for mysql's InnodDB engine, see this article:
percona.com/blog/2010/02/09/blob-storage-in-innodb
Vérace
7:26 PM
@ypercube - Thanks for that!
On the other hand, I'm flummoxed, puzzled, baffled, bewildered and mystifed, to say nothing of perplexed, discombobulated and nonplussed!
I'm battling with that f***ing SQL from the other day - it's really mad! Joining up intervals of different lengths is no walk in the park!
I have one working solution - but I'm not going down without a fight!
Erik Darling
7:42 PM
@Vérace hoodwinked, bamboozled, lead astray, run amok and flat out deceived
Vérace
8:36 PM
@JohnK.N. What other PostgreSQL features catch your fancy?
Ah well, I'm knackered and off to the leaba (bed)! Oíche mhaith go léir- Evening all!
« first day (4282 days earlier)
← previous day
next day →
last day (590 days later) »
all rooms
Transcript for
Sep
24
Sep '22
25
Sep
26
The Heap™ – Consultancy ©®
General on- and off-site discussion for
dba.stackexchange.com
....
10
frogs
mysql
nosql
oracle
postgresql
sqlite
sql-server
join this room
about this room
00:00
06:00
12:00
18:00
all times are UTC
site design / logo © 2024 Stack Exchange Inc;
legal
mobile