Re: Multiple Indexing, performance impact

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Daniel Åkerud <zilch(at)home(dot)se>, PostgreSQL-general <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Multiple Indexing, performance impact
Date: 2001-06-23 04:53:47
Message-ID: 7350.993272027@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> writes:
> Why is SHMMAX so low on some O/Ses?

Historical artifact, I think: the SysV IPC code was developed on
machines that were tiny by current standards. Unfortunately, vendors
haven't stopped to review their kernel parameters and scale them up
appropriately.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Åkerud 2001-06-23 12:29:22 Re: TCP/IP Sockets, UNIX Sockets
Previous Message Thomas T. Thai 2001-06-23 04:12:31 Re: Re: select to combine 2 tables

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Kreen 2001-06-23 11:11:34 Re: [PATCH] by request: base64 for bytea
Previous Message Andy Samuel 2001-06-23 03:24:02 Red Hat DB = PostgreSQL confirmed !