User Tools

Site Tools


sql_analysis_dedup_attachments

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
sql_analysis_dedup_attachments [2014/09/01 21:00] – created danielsql_analysis_dedup_attachments [2018/09/09 17:53] (current) daniel
Line 1: Line 1:
 +====== Attachments deduplication ======
 +
 Attachments are stored into 3 tables: ''attachments'', ''attachment_contents'' and the ''pg_largeobject'' system table. Attachments are stored into 3 tables: ''attachments'', ''attachment_contents'' and the ''pg_largeobject'' system table.
  
Line 13: Line 15:
 </code> </code>
  
-This query retrieves, within the top 30 of the most deduplicated attachments (in number of occurrences), the count and sizes of attachments with file names and a significant size:+The following query retrieves, within the top 30 of the most deduplicated attachments (in number of occurrences), the count and sizes of attachments with file names and a significant size:
 <code sql> <code sql>
 select filename,count(*),content_size select filename,count(*),content_size
sql_analysis_dedup_attachments.1409605230.txt.gz · Last modified: 2014/09/01 21:00 by daniel