Move attachments data to its own table?

[Bradley Baetz]

On Sat, Aug 20, 2005 at 10:06:23AM -0700, Joel Peshkin wrote:
> 
> As far as I know, I have the largest attachments table of any bugzilla 
> installation.  That means that I am your future.
> 
> It seems that all accesses to the attachments table are very slow just 
> because of the huge amount of data in the table.  To date, we have been 
> adding indexes to keep most operations from needing to actually access 
> the row data.

Hmm. Postgres moves 'large' bits of data into external TOAST tables, to
avoid this.

OTOH, adding extra indexes is a loss on postgres - it always has to look at
the table data for queries, since the tuple may not be viewable to the
current transaction.

Bradley