shared memory size

From: Wei Weng <wweng(at)kencast(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: shared memory size
Date: 2001-07-12 14:30:42
Message-ID: 994948253.2949.1.camel@Monet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

  • C Functions at 2001-07-12 11:33:54 from Fernando Eduardo B. L. e Carvalho

Browse pgsql-sql by date

  From Date Subject
Next Message Jimmie Fulton 2001-07-12 14:59:41 Functions performed on intervals
Previous Message Wei Weng 2001-07-12 14:14:36 Turn off flushing after each write