diff --git a/swh/lister/core/tests/test_indexing_lister.py b/swh/lister/core/tests/test_indexing_lister.py
new file mode 100644
--- /dev/null
+++ b/swh/lister/core/tests/test_indexing_lister.py
@@ -0,0 +1,89 @@
+# Copyright (C) 2019 the Software Heritage developers
+# License: GNU General Public License version 3, or any later version
+# See top-level LICENSE file for more information
+
+import datetime
+
+from swh.lister.core.indexing_lister import IndexingLister
+
+
+class MockedIndexingListerDbPartitionIndices(IndexingLister):
+    # Abstract Attribute boilerplate
+    LISTER_NAME = 'DbPartitionIndices'
+    MODEL = type(None)
+
+    # ABC boilerplate
+    def get_next_target_from_response(self, *args, **kwargs):
+        pass
+
+    def __init__(self, num_entries, first_index, last_index):
+        self.num_entries = num_entries
+        self.first_index = first_index
+        self.last_index = last_index
+
+    def db_num_entries(self):
+        return self.num_entries
+
+    def db_first_index(self):
+        return self.first_index
+
+    def db_last_index(self):
+        return self.last_index
+
+
+def test_db_partition_indices():
+    m = MockedIndexingListerDbPartitionIndices(
+        num_entries=1000,
+        first_index=1,
+        last_index=10001,
+    )
+    assert m
+
+    partitions = m.db_partition_indices(100)
+
+    # 1000 entries with indices 1 - 10001, partitions of 100 entries
+    assert len(partitions) == 10
+    assert partitions[0] == (None, 1001)
+    assert partitions[-1] == (9001, None)
+
+
+def test_db_partition_indices_date_indices():
+    # 24 hour delta
+    first = datetime.datetime.fromisoformat('2019-11-01T00:00:00+00:00')
+    last = datetime.datetime.fromisoformat('2019-11-02T00:00:00+00:00')
+
+    m = MockedIndexingListerDbPartitionIndices(
+        # one entry per second
+        num_entries=24 * 3600,
+        first_index=first,
+        last_index=last,
+    )
+    assert m
+
+    # 3600 entries per partition => 1 partition per hour
+    partitions = m.db_partition_indices(3600)
+
+    assert len(partitions) == 24
+
+    expected_bounds = [first + datetime.timedelta(hours=i) for i in range(25)]
+    expected_bounds[0] = expected_bounds[-1] = None
+
+    assert partitions == list(zip(expected_bounds[:-1], expected_bounds[1:]))
+
+
+def test_db_partition_indices_float_index_range():
+    m = MockedIndexingListerDbPartitionIndices(
+        num_entries=10000,
+        first_index=1.0,
+        last_index=2.0,
+    )
+    assert m
+
+    partitions = m.db_partition_indices(1000)
+
+    assert len(partitions) == 10
+
+    expected_bounds = [1.0 + 0.1 * i for i in range(11)]
+    expected_bounds[0] = expected_bounds[-1] = None
+
+    assert partitions == list(zip(expected_bounds[:-1], expected_bounds[1:]))