What I have seen is that, when I am trying to connect the db server from
application server using ssh, the response was very slow. While from db server
to application server it is very quick as usually.
-Original Message-
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postg
Sorry for late reply. We usually do vacuum analyze daily basis using cron.
-Original Message-
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On
Behalf Of Edward W. Rouse
Sent: Friday, January 21, 2011 8:17 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Is
Buenos días:
Tengo una función que se dispara en un trigger cuya finalidad es; crear
un registro en otra tabla o actualizarlo y devolviendo el id del registro
creado/modificado para guardarlo en la tabla desde la que se llama. Intentaré
explicarlo mejor:
tablaA --> Es la que dispara el
On 2011-01-18, andrew1 wrote:
> hi all,
>
> these return t:
> select 'ab' ~ '[a-z]$'
this matches the b and the end of the string
> select 'ab' ~ '^[a-z]'
this matches the start of the string and the a
> select 'ab' ~ '^[a-z]$' returns f
> Can't I use ^ and $ at the same time to match, in thi
Buenos días:
Tengo una función que se dispara en un trigger cuya finalidad es; crear
un registro en otra tabla o actualizarlo y devolviendo el id del registro
creado/modificado para guardarlo en la tabla desde la que se llama. Intentaré
explicarlo mejor:
tablaA --> Es la que dispara el
On 2011-01-21, Arindam Hore wrote:
> We are accessing database using ip address.
try adding the IP addresses of some of the clients as seen by the
server to /etc/hosts on the server. see if that helps.
try connecting to the server locally using 'su postgres -c psql'
see if that's slow too.
--
