Re: pgbench and timestamps

2020-06-25 Thread Jaime Soler
Thanks for your analysis. Regards El mié., 24 jun. 2020 a las 17:17, Tom Lane () escribió: > I wrote: > > David Rowley writes: > >> I don't often do much with pgbench and variables, but there are a few > >> things that surprise me here. > >> 1) That pgbench replaces variables within single quo

Re: pgbench and timestamps

2020-06-24 Thread Jaime Soler
seconds parts :00:00 as two variables . Regards El mié., 24 jun. 2020 a las 14:50, David Rowley () escribió: > On Wed, 24 Jun 2020 at 20:41, Jaime Soler wrote: > > > > Hi, does anybody know what is wrong with pgbench in this case ?. Here is > a simple query to generate a random

pgbench and timestamps

2020-06-24 Thread Jaime Soler
Hi, does anybody know what is wrong with pgbench in this case ?. Here is a simple query to generate a random date in a interval time.sql: (select timestamp '2005-09-01' + random() * ( timestamp '2006-03-01 00:00:00' - timestamp '2005-09-01 00:00:00' )); query executed successfullly with psql /

Re: The connection to the server was lost. Attempting reset: Failed.

2019-10-10 Thread Jaime Soler
Why don't have a try to gdb ? https://wiki.postgresql.org/wiki/Developer_FAQ#What_debugging_features_are_available.3F It might be a extra free memory executions or null pointer accesses .. , gdb could help you. Regards El jue., 10 oct. 2019 a las 20:01, Yessica Brinkmann (< yessica.brinkm...@gma

Re: Getting started with first user.

2018-01-09 Thread Jaime Soler
please try su postgres -c 'createuser -U postgres me' or change auth method in your pg_hba.conf 2018-01-09 10:48 GMT+01:00 Agnar Renolen : > I have just installed PostGIS (Postgres9.6) on a Debian server using > apt-get. > > But I have problems doing anything: > > I installed as root, but tryin