[LRUG] Reasons for Postgres (was: Migrating SQLlite to MySQL)

[Jocke Selin]

On 16 Nov 2009, at 17:58, Tom Morris wrote:

> On Mon, Nov 16, 2009 at 16:52, Sam Stokes <webstuff-lrug at samstokes.co.uk> wrote:
>> Now that you've brought it up :)  Would you be able to list a few things
>> that you like about Postgres, or even reasons to use Postgres over MySQL?
>> 
>> I'm not looking for a flamewar (and certainly not intending to defend
>> MySQL!) - I'm genuinely curious about Postgres.  It's something I've never
>> got around to looking into - MySQL has always been "good enough", since I'm
>> already familiar with it - but I'd like to have a reason to try Postgres on
>> a new project.
>> 
> 
> I recently evaluated both Postgres and MySQL, and I found:

.....

> 4. Postgres has a slight speed disadvantage over MySQL in terms of
> read performance - I'm told, I haven't actually tested it - but the
> app I'm using has a small number of users who write and edit a *lot*.

I seem to recall us doing quite a lot of research into speeding PostgreSQL up, and one of the things you can do is to put the PGSQL write-ahead onto a separate disk and a non-journalling FS... if memory serves. Obviously with optimised parameters for the hardware.

/Jocke