Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: simple case using index on windows but not on linux
- From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
- To: simon godden <sgodden(at)gmail(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: simple case using index on windows but not on linux
- Date: Wed, 04 Oct 2006 10:11:44 +0100
- Message-id: <45237AD0(dot)50604(at)enterprisedb(dot)com>
simon godden wrote:
The only major difference between the hardware is that the windows machine has 2gb RAM and a setting of 10000 shared memory pages, whereas the linux machine has 756Mb RAM and a setting of 3000 shared memory pages (max. shared memory allocation of 32Mb). I can't see any other differences in configuration.
You can increase the max shared memory size if you have root access. See http://www.postgresql.org/docs/8.1/interactive/kernel-resources.html#SYSVIPC-PARAMETERS Scroll down for Linux-specific instructions. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
- Follow-Ups:
- Re: simple case using index on windows but not on linux
- From: simon godden
- Re: simple case using index on windows but not on linux
- References:
- simple case using index on windows but not on linux
- From: simon godden
- simple case using index on windows but not on linux
- Prev by Date: Unsubscribe
- Next by Date: Re: simple case using index on windows but not on linux
- Previous by thread: simple case using index on windows but not on linux
- Next by thread: Re: simple case using index on windows but not on linux
- Indexes: