| From: | Andy Chambers <achambers(at)mcna(dot)net> |
|---|---|
| To: | pgsql <pgsql-general(at)postgresql(dot)org> |
| Cc: | IT Dev Department <itdevteam(at)mcna(dot)net> |
| Subject: | Update takes longer than expected |
| Date: | 2012-01-09 21:03:28 |
| Message-ID: | CAAfW55pD3k291Sk3D7jGt-dUjOroSZLgm73htLf=vt+XvAtRRA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
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.
Cheers,
Andy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2012-01-09 21:26:21 | Re: Update takes longer than expected |
| Previous Message | Oliver Jowett | 2012-01-09 20:21:37 | Re: [JDBC] Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues |