[ZODB-Dev] Relstorage PostgreSQL and blobs garbage collection

[Shane Hathaway]

On 11/10/2011 08:56 AM, Александр Неганов wrote:
> We had large history-free database with lot of "deleted" Blobs, so we
> packed and gc-ed it. Many rows from object_state as well as
> corresponding blob_chunk rows has been deleted, but postgresql large
> objects stays untouched. It seems that blob_chunk_delete_trigger is
> not executed in this case, but works fine when i manually delete rows
> from blob_chunk table. PostgreSQL problem? PostgreSQL server version
> is 9.0.4, RelStorage version is 1.5.0.

Hmm, that trigger is essential for deleting the large objects. There is 
probably some special case in Postgres that RelStorage is accidentally 
hitting when it deletes the rows. It has always worked for me.

Shane