Re: atrocious update performance

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: atrocious update performance
Дата
Msg-id 200403170911.37462.dev@archonet.com
обсуждение исходный текст
Ответ на Re: atrocious update performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: atrocious update performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Tuesday 16 March 2004 00:08, Tom Lane wrote:
>
> I'm inclined to suspect an issue with foreign-key checking.  You didn't
> give us any details about foreign key relationships your "cust" table is
> involved in --- could we see those?  And the schemas of the other tables
> involved?

Two questions Tom:
1. Do the stats tables record FK checks, or just explicit table accesses?
2. If not, should they?

If the only real activity is this update then simple before/after views of the
stats might be revealing.

--
  Richard Huxton
  Archonet Ltd

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

Предыдущее
От: Shridhar Daithankar
Дата:
Сообщение: A good article about application tuning
Следующее
От: Tom Lane
Дата:
Сообщение: Re: atrocious update performance