Temporary Files

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



PostgreSQL 12

I just increased my work_mem to 24 MB.  I cleared my statistics.  I then went back later and saw the following:

 

Temporary files: 21

Size of temporary files 451 MB.

 

If you divide 451 by 21 you get 21.4 .  I would have expected to see an average size greater than 24 MB.  This implies to me that PostgreSQL is creating temp files that are smaller than 24 MB. 

 

What am I not understanding?

 

Thanks,

 

 

LANCE CAMPBELL

Software Architect

 

Web Services

Public Affairs

Contact the Webtools Team

217.333.0382

lance@xxxxxxxxxxxx

 

 

/var/folders/wp/1f6l7hw95y718z976kgnl5f9kr5rtc/T/com.microsoft.Outlook/WebArchiveCopyPasteTempFiles/signature_logo.png

 

Under the Illinois Freedom of Information Act any written communication to or from university employees regarding university business is a public record and may be subject to public disclosure.

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux