Postgres Pro
Downloads
Home   >   mailing lists

Re: go for a script! / ex: PostgreSQL vs. MySQL - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: go for a script! / ex: PostgreSQL vs. MySQL
Date
Msg-id 3F88BFD7.1020808@familyhealth.com.au
Whole thread Raw
In response to Re: go for a script! / ex: PostgreSQL vs. MySQL  (Nick Barr <nicky@chuckie.co.uk>)
Responses Re: go for a script! / ex: PostgreSQL vs. MySQL
List pgsql-performance
Tree view 
> If shmmax and shmmall are too small, then:
>
> PostgreSQL requires some more shared memory to cache some tables, x Mb,
> do you want to increase your OS kernel parameters?
>
>    Tweak shmmax and shmmall

Note that this still requires a kernel recompile on FreeBSD :(

Chris

pgsql-performance by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Another weird one with an UPDATE
Next
From: David Griffiths
Date:
Subject: Re: Another weird one with an UPDATE