Denis Rykov

@bitner, is there a way to prevent the `searches` table from growing infinitely, or should it be periodically cleaned up manually?

@bitner finally got around to testing your changes. The ability to enforce the query queue for loading is quite useful! However, it only partially resolves my initial concern, queuing up...

I observed a connection between the presence of a `Lock:relation` in the database performance chart and the absence of STAC items. This occurs when multiple workers are simultaneously utilizing the...

I grasp that adhering to the practice of performing sequential operations of writing data into the same partition is a general guideline. However, due to our daily data ingestion into...

Proposed solution: https://github.com/stac-utils/pgstac/pull/223

Thank you for sharing this information! Based on what I've observed, it seems that the loader is already utilizing the `update_partition_stats_q` function [here](https://github.com/stac-utils/pgstac/blob/1ea6c5df7cc79364e34ea9bee7693f9db2d922cd/src/pypgstac/python/pypgstac/load.py#L444). To run it asynchronously, it appears that...

I see. But the idea is to take into account feature IDs if they are existing.

Exactly.

That is not right, the collection has `id`. It fails [here](https://github.com/stac-utils/qgis-stac-plugin/blob/2ef210d0ad31c616abf5690a74def057a55691f6/src/qgis_stac/gui/qgis_stac_widget.py#L688) because few lines above `get_selected_collections` method is called with `title=True` argument and as you can see [here](https://github.com/stac-utils/qgis-stac-plugin/blob/2ef210d0ad31c616abf5690a74def057a55691f6/src/qgis_stac/gui/qgis_stac_widget.py#L984) in this...

Thanks!