the only difference I see is that JOIN does an INDEX SCAN while EXISTS does INDEX ONLY SCAN. and this is causing 2X speedup in exists.
2021-06-10 16154, 2021
lucifer
but this is the first query when PG has zero cache. subsequent queries are blazing fast in either case.
2021-06-10 16146, 2021
alastairp
lucifer: hmm
2021-06-10 16151, 2021
alastairp
sorry, I'm working on some other projects
2021-06-10 16149, 2021
ruaok
what is the question you two are trying to answer?
2021-06-10 16152, 2021
alastairp
I believe that postgres will often do stuff like look for the "big" table and the "small" one, and do an index scan on the big one and seq scan in the other one
2021-06-10 16150, 2021
lucifer
Curresnt summary is directly accesing MB is twice faster than using imported data in the worst case
maybe split it into 8-10 categories of 1000-1200 mbids each
2021-06-10 16138, 2021
alastairp
import the dataset
2021-06-10 16153, 2021
alastairp
then use the data from here as the candidate list of MBIDs to join against
2021-06-10 16130, 2021
lucifer
ah ok, so join the dataset with entire MB data?
2021-06-10 16139, 2021
alastairp
yep
2021-06-10 16107, 2021
lucifer
i already have your Last.fm dataset imported so that part is done :). i'll just use that.
2021-06-10 16113, 2021
alastairp
perfect
2021-06-10 16153, 2021
Sophist_UK joined the channel
2021-06-10 16153, 2021
Sophist_UK has quit
2021-06-10 16153, 2021
Sophist_UK joined the channel
2021-06-10 16145, 2021
Sophist-UK has quit
2021-06-10 16156, 2021
Sophist-UK joined the channel
2021-06-10 16156, 2021
Sophist-UK has quit
2021-06-10 16156, 2021
Sophist-UK joined the channel
2021-06-10 16136, 2021
Sophist_UK has quit
2021-06-10 16130, 2021
Sophist_UK joined the channel
2021-06-10 16130, 2021
Sophist_UK has quit
2021-06-10 16130, 2021
Sophist_UK joined the channel
2021-06-10 16103, 2021
Sophist-UK has quit
2021-06-10 16111, 2021
monkey
alastairp : I'm off Wednesday next week; wanna do office day on Tuesday instead?
2021-06-10 16158, 2021
alastairp
actually, I'm also off on wednesday, got the trompa presentation. tuesday might not be a good idea because I'm sure everyone is going to be panicking the last day before... how is thursday for you?
2021-06-10 16147, 2021
monkey
Works for me
2021-06-10 16155, 2021
Sophist-UK joined the channel
2021-06-10 16155, 2021
Sophist-UK has quit
2021-06-10 16155, 2021
Sophist-UK joined the channel
2021-06-10 16155, 2021
Sophist_UK has quit
2021-06-10 16122, 2021
Sophist_UK joined the channel
2021-06-10 16122, 2021
Sophist_UK has quit
2021-06-10 16122, 2021
Sophist_UK joined the channel
2021-06-10 16100, 2021
Sophist-UK has quit
2021-06-10 16124, 2021
BrainzGit
[musicbrainz-server] 14reosarevok opened pull request #2142 (03beta…direction-backwards-hotfix): Fix getDirection -> isBackward to match other direction changes https://github.com/metabrainz/musicbrainz-server/…
2021-06-10 16130, 2021
reosarevok
bitmap: ^
2021-06-10 16145, 2021
bitmap
thanks!
2021-06-10 16152, 2021
BrainzGit
[musicbrainz-server] 14reosarevok merged pull request #2142 (03beta…direction-backwards-hotfix): Fix getDirection -> isBackward to match other direction changes https://github.com/metabrainz/musicbrainz-server/…
