<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/gitlab/gitlab-ce.git/db/migrate, branch document-lambda-deploy</title>
<subtitle>gitlab.com: gitlab-org/gitlab-ce.git
</subtitle>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/gitlab/gitlab-ce.git/'/>
<entry>
<title>New interruptible attribute supported in YAML parsing.</title>
<updated>2019-09-05T14:50:39+00:00</updated>
<author>
<name>Cédric Tabin</name>
<email>tabin.cedric@gmail.com</email>
</author>
<published>2019-09-05T14:50:39+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/gitlab/gitlab-ce.git/commit/?id=e195e48638dcc56609436e6fcdd9ad3521501798'/>
<id>e195e48638dcc56609436e6fcdd9ad3521501798</id>
<content type='text'>
Since it is not possible to dynamically detect if a job is automatically
cancellable or not, a this new attribute is necessary. Moreover, it let
the maintainer of the repo to adjust the behaviour of the auto cancellation
feature to match exactly what he needs.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Since it is not possible to dynamically detect if a job is automatically
cancellable or not, a this new attribute is necessary. Moreover, it let
the maintainer of the repo to adjust the behaviour of the auto cancellation
feature to match exactly what he needs.
</pre>
</div>
</content>
</entry>
<entry>
<title>Add structure to support EE feature of COAR</title>
<updated>2019-09-05T13:01:36+00:00</updated>
<author>
<name>Kerri Miller</name>
<email>kerrizor@kerrizor.com</email>
</author>
<published>2019-09-05T13:01:36+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/gitlab/gitlab-ce.git/commit/?id=0e40b41e224f18076426578da08548ae22afdcd1'/>
<id>0e40b41e224f18076426578da08548ae22afdcd1</id>
<content type='text'>
These are the structural changes for supporting the EE feature of moving
"code_owner_approval_required" state from existing on a project to being
on the protected branches individually, allowing for CODEOWNER
validation on push events.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
These are the structural changes for supporting the EE feature of moving
"code_owner_approval_required" state from existing on a project to being
on the protected branches individually, allowing for CODEOWNER
validation on push events.
</pre>
</div>
</content>
</entry>
<entry>
<title>Merge branch 'ab/unconfirmed-email-index' into 'master'</title>
<updated>2019-09-05T07:12:46+00:00</updated>
<author>
<name>Andreas Brandl</name>
<email>abrandl@gitlab.com</email>
</author>
<published>2019-09-05T07:12:46+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/gitlab/gitlab-ce.git/commit/?id=8e6ff65541f5591074934358d09781e6f082152c'/>
<id>8e6ff65541f5591074934358d09781e6f082152c</id>
<content type='text'>
Create index for users.unconfirmed_email

See merge request gitlab-org/gitlab-ce!32664</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Create index for users.unconfirmed_email

See merge request gitlab-org/gitlab-ce!32664</pre>
</div>
</content>
</entry>
<entry>
<title>Create index for users.unconfirmed_email</title>
<updated>2019-09-04T18:04:34+00:00</updated>
<author>
<name>Andreas Brandl</name>
<email>abrandl@gitlab.com</email>
</author>
<published>2019-09-04T17:33:18+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/gitlab/gitlab-ce.git/commit/?id=7a890ae9ba053835d0bcb6473bdb3b1972dc882b'/>
<id>7a890ae9ba053835d0bcb6473bdb3b1972dc882b</id>
<content type='text'>
This speeds up the following query:

```sql
SELECT  users.* FROM users WHERE users.unconfirmed_email = ? ORDER BY
users.id ASC LIMIT 1
```

Presumably, this is a query coming from Devise.

Context is https://gitlab.com/gitlab-org/gitlab-ce/issues/66958.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
This speeds up the following query:

```sql
SELECT  users.* FROM users WHERE users.unconfirmed_email = ? ORDER BY
users.id ASC LIMIT 1
```

Presumably, this is a query coming from Devise.

Context is https://gitlab.com/gitlab-org/gitlab-ce/issues/66958.
</pre>
</div>
</content>
</entry>
<entry>
<title>Create partial index for gitlab-monitor CI metrics</title>
<updated>2019-09-04T11:43:51+00:00</updated>
<author>
<name>Andreas Brandl</name>
<email>abrandl@gitlab.com</email>
</author>
<published>2019-09-02T15:26:15+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/gitlab/gitlab-ce.git/commit/?id=bd56acd37814933e5fb51f1fe1adce6171532979'/>
<id>bd56acd37814933e5fb51f1fe1adce6171532979</id>
<content type='text'>
This creates a partial index intended to speed up queries on
`ci_builds`. Particularly, `gitlab-monitor` has rather heavy queries.
Those have been changed to only look back 7 days and benefit from this
index tremendously.

Relates to
https://gitlab.com/gitlab-org/gitlab-exporter/merge_requests/101.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
This creates a partial index intended to speed up queries on
`ci_builds`. Particularly, `gitlab-monitor` has rather heavy queries.
Those have been changed to only look back 7 days and benefit from this
index tremendously.

Relates to
https://gitlab.com/gitlab-org/gitlab-exporter/merge_requests/101.
</pre>
</div>
</content>
</entry>
<entry>
<title>Create an event on epic actions</title>
<updated>2019-09-03T21:29:55+00:00</updated>
<author>
<name>Jan Provaznik</name>
<email>jprovaznik@gitlab.com</email>
</author>
<published>2019-09-03T21:29:55+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/gitlab/gitlab-ce.git/commit/?id=243bd0202fe3373a997f5ed37c027ab8cfdfcb35'/>
<id>243bd0202fe3373a997f5ed37c027ab8cfdfcb35</id>
<content type='text'>
Creates new event when an epic is created, closed, reopened or
commented.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Creates new event when an epic is created, closed, reopened or
commented.
</pre>
</div>
</content>
</entry>
<entry>
<title>Added relationships between Release and Milestone</title>
<updated>2019-09-03T09:38:59+00:00</updated>
<author>
<name>Etienne Baqué</name>
<email>ebaque@gitlab.com</email>
</author>
<published>2019-09-03T09:38:59+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/gitlab/gitlab-ce.git/commit/?id=a43ab8d6a430014e875deb3bff3fd8d8da256747'/>
<id>a43ab8d6a430014e875deb3bff3fd8d8da256747</id>
<content type='text'>
Modified schema via migrations.
Added one-to-one relationship between the two models.
Added changelog file
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Modified schema via migrations.
Added one-to-one relationship between the two models.
Added changelog file
</pre>
</div>
</content>
</entry>
<entry>
<title>Add not null constraints to prometheus_metrics table columns</title>
<updated>2019-09-03T04:41:19+00:00</updated>
<author>
<name>Arun Kumar Mohan</name>
<email>arunmohandm@gmail.com</email>
</author>
<published>2019-08-28T11:18:03+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/gitlab/gitlab-ce.git/commit/?id=ab60775216e6d23ec7ee8a580793b5b3fa92f6f9'/>
<id>ab60775216e6d23ec7ee8a580793b5b3fa92f6f9</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Replace indexes for counting active users</title>
<updated>2019-09-02T13:22:32+00:00</updated>
<author>
<name>Andreas Brandl</name>
<email>abrandl@gitlab.com</email>
</author>
<published>2019-09-02T13:15:26+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/gitlab/gitlab-ce.git/commit/?id=5b4108f0fd68956ff5146f2ff6e8a29ed4eb7850'/>
<id>5b4108f0fd68956ff5146f2ff6e8a29ed4eb7850</id>
<content type='text'>
This adjusts the partial condition for an index. The index is intended
to be used when counting active users with `ghost IS NOT TRUE AND
bot_type IS NULL`.

With the current index, this wasn't working as the partial condition
didn't match the query: `ghost &lt;&gt; TRUE` is not semantically equivalent
to `ghost IS NOT TRUE` (null semantics).

The reason we add an index particularly intended for EE is that the EE
query is going to have the additional part `AND bot_type IS NULL`
whereas the CE query doesn't. Logically, it'd be enough to have an index
for `ghost IS NOT TRUE`. However, on GitLab.com, the query planner makes
poor choices when the additional `AND bot_type IS NULL` part is present:
It goes for the index on `bot_type` and doesn't use the partial index.

Note the existing index isn't being used at all according to GitLab.com
index statistics. Hence we can first remove it and don't have to worry
about the window of time without an index.

Relates to https://gitlab.com/gitlab-org/gitlab-ce/issues/66770
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
This adjusts the partial condition for an index. The index is intended
to be used when counting active users with `ghost IS NOT TRUE AND
bot_type IS NULL`.

With the current index, this wasn't working as the partial condition
didn't match the query: `ghost &lt;&gt; TRUE` is not semantically equivalent
to `ghost IS NOT TRUE` (null semantics).

The reason we add an index particularly intended for EE is that the EE
query is going to have the additional part `AND bot_type IS NULL`
whereas the CE query doesn't. Logically, it'd be enough to have an index
for `ghost IS NOT TRUE`. However, on GitLab.com, the query planner makes
poor choices when the additional `AND bot_type IS NULL` part is present:
It goes for the index on `bot_type` and doesn't use the partial index.

Note the existing index isn't being used at all according to GitLab.com
index statistics. Hence we can first remove it and don't have to worry
about the window of time without an index.

Relates to https://gitlab.com/gitlab-org/gitlab-ce/issues/66770
</pre>
</div>
</content>
</entry>
<entry>
<title>Rename epic column state to state_id</title>
<updated>2019-08-30T11:28:20+00:00</updated>
<author>
<name>Felipe Artur</name>
<email>fcardozo@gitlab.com</email>
</author>
<published>2019-08-30T11:28:20+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/gitlab/gitlab-ce.git/commit/?id=0f59d73ef2f65aba791b6738a5e705fe1a8da789'/>
<id>0f59d73ef2f65aba791b6738a5e705fe1a8da789</id>
<content type='text'>
Rename epic column state to state_id to be consistent with
issues and merge requests
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Rename epic column state to state_id to be consistent with
issues and merge requests
</pre>
</div>
</content>
</entry>
</feed>
