Postgres Pro
Downloads
Home   >   mailing lists

shared memory size - Mailing list pgsql-sql

From Wei Weng
Subject shared memory size
Date
Msg-id 994948253.2949.1.camel@Monet
Whole thread Raw
List pgsql-sql
Tree view 
Will increasing kernel shared memory size (in linux by doing "echo
134217728 >/proc/sys/kernel/shmall; echo 134217728
>/proc/sys/kernel/shmmax) help with the speed of a complicated query
with a large return set? (average 20000 or more entries in return)

Thanks

-- 
Wei Weng
Network Software Engineer
KenCast Inc.

pgsql-sql by date:

Previous
From: Wei Weng
Date:
Subject: Turn off flushing after each write
Next
From: "Fernando Eduardo B. L. e Carvalho"
Date:
Subject: C Functions