Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: go for a script! / ex: PostgreSQL vs. MySQL
Date
Msg-id 200310121331.42693.josh@agliodbs.com
Whole thread Raw
In response to Re: go for a script! / ex: PostgreSQL vs. MySQL  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: go for a script! / ex: PostgreSQL vs. MySQL
List pgsql-performance
Tree view 
Chris,

> > 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 :(

Not our fault, now is it?   This would mean that we wouldn't be able to script
for FreeBSD.   Bug the FreeBSD developers.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Next
From: Josh Berkus
Date:
Subject: Re: [SQL] sql performance and cache