On 17/04/2020 13:37, Achilleas Mantzios wrote:
> Hello Dear List,
>
> we have a table holding email attachments as bytea, and we would like
> to filter out images of small dimensions, which are not of any value
> to our logic.
>
> I took a look at pg_image extension, tested it, and it proved
> problematic, it killed my 200+ days uptime FreeBSD box :( . I dropped
> the extension and uninstalled this as soon as fsck finally finished.
If running an extension crashed your server you should look at how /
why, especially if it corrupted your filesystem.
That shouldn't happen on a correctly configured system, so the
underlying issue might cause you other problems. Crashing postgresql,
sure, but not anything that impacts the rest of the server.
Cheers,
Steve