Re: Why adding BEFORE TRIGGER affect client CPU?

On 1/18/19 12:21 PM, George Woodring wrote: Adrian Klaver > writes: > What is the client server and what is it doing? Our client creates a temp table CREATE TEMP TABLE myraw(LIKE raw INCLUDING DEFAULTS) We load data with a copy COPY myraw (transferid,

pgint.l -- PostgreSQL interface for PicoLisp

Hello everyone. I'm happy to announce that new PostgreSQL interface for PicoLisp is released: https://gitlab.com/Abel-ze-Normand/pgint.l . It's simple yet powerful to provide minimal toolkit to integrate your PicoLisp application with PostgreSQL databases. This library currently is in state of

Re: Why adding BEFORE TRIGGER affect client CPU?

Adrian Klaver writes: > What is the client server and what is it doing? Our client creates a temp table CREATE TEMP TABLE myraw(LIKE raw INCLUDING DEFAULTS) We load data with a copy COPY myraw (transferid, pollgrpid, date, data, rrdtypeid, error ) FROM STDIN WITH DELIMITER '|' We do some

Re: Oracke BLOB to Postgres BYTEA using ora2pg

On 2019-01-15 12:56:05 +0100, Daniel Verite wrote: > Mihalidesová Jana wrote: > > nipjd=> select distinct encode(serializable_value, 'escape') from > > alf_node_properties_zaloha where serializable_value is not null; > >

Re: Why adding BEFORE TRIGGER affect client CPU?

Adrian Klaver writes: > On 1/18/19 10:23 AM, George Woodring wrote: >> We recently changed the process to do a BEFORE TRIGGER to do the >> calculation between OLD and NEW instead of the separate function with >> the SELECT. > So what was the exact change? >> After doing this, CPU on our two

Re: Why adding BEFORE TRIGGER affect client CPU?

On 1/18/19 10:23 AM, George Woodring wrote: We are running 9.6.8-10 on our five postgres clusters. We have ~25 database per cluster. We have two servers that update a table in each database. During the update process we were running a pgpsql function that calculated the difference in the new

Why adding BEFORE TRIGGER affect client CPU?

We are running 9.6.8-10 on our five postgres clusters. We have ~25 database per cluster. We have two servers that update a table in each database. During the update process we were running a pgpsql function that calculated the difference in the new value with the previous. This function would do

Re: Refining query statement [DONE]

On Tue, 15 Jan 2019, Rich Shepard wrote: Working with my sales/client management system using psql I have a select statement to identify contacts to be made. This statement works: With much patient advice from Adrian, David, Thomas, and Ron I fixed the schema and the query statement. To close

Re: Upgrading from 9.2.15 to 9.4.20

On 1/18/19 3:50 AM, Michal wrote: Is anywhere where IP adress of the server must be set? Because im doing upgrade on test and this is copy of the VM of production (upgrading Jira PostgreSQL)...Checks when Postgres 9.2.15 running gives me ok when i stop both instances and try to upgrade i have

Re: Full text search with more than one word

(please don't top-post on the postgresql mailinglists) On Fri, Jan 18, 2019 at 3:57 PM Ritanjali Majihee < rmaj...@247headhunting.com> wrote: > Hi Magnus, > > > > exact Search keyword is ("Marketing Coordinator" OR "Marketing > Specialist" OR "Marketing Associate" ) AND "Creative Suite". > > >

Re: Upgrading from 9.2.15 to 9.4.20

Is anywhere where IP adress of the server must be set? Because im doing upgrade on test and this is copy of the VM of production (upgrading Jira PostgreSQL)...Checks when Postgres 9.2.15 running gives me ok when i stop both instances and try to upgrade i have error what i writed. Can you be

RE: Full text search with more than one word

Hi Magnus, exact Search keyword is ("Marketing Coordinator" OR "Marketing Specialist" OR "Marketing Associate" ) AND "Creative Suite". Where condition like below syntax we are using in Postgresql function SELECT * from tablename where html_tokens @@ to_tsquery( ' ||

repmgr and automatic failover

Hi It seems that after an automatic failover by repmgr, it is possible to start the old primary instance. ( SPLIT BRAIN Risk) . For example: the case when we make a reboot of the primary server, so there is an automatic failover made by repmgr and in this situation, we end up with 2 primary

Re: pgbouncer

Nicola, My previous mail was maybe misleading because when i mentioned 'connections' I actually meant active connections to the db, as in: doing a transaction. In that case, yes, the connections are shared. But as soon as they initiate a transaction, then they are not shared any longer and a new

Re: Upgrading from 9.2.15 to 9.4.20

On 18/1/19 12:30 μ.μ., Michal wrote: Im trying to upgrade PostgreSQL from 9.2.15 to 9.4.20 with this : /usr/pgsql-9.4/bin/pg_upgrade --old-bindir=/usr/bin --new-bindir=/usr/pgsql-9.4/bin --old-datadir=/var/lib/pgsql/ data --new-datadir=/var/lib/pgsql/9.4/data Can anybody help me with this? I

Re: Full text search with more than one word

On Fri, Jan 18, 2019 at 11:37 AM Ritanjali Majihee < rmaj...@247headhunting.com> wrote: > Hi Team, > > > > We have around 20 millions of records in Postgresql database. One of the > column is html document stored as Text datatype. We want Use this column in > search functionality. We have

Full text search with more than one word

Hi Team, We have around 20 millions of records in Postgresql database. One of the column is html document stored as Text datatype. We want Use this column in search functionality. We have converted html content to plaintext and created tokens using to_tsvector. We have implemented full text

Upgrading from 9.2.15 to 9.4.20

Im trying to upgrade PostgreSQL from 9.2.15 to 9.4.20 with this : /usr/pgsql-9.4/bin/pg_upgrade --old-bindir=/usr/bin --new-bindir=/usr/pgsql-9.4/bin --old-datadir=/var/lib/pgsql/ data --new-datadir=/var/lib/pgsql/9.4/data Can anybody help me with this? I also try -p port parameter not helped.