Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group