Re: Performance on writable views

От: Jim Nasby
Тема: Re: Performance on writable views
Дата: ,
(см: обсуждение, исходный текст)
Ответ на: Re: Performance on writable views  ("Joshua D. Drake")
Список: pgsql-performance

Скрыть дерево обсуждения

Performance on writable views  (Enrico Weigelt, )
 Re: Performance on writable views  (Heikki Linnakangas, )
  Re: Performance on writable views  ("Joshua D. Drake", )
   Re: Performance on writable views  (Jim Nasby, )

On Aug 11, 2007, at 8:58 AM, Joshua D. Drake wrote:
> Heikki Linnakangas wrote:
>> Enrico Weigelt wrote:
>>> I'm often using writable views as interfaces to clients, so
>>> they only see "virtual" objects and never have to cope with
>>> the actual storage, ie. to give some client an totally
>>> denormalized view of certain things, containing only those
>>> information required for certain kind of operations.
>>> Now I've got the strange feeling that this makes updates
>>> slow, since it always has to run the whole view query to
>>> fetch an record to be updated (ie. to get OLD.*).
>> There is some overhead in rewriting the query, but it shouldn't be
>> significantly slower than issuing the statements behind the view
>> directly. I wouldn't worry about it, unless you have concrete
>> evidence
>> that it's causing problems.
> I don't know about that, at least when using rules for partitioning
> the
> impact can be significant in comparison to triggers.

That's because you have to re-evaluate the input query for each rule
that's defined, so even if you only have rules for 2 partitions in a
table (which is really about the minimum you can have, at least for
some period of overlap surrounding the time when you switch to a new
partition), you're looking at evaluating every input query twice.

In this case, the rules presumably are just simply re-directing DML,
so there'd only be one rule in play at a time. That means the only
real overhead is in the rewrite engine.
Decibel!, aka Jim Nasby                        
EnterpriseDB      512.569.9461 (cell)

В списке pgsql-performance по дате сообщения:

От: Dave Cramer
Сообщение: Re: Dell Hardware Recommendations
От: "Michael Ben-Nes"
Сообщение: RAID 10 or RAID 10 + RAID 1