Your message dated Thu, 19 Jan 2023 21:59:26 +0100 with message-id <284421db3ae1b2f206bfd672d7b6328cfef7d2bd.camel@cilg.org> and subject line Re: snapshot db: add a multi-column index for the srcpkg table? has caused the Debian Bug report #686907, regarding snapshot db: add a multi-column index for the srcpkg table? to be marked as done. This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact owner@bugs.debian.org immediately.) -- 686907: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=686907 Debian Bug Tracking System Contact owner@bugs.debian.org with problems
--- Begin Message ---
- To: bts <submit@bugs.debian.org>
- Subject: snapshot db: add a multi-column index for the srcpkg table?
- From: Paul Wise <pabs@debian.org>
- Date: Fri, 07 Sep 2012 12:05:42 +0800
- Message-id: <1346990741.20545.42.camel@chianamo>
Package: snapshot.debian.org Severity: wishlist While profiling the derivatives census source package script, I noticed that the index on the snapshots srcpkg table is by name only and I wonder if a multi-column index on [name, version] would be a good idea? The compare-source-package-list script currently always uses both name and version in queries so this would probably speed up the checks that discover which source package to diff against. -- bye, pabs http://wiki.debian.org/PaulWiseAttachment: signature.asc
Description: This is a digitally signed message part
--- End Message ---
--- Begin Message ---
- To: 686907-done@bugs.debian.org
- Subject: Re: snapshot db: add a multi-column index for the srcpkg table?
- From: Baptiste Beauplat <lyknode@cilg.org>
- Date: Thu, 19 Jan 2023 21:59:26 +0100
- Message-id: <284421db3ae1b2f206bfd672d7b6328cfef7d2bd.camel@cilg.org>
- In-reply-to: <1346990741.20545.42.camel@chianamo>
- References: <1346990741.20545.42.camel@chianamo>
On Fri, 07 Sep 2012 12:05:42 +0800 Paul Wise <pabs@debian.org> wrote: > While profiling the derivatives census source package script, I noticed > that the index on the snapshots srcpkg table is by name only and I > wonder if a multi-column index on [name, version] would be a good idea? > The compare-source-package-list script currently always uses both name > and version in queries so this would probably speed up the checks that > discover which source package to diff against. This has been fix in 2018 by adding a unique constraint over (name, version) on srcpkg [1]. [1]: https://salsa.debian.org/snapshot-team/snapshot/-/commit/2e862c7821e46a5e2650a886e0d9093f6bce8fc3 -- Baptiste BeauplatAttachment: signature.asc
Description: This is a digitally signed message part
--- End Message ---