Re: Performance of DOMAINs

Поиск
Список
Период
Сортировка
От David Wheeler
Тема Re: Performance of DOMAINs
Дата
Msg-id 0878A4AB-925F-4CB8-BB75-53340599825D@kineticode.com
обсуждение исходный текст
Ответ на Re: Performance of DOMAINs  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Jun 21, 2006, at 13:08, Tom Lane wrote:

> There are some reports in the archives of particular usage patterns
> where they pretty much suck, because GetDomainConstraints() searches
> pg_constraint every time it's called.  We do what we can to avoid
> calling that multiple times per query, but for something like a simple
> INSERT ... VALUES into a domain column, the setup overhead is still
> bad.

I assume that there's no domain thingy that you already have that
could cache it, eh?

Sorry, I ask this as someone who knows no C and less about
PostgreSQL's internals.

Best,

David


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Poor performance - fixed by restart
Следующее
От: David Wheeler
Дата:
Сообщение: Re: Performance of DOMAINs