Differences

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

--- sql_analysis_dedup_attachments [2014/09/01 21:00] – created daniel
+++ sql_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.
@@ Line 13: / Line 15: @@
 </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>
 select filename,count(*),content_size