On Wed, Jan 3, 2018 at 5:39 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Thomas Munro <thomas.munro@xxxxxxxxxxxxxxxx> writes: >> So you have 16GB of RAM and here we're failing to posix_fallocate() >> 50MB (actually we can't tell if it's the ftruncate() or >> posix_fallocate() call that failed, but the latter seems more likely >> since the former just creates a big hole in the underlying tmpfs >> file). Can you share the query plan (EXPLAIN SELECT ...)? > > I wonder if OP is running with a tmpfs size setting that's less than > the traditional Linux default of half of physical RAM size. Hmm. Canh, can you please share the output of the following commands? mount | grep /dev/shm du -hs /dev/shm df /dev/shm -- Thomas Munro http://www.enterprisedb.com
