Re: Slow insert

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: Slow insert
Дата
Msg-id 20041211014528.GA16264@uio.no
обсуждение исходный текст
Ответ на Slow insert  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-performance
On Wed, Dec 08, 2004 at 10:42:19AM +0800, Christopher Kings-Lynne wrote:
> Why would an INSERT ever be really slow?  This is what I see a lot of in
> our site logs:
>
> Dec  5 15:57:48 marshall postgres[19599]: [3-1] LOG:  duration:
> 13265.492 ms  statement: INSERT INTO users_sessions (sid, cobrand_id,
> uid) VALUES ('145982ac39e1d09fec99cc8a606155e7', '1', '0')
>
> 13 seconds to insert a single row!

Do you have a foreign key or other check which could be really slow?

/* Steinar */
--
Homepage: http://www.sesse.net/

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: LIMIT causes SEQSCAN in subselect
Следующее
От: tomas@nocrew.org (Tomas Skäre)
Дата:
Сообщение: Re: [GENERAL] Query is not using index when it should