El día viernes, diciembre 27, 2019 a las 06:55:22a. m. +0100, Matthias Apitz
escribió:
>
> Hello,
>
> Is there any way (without looking up the name in table 'pg_cursors') to see
> if a
> cursor "foo" is still open?
>
I found this hint about 'pg_cursors' in stackoverflow:
https://stackoverfl
PegoraroF10 writes:
> I have to replace ; , " and ' chars in an string putting its correspondent
> ascii value
> I have a
> Replace(Replace(Replace(Replace($$Text,with;On'It"$$,',','chr(59)'),';','chr(44)'),'"','chr(34)'),,'chr(39)')
> It works but I would like to call just one Replace.
Use t
I have to replace ; , " and ' chars in an string putting its correspondent
ascii value
I have a
Replace(Replace(Replace(Replace($$Text,with;On'It"$$,',','chr(59)'),';','chr(44)'),'"','chr(34)'),,'chr(39)')
It works but I would like to call just one Replace.
I tried this but didn´t work
select
>
>
>
> Live tuples = 19,766,480
> Analyze scale factor = 0.001
> Analyze thresh = 5000
> Thresh + live_tuples * factor = 24,766
>
> So an autovacuum analyze should trigger around 24K tuples modified, is
> this to little or too much?
This seems too much to me. Was there a specific problem occurr
On Mon, Dec 23, 2019 at 4:13 AM Kyotaro Horiguchi
wrote:
> Hello.
>
> At Mon, 23 Dec 2019 03:38:12 +, Daulat Ram
> wrote in
> > thanks Adrian, what about the
> > postmaster.opts file, this file was also skipped in backup.
>
> The file is overwritten at startup so there's no point in having i
