You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: doc/src/sgml/config-one-c.sgml
+20-1Lines changed: 20 additions & 1 deletion
Original file line number
Diff line number
Diff line change
@@ -45,6 +45,14 @@ escape_string_warning = off
45
45
</para>
46
46
</listitem>
47
47
48
+
<listitem>
49
+
<para>
50
+
Set the <varname>effective_cache_size</varname> parameter to at least half of <acronym>RAM</acronym>
51
+
available on the system. <productname>&productname;</productname> query optimizer performance
52
+
depends on the amount of allocated <acronym>RAM</acronym>.
53
+
</para>
54
+
</listitem>
55
+
48
56
<listitem>
49
57
<para>Optimize query planning using <link linkend="online-analyze"><filename>online_analyze</filename></link> and <link linkend="plantuner"><filename>plantuner</filename></link> extensions, as follows:
50
58
</para>
@@ -86,4 +94,15 @@ online_analyze.verbose = 'off'
86
94
</listitem>
87
95
88
96
</orderedlist>
89
-
</appendix>
97
+
98
+
<tip>
99
+
<para>
100
+
To improve performance, you can also use redundant array of independent disks (<acronym>RAID</acronym>) technology
101
+
based on non-volatile cache <acronym>RAID</acronym> controllers with uninterruptible power supply (<acronym>UPS</acronym>).
102
+
Since this technology ensures data consistency in case of hardware failure, you can speed up disk writes by
103
+
disabling the <varname>fsync</varname> parameter. Additionally, increasing the <acronym>RAID</acronym> controller cache
104
+
volume and the number of disks in the <acronym>RAID</acronym> array can improve performance even with