Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql BLOB issues - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: pgsql BLOB issues
Date
Msg-id 005e01c30d5e$f0209560$6500a8c0@fhp.internal
Whole thread Raw
In response to pgsql BLOB issues  (Jeremy Andrus <jeremy@jeremya.com>)
List pgsql-performance
Tree view 
>   I'll ask my friendly sys-admin to vacuum pg_largeobject, and I'll let
> you know what happens :-) In general though, how much performance is
> really gained through regular vacuuming?

Significant.  It's essential to vacuum regularly.

Chris

pgsql-performance by date:

Previous
From: Jeremy Andrus
Date:
Subject: Re: pgsql BLOB issues
Next
From:
Date:
Subject: Diferent execution plan for similar query