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 23:00]
daniel created
sql_analysis_dedup_attachments [2018/09/09 19:53]
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.txt ยท Last modified: 2018/09/09 19:53 by daniel