Re: Slow planning time when public schema included (12 vs. 9.4)

2020-03-24 Thread Anders Steinlein
On Sat, Mar 21, 2020 at 11:55 PM Tom Lane wrote: > Anders Steinlein writes: > > This they most definitely are not. 9.4 was running on an old box, Ubuntu > > 12.04, while 12 is on an up-to-date Ubuntu 18.04 LTS. AFAICS, 2.15 on the > > 9.4 box and 2.27 on the 12 box. > > I'm suspicious that the r

Re: Random function

2020-03-24 Thread David G. Johnston
How is this a performance related question? On Tue, Mar 24, 2020 at 11:10 AM Luis Roberto Weck < luisrobe...@siscobra.com.br> wrote: > However, I am getting the same result over mulitiple rows. This is a > sample of the SQL I am using: > > select (select string_agg(random()::text,';') >

Re: Random function

2020-03-24 Thread Tom Lane
Luis Roberto Weck writes: > I am trying to generate some random data using the random() function. > However, I am getting the same result over mulitiple rows. This is a > sample of the SQL I am using: > select (select string_agg(random()::text,';') > from pg_catalog.generate_series(1,3,

Random function

2020-03-24 Thread Luis Roberto Weck
Hi, I am trying to generate some random data using the random() function. However, I am getting the same result over mulitiple rows. This is a sample of the SQL I am using: select (select string_agg(random()::text,';')           from pg_catalog.generate_series(1,3,1) )   from generate_series(