sql_analysis_dedup_attachments
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
sql_analysis_dedup_attachments [2014/09/01 23:00] daniel created |
sql_analysis_dedup_attachments [2018/09/09 19: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 23:00 by daniel
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
