Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)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