worldofpeace changed the topic of #nixos-dev to: NixOS Development (#nixos for questions) | NixOS 20.09 Nightingale ✨ https://discourse.nixos.org/t/nixos-20-09-release/9668 | https://hydra.nixos.org/jobset/nixos/trunk-combined https://channels.nix.gsc.io/graph.html | https://r13y.com | 20.09 RMs: worldofpeace, jonringer | https://logs.nix.samueldr.com/nixos-dev
pinpox has quit [Quit: The Lounge - https://thelounge.chat]
pinpox has joined #nixos-dev
bennofs__ has joined #nixos-dev
bennofs_ has quit [Ping timeout: 240 seconds]
pinpox has quit [Ping timeout: 246 seconds]
supersandro2000 has quit [Disconnected by services]
supersandro2000 has joined #nixos-dev
<gchristensen> 1701 out of 1704 (99.82%) paths in the minimal installation image are reproducible! -- https://r13y.com/
tilpner_ has joined #nixos-dev
<supersandro2000> How can I build the same binary twice and not get the same result?
<gchristensen> a common one is embedding th etime
<supersandro2000> etime?
<supersandro2000> compile time?
<gchristensen> the time
<gchristensen> yea
<gchristensen> or details about the host, like cpu features
<supersandro2000> embedding details about the host makes sense to me
tilpner_ is now known as tilpner
<gchristensen> a less common but more interesting reason might be that one of your build machines is compromised
<samueldr> could be filesystem access
<samueldr> listing files has no guaranteed order
<gchristensen> ahnd apparently isn't even guaranteed to be complete ...
<samueldr> I think there is no guarantee at all :)
<samueldr> hmm, in the kernel build
<samueldr> > NT_GNU_BUILD_ID·​(unique·​build·​ID·​bitstring
<{^_^}> error: syntax error, unexpected $undefined, expecting ')', at (string):471:16
<gchristensen> POSIX™
<samueldr> hopefully it's not *that* NT
<samueldr> everything else in vmlinux seems... like random stuff, hard to tell without more context :)
<gchristensen> in this case NT stands for Not That
<samueldr> Notes
<samueldr> they're Notes
<gchristensen> ehh weird
<gchristensen> r13y.com is showing an old page
<gchristensen> the linux issue is fixed already samueldr
<samueldr> oh, neat!
<gchristensen> looking with curl it is always returning th ecurrent page but the browser is always showinh the old one ...
<supersandro2000> > Generated at 2020-12-17 05:24:53.679645676 UTC from https://github.com/grahamc/r13y.com.
<{^_^}> error: syntax error, unexpected ':', expecting ')', at (string):471:27
<supersandro2000> what version are you getting?
rajivr has joined #nixos-dev
<samueldr> refreshed a bunch and it updated
Emantor has quit [Quit: ZNC - http://znc.in]
Emantor has joined #nixos-dev
<siraben> What's ofborg-internal-error?
<samueldr> error happened inside ofborg while borging on the PR
<samueldr> mainly it'S for ofborg handlers to look for errors
<siraben> Ah
<gchristensen> I'd like to expand the team of handlers, btw
<gchristensen> cole-\h has been doing really great, and I'd love for there to be others
ajs124 has joined #nixos-dev
Scriptkiddi has joined #nixos-dev
das_j has joined #nixos-dev
orivej has joined #nixos-dev
cole-h has joined #nixos-dev
<cole-h> Just FYI: starting the process to redploy ofborg right now. I expect no interruptions, but, well, not everything goes as planned :)
<cole-h> Deploy succeeded, nothing out of the ordinary to report.
srk has quit [Ping timeout: 268 seconds]
srk has joined #nixos-dev
<siraben> yay, 99.82% reproducible!
cole-h has quit [Ping timeout: 240 seconds]
* energizer glances warily at linux-5.4.83.drv
<energizer> (if you measure by mass instead of count it's probably a lot lower)
<samueldr> energizer: refresh harder
<samueldr> no linux kernel on r13y
<samueldr> only 3 unreproduced paths
pinpox has joined #nixos-dev
<energizer> i refreshed as hard as i know how to
<energizer> it's still there
<samueldr> :/ things were iffy earlier yesterday too
<samueldr> cache is hard
<energizer> i was gonna fiddle with one of the nonrepro packages but i couldn't figure out how to build it on my computer
<energizer> is there a way to ask nix to give me the shell whose builder builds $path, and then tell it to go ahead and build it
<symphorien[m]> genericBuild is the command
<symphorien[m]> It will fail at installPhase
<energizer> i tried that but it didn't produce the path. i can show you
<energizer> b7m9y5mxvi54bxhl8j75rxhmfrnj2m07-python3.8-pytest-6.1.2 is one of the paths on r13y. nix-shell $(nix-store -q --deriver b7m9y5mxvi54bxhl8j75rxhmfrnj2m07-python3.8-pytest-6.1.2) does not exist and cannot be created
<energizer> er
<energizer> b7m9y5mxvi54bxhl8j75rxhmfrnj2m07-python3.8-pytest-6.1.2 is one of the paths on r13y. nix-shell $(nix-store -q --deriver /nix/store/b7m9y5mxvi54bxhl8j75rxhmfrnj2m07-python3.8-pytest-6.1.2) does not exist and cannot be created
<energizer> so i tried pulling master and running nix-shell -A python3Packages.pytest but that doesn't produce those files either
<energizer> (running genericBuild)
<energizer> i tried with --pure too
<energizer> on the other hand, the whole point is that it's not reproducible so maybe i shouldn't be surprised :)
<energizer> or maybe now it is reproducible but the website is out of date
<samueldr> /nix/store/b868lksw92p11q58is56n2im1jqczwh4-python-2.7.18.drv
<samueldr> /nix/store/i7qdqmczv6snsma32zl8sn0qvcw4g2ax-python3-3.8.7.drv
<samueldr> /nix/store/p2npkl8klp19a0cqrpxqja8sqzzm0sqx-gcc-10.2.0.drv
<samueldr> the full list
<energizer> ah then someone already fixed what i was trying to fiddle with
<samueldr> it it's more inconsistent than irreproducible :)
<samueldr> or it*
bgamari has quit [Remote host closed the connection]
bgamari has joined #nixos-dev
bgamari has quit [Remote host closed the connection]
bgamari has joined #nixos-dev
<siraben> 20 days after our initial discussion to deprecate stdenv.lib, we are almost done ridding it in Nixpkgs
<siraben> some new instances were re-introduced in 3 packages
<siraben> qyliss's site shows only 10 remain: (2 in documentation) https://edef.eu/~qyliss/nix/lib/
<edef> i wonder if we could actually remove it anytime soon without breaking stuff for third-party Nix code
<edef> i guess we can add a deprecation trace
<siraben> Just opened a PR to remove the last remaining traces: #111284
<{^_^}> https://github.com/NixOS/nixpkgs/pull/111284 (by siraben, 20 seconds ago, open): treewide: remove lib from stdenv
<siraben> i did the removal just to check via ofborg for implicit use
Jackneill has joined #nixos-dev
<siraben> Are we going to put a `trace`, `throw`, or what?
<siraben> cc worldofpeace
<siraben> I think early January people here said to trace
<ekleog> IMO trace for at least one release then throw for at least one release
<worldofpeace> what he said siraben
<worldofpeace> lol
<siraben> mmhm
<siraben> How does "Warning: `stdenv.lib` is deprecated and will be removed in the next release. Please use `pkgs.lib` instead" sound?
<siraben> (with backticks surrounding stdenv.lib and pkgs.lib)
<siraben> force-pushed
<worldofpeace> should be good
<worldofpeace> siraben: u have to do `builtins.` it seems
<worldofpeace> `builtins.trace`
<siraben> worldofpeace: thanks
sphalerite has joined #nixos-dev
<siraben> Why when I have the trace does evaluating `stdenv.lib.optional` not trigger it?
<rnhmjoj> <siraben "How does "Warning: `stdenv.lib` "> can you also add a link to the nixpkgs issue (#108938)?
<{^_^}> https://github.com/NixOS/nixpkgs/issues/108938 (by siraben, 2 weeks ago, open): Deprecate use of stdenv.lib across Nixpkgs
<rnhmjoj> the reason for the deprecation is too long to be included in the error message but a link should do it
<siraben> ok
janneke_ is now known as janneke
<siraben> Oh god, `nixos/doc/manual/release-notes/rl-2103.xml` is in DocBook
<rnhmjoj> if you're allergic to xml, just type it out in markdown and use pandoc to convert it
<supersandro2000> Can we somehow make ofborg fail if stdenv.lib is used but not other things?
<Mic92> I would rather add it here:
__monty__ has joined #nixos-dev
<ekleog> FWIW, IIRC adding a trace will make hydra fail if stdenv.lib is used
<gchristensen> anyone familiar with perl? https://github.com/NixOS/hydra/blob/master/src/lib/Hydra/Controller/Root.pm#L441-L442 produces "Use of uninitialized value $limit in string eq at" in the empty case. is there a way to check that without an error?
<aminechikhaoui> If (defined $limit) ? I don’t know perl, just from looking at the log function a bit down in that file
<gchristensen> hmm it looks like I could also do my $limit = trim $c->request->params->{"limit"} || 500;
<siraben> worldofpeace: edited the release notes in the PR
<gchristensen> if anyone familiar with perl is around: https://github.com/NixOS/hydra/pull/853 <- this is fixing an issue causing hydra to be visibly (but not totally) down
<{^_^}> hydra#853 (by grahamc, 2 minutes ago, open): search: limit results to 50, default to 10
<supersandro2000> I just realized why my nixpkgs-review hangs
<supersandro2000> it asks hydra about the packages....
<gchristensen> hopefully this PR doesn't damage it in aty way
<{^_^}> firing: RootPartitionLowDiskSpace: https://monitoring.nixos.org/prometheus/alerts
teto has joined #nixos-dev
orivej has quit [Ping timeout: 265 seconds]
orivej has joined #nixos-dev
<jtojnar> supersandro2000: can we make it throw when config.allowAliases is false?
<jtojnar> siraben^
<siraben> Jan Tojnar: sure
<jtojnar> also we should probably rename xdg_utils to use dash https://discourse.nixos.org/t/flaw-in-nix-integration-of-stack/11288/5?u=jtojnar
<siraben> ok, good candidate for another treewide
orivej has quit [Ping timeout: 272 seconds]
cole-h has joined #nixos-dev
<gchristensen> anyone querying hydra for pkgs.chromium in a loop?
zhaofeng has joined #nixos-dev
prusnak has joined #nixos-dev
<gchristensen> aszlig: can you replace this link to a direct jobset link?
tilpner has quit [Quit: tilpner]
tilpner has joined #nixos-dev
alunduil has quit [Ping timeout: 260 seconds]
nh2 has quit [Ping timeout: 260 seconds]
catern has joined #nixos-dev
eyJhb has joined #nixos-dev
eyJhb has joined #nixos-dev
nh2 has joined #nixos-dev
alunduil has joined #nixos-dev
betawaffle has joined #nixos-dev
<gchristensen> andi-: any chance I could get another thumb? :) https://github.com/NixOS/hydra/pull/854/files?w=1
<gchristensen> or anyone, really, with some amount of experience with hydra, and-or perl, and-or postgresql https://github.com/NixOS/hydra/pull/854
<{^_^}> hydra#854 (by grahamc, 2 minutes ago, open): search: limit queries to 20s
<supersandro2000> siraben: I also saw someone who might do python = python3 removals. Maybe something for you in the future if it isn't done in a few weeks
abathur has quit [Quit: abathur]
<gchristensen> most web queries 200ms, evaluator 150ms, queue runner 800ms, search page 500,000ms, notify 150ms someone who is good at reviewing pull requests please help me mereg this. my family is dying
<andi-> gchristensen: sure, looking
<gchristensen> thank you :D
<gchristensen> hopefully this handles it for today, I have a lot of chores to do ;_
<andi-> gchristensen: you have a comment I forgot to make that a new review but please add the LOCAL there unless I read the postgresql docs wrong
<gchristensen> replied and fixed
<lukegb> http://tarballs.nixos.org/keen4.zip is dead, though
<gchristensen> andi-: may I get a final check and possibly thumb?
<andi-> gchristensen: one more nit: the semicolon after the statement is likely not needed as the statement is already closed. Usually you only need that on the sql console or for multiple statements. Does this ORM treat it differently?
<gchristensen> andi-: the examples I found in the repo used semis
<gchristensen> not all do though
<andi-> ok, i'll set that slip :D
<gchristensen> I dropped the ; and fixed lukegb's comment too
<gchristensen> I also tried a $c->model('DB')->schema->storage->dbh->do("SELECT pg_sleep(21)"); to double check it worked :)
<lukegb> Nice, thanks 😀
<gchristensen> another round of thumbs? thank you both, this has been meaningfully useful and I'm glad for it
<andi-> Thumbs-as-a-Service
<clever> and i just filled a pr to fix thumb mode in arm-embedded, lol
<andi-> You can book the IRC2Thumbs extra for just $9.99
<gchristensen> lol
<andi-> gchristensen: wait, since when doesn't hydra CI run the ldap test etc?
<gchristensen> I don't know :(
<andi-> ahh, it requires KVM and SH Actions doesn't support that.
<gchristensen> woohoo, those terrible queries are killed
<gchristensen> thank you both, andi- + lukegb !
<andi-> thank you for doing something about it
<gchristensen> gotta keep the community unblocked :)
<andi-> Would be interesting to know what people are commonly searching for
<andi-> once we know that we can just remove the derviation or jobset or outputname or whatever search feature
<andi-> maybe nobody is using the search due to the performance -> we can do anything!!! :D
<gchristensen> just pkgs.chromium afaict, back in an hour or so we can look at more logs together :)
<gchristensen> https://monitoring.nixos.org/grafana/d/5LANB9pZk/per-instance-metrics?orgId=1&refresh=30s&var-instance=haumea:9100&from=now-6h&to=now metrics starting at 17:00UTC is nice to see
cole-h has quit [Ping timeout: 240 seconds]
mkaito has joined #nixos-dev
mkaito has joined #nixos-dev
mkaito has quit [Changing host]
mkaito_ has joined #nixos-dev
mkaito has quit [Ping timeout: 264 seconds]
<aszlig> gchristensen: ah... since i no longer maintain chromium i guess the whole entry is old, but i don't know how to change that
<aszlig> (at least not anymore)
mkaito_ has quit [Quit: WeeChat 3.0]
rajivr has quit [Quit: Connection closed for inactivity]
mkaito has joined #nixos-dev
<pie_> This seems split-brain to me?: https://github.com/NixOS/nixpkgs/blob/2a07b6eb73af29990df035096d33b01b3edd8176/nixos/modules/installer/netboot/netboot.nix#L78 It inherits the compressor but then assumes its squashfs?
<pie_> or is that orthogonal and the squashfs image is used later?
<lukegb> I think it takes the (uncompressed) initial initrd and then adds the squashfs image to it, then recompresses the whole thing
<pie_> that double compression sounds funky
<pie_> (what Im trying to do is make the squashfs step faster because its really bogging down my iteration speed)
<lukegb> didn't gchristensen do something for making iteration faster there
<pie_> i managed to change the squashfs compression options but it still seems too slow so im trying to turn compression off alltogether, it's only 2 gigs.
<lukegb> "netboot.nix: 15 second netboot iterations"
<pie_> I think he did do something but I didn't get anywhere last I looked at it (long ago). It's probably worth another look.
<pie_> Yeah OK I should probably figure that out.
<pie_> Any idea what the magic is? recursive nix by itself doesnt really explain anything.
<{^_^}> firing: RootPartitionLowDiskSpace: https://monitoring.nixos.org/prometheus/alerts
<pie_> hmm but i dont want to try enabling nixUnstable. When did recursive nix get added? I seem to be on 2.3.1
<pie_> My system is probably due some upgrades.
<pie_> lukegb: is recursive nix even in stable?
<lukegb> pie_: no idea :(
<pie_> rather, does the "experimental-features" config option exist in 2.3.x?
<pie_> Looks like this might not help me for now.
<lukegb> Proooobably not.
<lukegb> Some of the options might, like changing the compressor, but the entire thing is unlikely to be helpful for you as is :p
<pie_> Is there some filesystem that can be mounted via a loop device that I can somehow archive a directory into, that isnt squashfs?
<pie_> none of these https://github.com/NixOS/nixpkgs/tree/master/nixos/lib quite seem to have the interface make-squashfs does
<__monty__> makeWrapper's use of `exec -a` is failing me (on macOS). Would changing it to use a C wrapper maybe be an option (to get access to execle and friends)?
<gchristensen> makeWrapper should use nixpkgs's own bash, not sure how it could be a problem?
<gchristensen> aszlig: can you take a look in to fixing the link? it is causing quite a lot of load, even with the mitigations
<__monty__> gchristensen: I'm not sure how it could be a problem either but I'm still running into it : )
<gchristensen> __monty__: is the thing you're exec'ing a script?
<__monty__> Yes.
<samueldr> gchristensen: one of the problems is that it's using the bash from the "nativeBuildInputs", but maybe not __monty__'s
<__monty__> Ah, so exec -a is setting bash's $0?
<gchristensen> __monty__: is the thing that is being exec'd have a shebang which is pointing to a script?
<aszlig> gchristensen: a jobset however would
<aszlig> ... have the issue that it's systemd-dependant
<__monty__> The shebang is "env bash" but replaced by the bash in the store of course.
<samueldr> with makeWrapper it's actuall @shell@ replaced by runtimeShell, no?
<gchristensen> https://gist.github.com/grahamc/d4fb7e791f5edc1e9db6d4ca9cf3ff88 for whatever reason several systems are fetching that search page super often
<__monty__> This is the shebang of the wrapped script "#!/nix/store/fb2pkc446jgwxn98hgabhsjkj7scb57y-bash-4.4-p23/bin/bash"
<samueldr> and @shell@ comes from all-packages.nix, cannot link
grfn has joined #nixos-dev
feepo has joined #nixos-dev
<__monty__> I don't think the wrapped script's shebang poses a problem though. Is my understanding correct that the wrapper really invokes bash when it tries to execute the script and so `exec -a` is setting bash's $0?
<samueldr> plausible
<samueldr> if it's not running the exectuable, and/or being wrapped multiple times
<samueldr> (note that you didn't say what "failing me" meant recently)
<samueldr> if it's about not renaming the child process, that sounds about right
<samueldr> if you have e.g. foo -> .foo-wrapped -> your-own-wrapper -> actual-exec
<samueldr> or uh, even .foo-wrapped being your-own-wrapper
<samueldr> (or another makeWrapper wrapper)
<gchristensen> aszlig: if it pointed to https://hydra.nixos.org/search?query=chromium it would be able to complete without kicking off a 500s uery
<aszlig> gchristensen: yeah, but only because it hits the limit
<pie_> Wow there is a lot of copying in this proces. Theres at least like, 3-4 round trips through the disk.
<pie_> And its not even like I can put it in a ramdisk because nix store?
<tilpner> If the entire closure fits into your ramdisk, you can change the entire store location
<gchristensen> I assumed you wanted the query to return results :/
<pie_> tilpner: maybe.
<tilpner> I used lz4 compression for the squashfs, when I needed quicker loops
<pie_> Yeah I just switched to doing that but its taking forever to build the initrd too.
<pie_> Im not sure I didn't make it slower somehow.
teto has quit [Ping timeout: 260 seconds]
<tilpner> Ahh, my initrd had two files
<pie_> With this the initrd is 3.2 gigs and takes 15 minutes https://bpa.st/6VSXU (i dont even know if this will run yet)
<tilpner> Why is your initrd that large?
<pie_> its the netboot installer or something
<pie_> hm still. good question
<pie_> Yeah, how big is netboot-minimal?
justanotheruser has quit [Ping timeout: 265 seconds]
aminechikhaoui has joined #nixos-dev
<pie_> Im timing the normal process right now.
teto has joined #nixos-dev
AlwaysLivid has joined #nixos-dev
<sphalerite> energizer: re what you said in #nixos-chat: nice that you're taking a look! bz2 can take streamed input, so the file may very well be created and then gradually filled — even if it's compressed.
<__monty__> samueldr: No, it's just a bash script with a shebang and a single wrapper. The bash script uses $0 in help output for example and that's rendered as ".nb-wrapped", which is confusing as the user never called ".nb-wrapped".
<energizer> sphalerite: ah, nice
<samueldr> __monty__: would it be fair to ask "does bash respect argv0 being replaced in scripts?"
<samueldr> and is it really macOS specific?
<samueldr> (not trying to dismiss your issue, I see it)
<samueldr> can you check the output of `ps` or similar if argv0 is replaced when running that bash script from the wrapper? maybe add sleep 100 or something to the help command
<samueldr> I'm curious if it's really something like bash doesn't care about argv[0] and always uses some other value for $0
justanotheruser has joined #nixos-dev
<pie_> tilpner: with the default config it takes 22 minutes...
<pie_> so that only shaved off 7 minutes or so
<pie_> Hm. I guess I could try making this part smaller and setting a remote builder.
<__monty__> samueldr: What I think is happening is that bash's $0 is changed but bash has no reason to pass that on to the script, it sets $0 to the name or path it was passed.
<samueldr> just looked on my Linux, a pure bash repro
<samueldr> and yeah, $0 with -a is not set to the arbitrary value I passed
<samueldr> exec -a my-utility bash -c 'echo I AM $0' # is fine though
<samueldr> I'm pretty sure a C wrapper wouldn't change the behaviour, since it seems to be on the callee that it happesn
<samueldr> happens*
<samueldr> (I could be wrong)
<__monty__> Yes, I agree. I was misunderstanding the problem. I figured somehow I was using my system's bash, which is too old for the -a flag I think. Hence reaching for a C wrapper.
<__monty__> Thanks for working through this with me. I think I'll PR adding a note in the docs to mention that makeWrapper has this interaction with scripts.
<__monty__> And I'll just patch the script to hardcode the proper name.
<samueldr> n/p, it's also nice to have an answer about it, since that's the kind of things I see all over, Usage: .whatever-wrapped
<__monty__> Ah, I was thinking "Just my luck that no one's run into this before >.<" : D
<__monty__> I'll give this another think though, maybe there *is* a nice, general solution.
<samueldr> ran into this as a user, didn't look further :)
<samueldr> gchristensen: yeah, I was almost certain _that_ index type wouldn't help enough
<samueldr> but I never had heard of it before taking a stroll through the whole irc logger code base
<gchristensen> there are only so many index types :P
<__monty__> Btw, could the urls on the package search page be made to stand out a little more? I had a hard time realizing they were even there and even now I really need to look for them. I'm talking about "source" et al. The hydra jobset urls stand out a lot more.
<samueldr> I think the `gin` function is part of the magic
<samueldr> (which AFAIUI is really a thing that works only with "dictionaries")
<samueldr> (like words)
<__monty__> Not sure this is the appropriate channel for this. Feel free to point me at a more appropriate one : )
<samueldr> appropriate enough
<samueldr> if you can give details about how you'd fix it, an issue on the nixos-search repo would be how to progress with that
<gchristensen> let's see what happens: hydra=> CREATE INDEX expIndexBuildOutputsPathGin ON BuildOutputs USING GIN(to_tsvector('english', regexp_replace(path, '[\./-]', ' ', 'g')));
<samueldr> gchristensen: note that I don't know (yet) what gin is
<samueldr> literally just opened a doc page :)
<gchristensen> :) yeah I've been reading the docs since you commented
<samueldr> sorry for nerd-sniping you :)
<gchristensen> not at all
<gchristensen> I have fast hard drives now, might as well put them to good use :)
<__monty__> Ah, I see NixOS/nixos-search#280 already exists : )
<{^_^}> https://github.com/NixOS/nixos-search/issues/280 (by mintchaos, 2 days ago, open): UX improvement: Links in search results.
<samueldr> maybe you have more input about it? :)
<samueldr> (I haven't been following the latest developments of nixos-search really)
<__monty__> The OP already mentions styling. I don't think more than an underline and a different color is necessary. Maybe homepage and source could stand out more than license for example but that's minor and probably subjective.
abathur has joined #nixos-dev
pmy_ has joined #nixos-dev
pmy has quit [Ping timeout: 272 seconds]
<{^_^}> firing: RootPartitionLowDiskSpace: https://monitoring.nixos.org/prometheus/alerts
<energizer> sphalerite: can i get nix to send the build logs to stdout or syslog?
mkaito has quit [Quit: WeeChat 3.0]
orivej has joined #nixos-dev
<gchristensen> okay wow samueldr
<gchristensen> changing the query from WHERE ( buildoutputs.path ILIKE "%pkgs.chromium%" ) to WHERE ( to_tsvector('english', regexp_replace(buildoutputs.path, '[\./-]', ' ', 'g')) @@ plainto_tsquery('english', regexp_replace('pkgs.chromium', '[\./-]', ' ', 'g')) ) gets (no) results in 4ms
<gchristensen> plainto_tsquery makes pkgs.chromium in to 'pkgs' & 'chromium' and since we don't use "pkgs" it doesn't ever match
<{^_^}> resolved: RootPartitionLowDiskSpace: https://monitoring.nixos.org/prometheus/alerts
<samueldr> gchristensen: meaning it's better?
<gchristensen> searching for pkgs.chromium before took 500+s
<gchristensen> ie, 500,000+ms
<samueldr> right, the 'we don't use "pkgs"' threw me off
<samueldr> and is that with an index or just plain tacked onto the where?
<samueldr> I'm not a DBA so...
<gchristensen> with an index matching the left part of the WHERE, before the @@
<samueldr> ah right, so it is better, but not "good"
<samueldr> I'm not even sure the text search vector things with "english" is desired
<samueldr> but maybe GIN with some regex is?
<gchristensen> it needs a language I think
<samueldr> I mean maybe it's not wanted at all
<gchristensen> ah
<samueldr> since IIRC from reading a few years back it was really made for languages
<samueldr> package names are not really languages
<gchristensen> maybe tsvector is not needed
<samueldr> (btw, I have no clue really, just bouncing stuff)
<gchristensen> on the other hand, it is behaving like a reasonable search engine
<gchristensen> searching for "poppler 0.16" is getting reasonable results, in ~400ms
<gchristensen> of course convincing dbix to run this query is another matter :/
mkaito has joined #nixos-dev
mkaito has joined #nixos-dev
mkaito has quit [Changing host]
__monty__ has quit [Quit: leaving]
stolyaroleh_ has joined #nixos-dev