random huge delay when recreate a VIEW or FUNCTION
От | Catalin Maftei |
---|---|
Тема | random huge delay when recreate a VIEW or FUNCTION |
Дата | |
Msg-id | 84203e37-5af3-f0d5-fe9c-6a3ae615f444@plationline.eu обсуждение исходный текст |
Ответы |
Re: random huge delay when recreate a VIEW or FUNCTION
(Adrian Klaver <adrian.klaver@aklaver.com>)
Re: random huge delay when recreate a VIEW or FUNCTION (Merlin Moncure <mmoncure@gmail.com>) |
Список | pgsql-general |
<div id="yiv0879298383yui_3_16_0_ym19_1_1465897917914_90199" dir="ltr" style="-webkit-padding-start: 0px; text-align: start; color: rgb(0, 0, 0); font-family: HelveticaNeue-Light, "Helvetica Neue Light", "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px;">when I recreate a VIEW or FUNCTION with a small change I get: <div id="yiv0879298383yui_3_16_0_ym19_1_1465897917914_90199" dir="ltr" style="-webkit-padding-start: 0px; text-align: start; color: rgb(0, 0, 0); font-family: HelveticaNeue-Light, "Helvetica Neue Light", "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><br style="-webkit-padding-start: 0px;"> <div dir="ltr" id="yiv0879298383yui_3_16_0_ym19_1_1465897917914_90249" style="-webkit-padding-start: 0px; text-align: start; color: rgb(0, 0, 0); font-family: HelveticaNeue-Light, "Helvetica Neue Light", "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px;">Query returned successfully with no result in 03:58 minutes. <div dir="ltr" id="yiv0879298383yui_3_16_0_ym19_1_1465897917914_90250" style="-webkit-padding-start: 0px; text-align: start; color: rgb(0, 0, 0); font-family: HelveticaNeue-Light, "Helvetica Neue Light", "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><br id="yiv0879298383yui_3_16_0_ym19_1_1465897917914_90251" style="-webkit-padding-start: 0px;"> <div dir="ltr" id="yiv0879298383yui_3_16_0_ym19_1_1465897917914_90250" style="-webkit-padding-start: 0px; text-align: start; color: rgb(0, 0, 0); font-family: HelveticaNeue-Light, "Helvetica Neue Light", "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><br style="-webkit-padding-start: 0px;"> <div dir="ltr" id="yiv0879298383yui_3_16_0_ym19_1_1465897917914_90250" style="-webkit-padding-start: 0px; text-align: start; color: rgb(0, 0, 0); font-family: HelveticaNeue-Light, "Helvetica Neue Light", "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px;">we have pg 9.4 -- Best regards, Catalin Maftei www.plationline.eu www.livrarionline.ro www.c-solution.biz Skype: catalinmaftei Mobile: +40723 338 598
В списке pgsql-general по дате отправления:
Предыдущее
От: Adrian KlaverДата:
Сообщение: Re: Data ingestion failing when using higher Batch size