Add indexes before bulk update #515

	name: Python CI

	on: push

	jobs:
	test:

	runs-on: ubuntu-24.04
	strategy:
	matrix:
	python-version:
	- "3.10"
	- "3.11"
	- "3.12"

	steps:
	- uses: actions/checkout@v2

	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v2
	with:
	python-version: ${{ matrix.python-version }}

	- name: Install system-level dependencies
	run: \|
	# Add postgres package repo; see https://wiki.postgresql.org/wiki/Apt
	sudo apt-get install curl ca-certificates gnupg
	sudo install -d /usr/share/postgresql-common/pgdg
	sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc

	sudo sh -c 'echo "deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

	sudo apt update
	sudo apt install postgresql-plpython3-16 postgresql-16-postgis-3

	- name: Start Postgres
	run: \|
	# See https://github.com/actions/runner-images/blob/main/images/ubuntu/Ubuntu2404-Readme.md#postgresql
	sudo systemctl start postgresql.service

	- name: Install Poetry
	run: \|
	curl -sSL https://install.python-poetry.org \| python3 -

	- name: Install dependencies
	run: \|
	poetry install

	- name: Test with pytest (full)
	if: github.ref == 'refs/heads/master'
	env:
	PYCDS_SCHEMA_NAME: other
	run: \|
	poetry run pytest -v --tb=short tests

	- name: Test with pytest (fast)
	if: github.ref != 'refs/heads/master'
	env:
	PYCDS_SCHEMA_NAME: other
	run: \|
	poetry run pytest -m "not slow" -v --tb=short tests

Provide feedback