Re: Linux Update Experience

2020-05-28 Thread Jiří Fejfar
e to fresh new DB. -- Jiří Fejfar

parallel plpgsql function

2019-01-29 Thread Jiří Fejfar
Hi all! I am trying to create basic experiment [1] analysing some data with plpgsql function in parallel. I am able to aggregate data in parallel (6 workers) with pure SQL code (line 19) but as far as I put the same query (with some parametrization) into plpgsql function and run it via RETURN QUE

Re: Copy entire schema A to a different schema B

2019-02-20 Thread Jiří Fejfar
Hi Tiffany, Isn't it possible for you to do: 1) rename temporarily schema testuser1 to testuser2 2) dump that schema into binary format 3 rename back schema testuser2 to testuser1 4 restore backup to testuser2 schema on other DB? Jura. On Wed, 20 Feb 2019 at 23:23, Tiffany Thang wrote: > > Hi A