Re: Emulating flexible regex replace

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: Emulating flexible regex replace
Дата
Msg-id CA+bJJbwyUGxxtabc3J0rTwYOKXNZ+bkbz2i1OO1Z3Yk9pbXZ9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Emulating flexible regex replace  (twoflower <standa.kurik@gmail.com>)
Список pgsql-general
Hi:

On Fri, Oct 24, 2014 at 6:13 PM, twoflower <standa.kurik@gmail.com> wrote:
....
It works very vell. However, I am not completely satisfied with i as it's
unnecessarily loading larger data set than it absolutely must. Besides, I'd
also like to get some experience in DB programming. That's why the PL/Perl
way seems pretty attractive to me.

Try it them. But bear in mind you are not *unnecessarily* loading the data set, the server will need to load it to apply the plperl filters, you will just avoid loading it in the client and transmitting it. You are making a trade off, a design decission. You are trading some network and client cpu usage for some server cpu usage and coding complexity. The tricky part is the the coding complexity, which needs a lot of resources you may never recover. Part of the experience in DB programming is knowing what NOT to do in the database, so coding this will be good, the worst thing that could happen is you do it and then drop it after learning one thing.

Francisco Olarte.

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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Non-capturing expressions
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Non-capturing expressions