Update takes longer than expected

Поиск
Список
Период
Сортировка
От Andy Chambers
Тема Update takes longer than expected
Дата
Msg-id CAAfW55pD3k291Sk3D7jGt-dUjOroSZLgm73htLf=vt+XvAtRRA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Update takes longer than expected  (Bill Moran <wmoran@potentialtech.com>)
Re: Update takes longer than expected  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Update takes longer than expected  (John R Pierce <pierce@hogranch.com>)
Re: Update takes longer than expected  (Jerry Sievers <gsievers19@comcast.net>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: [JDBC] Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Update takes longer than expected