tag:blogger.com,1999:blog-6987378274371810969.post65276685696418300..comments2024-01-17T20:28:57.859+08:00Comments on Linux, Unix, Shell: Using tmpfs to improve PostgreSQL performanceGao Ruifenghttp://www.blogger.com/profile/04264479712940228683noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6987378274371810969.post-74347303605680648972019-07-12T15:40:39.422+08:002019-07-12T15:40:39.422+08:00Thanks for sharing, nice post! Post really provice...Thanks for sharing, nice post! Post really provice useful information!<br /><br />Giaonhan247 chuyên dịch vụ <a href="http://www.tc.faa.gov/content/leaving.asp?extlink=https://giaonhan247.vn/bang-gia-cuoc-ship-van-chuyen-gui-hang-tu-viet-nam-di-my-gia-re.html" rel="nofollow">vận chuyển hàng đi mỹ</a> cũng như dịch vụ <a href="https://www.qatar.vcu.edu/?URL=https://giaonhan247.vn/ship-hang-my.html" rel="nofollow">ship hàng mỹ</a> từ dịch vụ nhận <a href="https://www.ebay-kleinanzeigen.de/externer-link-weiterleitung.html?to=https://giaonhan247.vn/mua-ho-hang-my.html" rel="nofollow">mua hộ hàng mỹ</a> từ website nổi tiếng Mỹ là <a href="https://register.scotland.gov.uk/subscribe/widgetsignup?url=https://giaonhan247.vn/cach-mua-hang-tren-amazon.html" rel="nofollow">mua hàng amazon</a> về VN uy tín, giá rẻ.thulannguyenhttps://www.blogger.com/profile/12739173686013878533noreply@blogger.comtag:blogger.com,1999:blog-6987378274371810969.post-91499603447294804342014-12-19T06:52:44.676+08:002014-12-19T06:52:44.676+08:00I used /dev/shm because it's already in fstab ...I used /dev/shm because it's already in fstab as a ramdisk. To make it exclusively for postgres 9.3, I did the following:<br />1. Created the /dev/shm/pgsql_stats_tmp directory with global read/write/execute privileges in postgres's init file in /etc/init.d <br />2. Added the path: stats_temp_directory = '/dev/shm/pgsql_stats_tmp' to postgresql.conf<br />Still testing. I may change permissions to read/execute for all but postgres.<br /><br />So far, no speed improvements.Markhttps://www.blogger.com/profile/11614110503908458742noreply@blogger.com