random huge delay when recreate a VIEW or FUNCTION - Mailing list pgsql-general
| From | Catalin Maftei |
|---|---|
| Subject | random huge delay when recreate a VIEW or FUNCTION |
| Date | |
| Msg-id | 84203e37-5af3-f0d5-fe9c-6a3ae615f444@plationline.eu Whole thread Raw |
| Responses |
Re: random huge delay when recreate a VIEW or FUNCTION
Re: random huge delay when recreate a VIEW or FUNCTION |
| List | 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 by date: