Re: Need help to decide Mysql vs Postgres - Mailing list pgsql-performance

From Tom Lane
Subject Re: Need help to decide Mysql vs Postgres
Date
Msg-id 26012.1118120076@sss.pgh.pa.us
Whole thread Raw
In response to Re: Need help to decide Mysql vs Postgres  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-performance
Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> Christopher Browne wrote:
>> There is a common "use case" where MySQL(tm) ...
>> select * from some_table where id='some primary key value';

> However this is a quite common use-case; and I wonder what the
> best practices for postgresql is for applications like that.

Setting up a prepared statement should be a noticeable win for that sort
of thing.  Also of course there are the usual tuning issues: have you
picked an appropriate shared_buffers setting, etc.

            regards, tom lane

pgsql-performance by date:

Previous
From: John A Meinel
Date:
Subject: Re: Postgresql and Software RAID/LVM
Next
From: Russell Smith
Date:
Subject: Re: Performance nightmare with dspam (urgent)