The Heap™ – Consultancy ©®

hallllloooo!

McNets

7:31 AM

Morning

9:13 AM

@Vérace-getVACCINATEDNOW In the famous words of Shaggy, it wasn't me

@EvanCarroll No idea. We have never had trolls here.

A chairde - Morning all!

@PaulWhite - someone has a persecution complex, perchance? :-) Maybe it was another mod interloping on your territory? What's the policy on that - can mods from, say, the French language group just wander into your bailiwick and delete random posts?

@Vérace-getVACCINATEDNOW It was Hannah.

No honour among thieves then?

But no, only site moderators can delete posts and comments. Chat is different.

@Vérace-getVACCINATEDNOW I'm not following your meaning

You grassed up your bud!

:-)

9:22 AM

Oh well it's hardly secret info

In fact anyone could have deleted that comment by flagging it.

It started with "+1" so qualified for the instant deletion regex.

10:04 AM

@PaulWhite I don't understand this? A post which gets a "+1" gets flagged by the regex daemon? That explains my most recent downvote - 1st in ages (I've had a couple recently, but rescinded after I addressed the issue(s))... nah, I think somebody got pissed off with my multiple edits of an answer that shall not speak its name... :-)

@Vérace-getVACCINATEDNOW I think you misunderstood. A comment that starts with "+1", not a post that gets an upvote

Ah... but that was a sarcastic +1 - I think our GREAT LEADER has an issue with GOTO?

@Vérace-getVACCINATEDNOW sarcastic or not, the autobots can't tell the difference

No AI/ML in SO/SE?

and I don't know who you think is your leader.

AI is not yet that good to tell sarcasm

10:11 AM

There is only one GREAT ONE! (hint: he's not the shy, retiring type!).

still, no idea.

@ypercubeᵀᴹ Talking about Evan I think?

@Vérace-getVACCINATEDNOW A comment that contains certain words can be deleted by a single user flag. "+1" is one of those magic words.

> Comments that are flagged by multiple users are deleted automatically. The number of flags needed is usually based on the comment's score. It currently takes "3 + (Score / 3)" flags (rounded up) to delete a comment. Comments containing certain keywords can be deleted with a single flag.

From the FAQ meta.stackexchange.com/a/19757

The code that detects the presence of those magic words is a regex.

Anyway it was pointless comment and I would have deleted it too.

10:59 AM

@PaulWhite you sure? I thought maybe he was talking about Trump.

Not the shy type either. And I heard he kind of retired near @Vérace-getVACCINATEDNOW

@ypercubeᵀᴹ Could be, one never knows with Vérace

@ypercubeᵀᴹ - apart from our rapport here, our nearest connection is that I live in the town in Ireland which is the origin of the name "Evan" - it surprised me to learn the name actually has Irish origins - I thought it was Welsh or English!

@ypercubeᵀᴹ Of course I, like most Europeans, am a huge Trump fan. That poor man was obviously the victim of a devil-worshipping, child-abusing cabal of Washington D.C. insiders...

You know his mother was Scottish, right?

And she was raised speaking Gaelic? She only learned English at school

11:14 AM

O.0

McNets

11:42 AM

@ypercubeᵀᴹ Who? Evan or Trump?

Trump.
his mother was born in the Isle of Lewis, off the coast of Scotland mainland. north or Ireland.

@ypercubeᵀᴹ Better to call it Scottish Gaelic (also Scots Gallic) to distinguish it from the Gaelic languages (a family with Irish, Scots Gallic/Gaelic, Manx †). The other Celtic language family is Brythonic (Welsh, Breton and Galician † - not to be confused with modern Romance Galician - which has many Celtic borrow-words). Many people say things like "Irish Gaelic" which is like saying Romance French or Pasta food/carbohydrates! Infuriates me! :-)

they are all Gaelic to me ;)

Gaelicum est, non legit! :-)

so how far apart are the Gaelic (as spoken in Ireland) and as spoken in Scotland?

Would two native speakers of each understand each other?

I've heard a Portuguese and a Spaniard speak their own and seemingly understand what each other was saying.

11:52 AM

Scottish Gaelic

Scottish Gaelic (Scottish Gaelic: Gàidhlig [ˈkaːlɪkʲ] (listen), also known as Scots Gaelic and Gaelic, is a Goidelic language (in the Celtic branch of the Indo-European language family) native to the Gaels of Scotland. As a Goidelic language, Scottish Gaelic, as well as both Irish and Manx, developed out of Old Irish. It became a distinct spoken language sometime in the 13th century in the Middle Irish period, although a common literary language was shared by Gaels in both Ireland and Scotland down to the 16th century. Most of modern Scotland was once Gaelic-speaking, as evidenced especially by...

Very close - the kingdom of Dalriada is the reason why Irish (esp. Ulster Irish) and Scots Gallic are mutually intelligible - educated speakers of both would have little problem in understanding each other. Irish & Scots Gallic are a Sprachbund extending from Kerry to the north of Scotland.

Perhaps dialect continuum would be a better term?

McNets

@ypercubeᵀᴹ same between Italian and Spaniards

Bit like French and Québecois - I used to have real difficulties understanding it when watching crappy late-night Québecois tv series, until I got a boss from Québec and picked it up - she enjoyed teaching it!

Sometimes films from Québec are subtitled in France - the reverse isn't generally true though!

My English teacher made us watch an Australian documentary. I couldn't understand a word from some of the speakers.

That's perfectly normal

12:31 PM

@ypercubeᵀᴹ Yeah, and Kiwis are even worse! :-) Was looking at something from some island off the coast of Georgia/Carolinas - somewhere like that - weird enough! Not to mention some Irish accents - I've met one Irish guy (I think he was borderline on the IQ front - nasty f***er) whom I had great difficulty understanding and one guy from Glasgow whom I never got to understand.

The lads in the back of the van (all Irish) would be laughing at me and telling the lad to "speak English..." (in very thick rural Irish accents...)

12:47 PM

I heard Gaelic for the first time the first day I visited Glasgow, some 15 years ago.

The rest of the group were shopping and while waiting them I met a guy, (70+ years old) who told me his life story, all in thick Sottish accent. I understood maybe 25% percent. Then he told me he had won a competition in singing in Gaelic and of course he offered to sing.

Funny was when the rest of my group found me and he started saying to them the same story (of his life) - and me pretending I understand perfectly.

@ypercubeᵀᴹ was he looking for the price of a drink?

nah, he was a happy old man, content enough to find someone to listen

When you say you heard "Gaelic" (i.e. I presume you mean Scots Gallic/Gaelic), was it the song? Or did he give you a few samples of Scots Gallic? If you say you understood 25%, I can't imagine it was Scots Gallic - you'd have understood none of it

the story/discussion was in English (with a Scot accent)

the song was in Gaelic

Q: Upcoming responsive Activity page

It's funny, at the start of some songs, it's very difficult to tell if it's a North African or Irish song that's beginning - Sean nós - (note, not the name Seán - derived from the Norman/French Jean) singing.

Kind of a wailing sound!

Sean nós...

It's pronounced "shan-no-se" - cut the e off nose and lengthen the s!

John K. N.

1:26 PM

29

In our continued effort to deprecate our mobile views, we’ve turned our attention to the Activity page. We’re planning on shipping the changes next week and wanted to show it off first. Check out this 5 minute tour of the Activity page and let us know what you think. The feedback we’ve received s...

37

A: Upcoming responsive Activity page

status-review I really like the improved responsiveness, and I think you've nailed the layout for small screens! My main critique is just that the "summary" page now has way too much detail on it – it's too information-rich to be a summary anymore. For its faults, I feel that the current summary ...

3:04 PM

@EvanCarroll - I've finally done the benchmark on the up_down_series question - and I'm thowing my hat at it now! Check out the paste here. Basically, what's happening is that 50k runs (x 3 methods - yours and 2 of mine) give approx. 15mins x 3 (i.e. < 1 hr) - grand.

But when I bump that up to 100k (and change order of queries to make it fair), it appears to run for ever - as of now, my first method is running for 5 and 1/2 hours and counting! One strange thing is this in the plans for the 50k run - ProjectSet (cost=127.81..2500375.32 rows=500000000 width=4) (actual rows=19380000000 loops= - that's 19 Bn - is there an 0(n^2) or O(n^x) thing going on that I haven't understood? Any input from your end much appreciated...

As you'll see from the paste, something similar happened on an old Mac Airbook that I had lying around - thought it was the machine... but there appears to be a real issue at the bottom of this...

I have no similarities to him whatsoever. Nothing.

3:29 PM

@EvanCarroll - breaking news. The query came back, but the execution time shows up as 1884031.072 ms ~ 32 mins - where did the other 5 hours go? - that 19Bn no. has jumped to 38 Bn - so it's double, so no n^2 or whatever... but I'm damned if I'm going to wait another 5 hours letting my best machine lie idle while it chugs through a death-march benchmark (try saying it after a few beers...). This missing 5 hours has me absolutely stumped though..The machine was literlly doing nothing else...

A_V

Hi there, wondering if dba stackexchange is the right place to ask questions about grafana/loki logql query questions

I can't seem to grasp how aggregations work in logql, even when you use their agg functions it returns 1 data point per 5 minutes if you try to group by different time ranges

@A_V - haven't seen too many queries on that particular topic - but go for it! You've nothing to lose - even if you don't receive an actual answer, you may find a few pointers! p.s. welcome to dba.se!

A_V

I'm starting to question why my company's architect don't ingest all those logs in a regular RDBMS instead of those weird log aggregators

googling for an interactive tool to reproduce my queries online so I can post a proper question and can't seem to find one lol

Yeah of course there's no fiddle, all these open source groups of people are creating new query language instead of asking people to understand/use indexes

3:54 PM

@A_V it's not out of scope of DBA but I am not sure if it would be best for you to put the question at SO, than dba.se

Grafana ql is weird, I'll give you that

elastic/kibana ql as well

anything other than SQL is weird, to be honest

@Vérace-getVACCINATEDNOW do you discord or IRC?

@EvanCarroll I just joined IRC - libera - under the name "Eagna" - Irish for "wisdom" (looks like your terminal modesty is catching! :-) ) - no accents allowed on IRC and the Irish for "truthful" (Vérace = fírinneach) also has an accent. Where is the discord group - do you recommend it?

pron. Ogg-nah!

4:26 PM

@Vérace-getVACCINATEDNOW Cool cool, well I am EvanCarroll on Libera. I'll catch you there. Just FYI there is a whole channel there for Pg wankery #PostgreSQL-Lounge

and they won't ban you for cracking jokes about Trump.

@Vérace-getVACCINATEDNOW I have my own discord for Houston, but a lot of people join because that's the one I'm on the most. You're welcome to come check it out.

We also won't ban you.

@EvanCarroll my inbox must be hopping so... but then, @PaulWhite told me that the bots couldn't recognise sarcasm!

discord.gg/keRyvFYk

@EvanCarroll - any "quick glance" analysis of the bm?

@Vérace-getVACCINATEDNOW Is it necessary to ping me quite so often? I get a DOINK on the desktop and a noise from my phone each time.

Apologies - I'll keep that in mind - no more @ symbols - I'll just reply and you're bound to see it anyway. I get that annoying "boing" as well... but I'm sure that you get more boings than I do, you lucky divil! :-)

4:33 PM

@Vérace-getVACCINATEDNOW Thanks

(DOINK)