Postgres Pro
Downloads
Home   >   mailing lists

Re: Multiple Indexing, performance impact - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Multiple Indexing, performance impact
Date
Msg-id 7350.993272027@sss.pgh.pa.us
Whole thread Raw
In response to Re: Multiple Indexing, performance impact  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-hackers
Tree view 
Lincoln Yeoh <lyeoh@pop.jaring.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

pgsql-hackers by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: Multiple Indexing, performance impact
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Multiple Indexing, performance impact