On 01/09/12 1:03 PM, Andy Chambers wrote:
I have an update that takes longer than expected and wondered if
there's an easy way to make it go faster.
It's pretty simple:-
create table session (
id serial primary key,
data text);
update session
set data = 'ipsum lorem...'
where id = 5;
The "ipsum lorem.." stuff is an encrypted session variable from a
rails app that does tend to get quite large
select avg(length(data)) from session
=> 31275
We're trying to migrate the app from mysql to pg and this is one of
the performance bottle-necks. Unfortunately it slows down every
request by about 5 seconds. MySQL (both MyISAM and InnoDB) does this
almost instantaneously.
is that 5 seconds for ONE of those UPDATEs, or is your webapp making
100s of those updates for every web request?
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general