Re: [GENERAL] PostgreSQL image for rkt on CoreOS

Though not an ACI image, CoreOS maintains a much smaller Docker image for PostgreSQL at https://quay.io/repository/coreos/postgres. Derek On 9 July 2016 at 10:29, Derek Mahar wrote: > Where may I find a PostgreSQL App Container Image (ACI) for rkt on > CoreOS? I

Re: [GENERAL] FTS with more than one language in body and with unknown query language?

приве́т! Artur Thanks for your explanations. 2016-07-14 17:20 GMT+02:00 Artur Zakirov : > On 14.07.2016 01:16, Stefan Keller wrote: ... >> * Should I create a synonym dictionary which contains word >> translations en-de instead of synonyms en-en? > > This synonym

Re: [GENERAL] Database Architect - Voleon Capital Management LP

Yes. I was advised of that. Sorry for the mistake. Charles Weitzer Senior Recruiter The Voleon Group char...@voleon.com Office: 510.704.9870 x 7012 Mobile: (510) 558-9182 www.voleon.com Confidential: This e-mail may contain confidential and/or privileged information. If you are not the

Re: [GENERAL] Trouble starting Postgresql after an upgrade

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] > What OS, OS version and architecture for each machine? > > How did you upgrade? CentOS 5.9 on both servers. (Yes, we know it's old, we're moving to 6.7, but we still have some older servers to support and we

Re: [GENERAL] Database Architect - Voleon Capital Management LP

On Wed, Jul 13, 2016 at 1:39 PM, weitzer wrote: > Database Architect > Berkeley > IT > Full-time > > The Voleon Group is a technology-driven investment firm employing > cutting-edge machine learning techniques seeks an exceptionally capable > Database Architect. Your

Re: [GENERAL] Tracking IO Queries

On Wed, Jul 13, 2016 at 3:31 PM, Patrick B wrote: > Hi all, > > I got some IO spikes on my master server. How is that diagnosed? Is it read or write or can't you tell? > But the point is that I was unable > to find the query that caused that, because the query didn't

Re: [GENERAL] Upsert with a partial unique index constraint violation

Awesome. Thanks, Tom. Glad to see this issue has been patched upstream. I'll use the alternative syntax in the meantime. Cheers, Tim On 13 July 2016 at 01:03, Tom Lane wrote: > Peter Geoghegan writes: > > On Mon, Jul 11, 2016 at 12:06 AM, Tim Dawborn

Re: [GENERAL] Trouble starting Postgresql after an upgrade

Kevin Brannen writes: > I’m having a little trouble and I hope someone can point me towards a fix. > ☺ > We’ve been using Pg 9.3.4 and just upgraded to 9.5.1. I’ve installed it > on 1 server and it works. ☺ However, when I copied those binaries over to a > 2nd

Re: [GENERAL] Trouble starting Postgresql after an upgrade

On 07/14/2016 06:58 AM, Kevin Brannen wrote: I’m having a little trouble and I hope someone can point me towards a fix. ☺ We’ve been using Pg 9.3.4 and just upgraded to 9.5.1. I’ve installed it on 1 server and it works. ☺ However, when I copied those binaries over to a 2nd server, I find that

[GENERAL] Trouble starting Postgresql after an upgrade

I'm having a little trouble and I hope someone can point me towards a fix. :) We've been using Pg 9.3.4 and just upgraded to 9.5.1. I've installed it on 1 server and it works. :) However, when I copied those binaries over to a 2nd server, I find that they won't start normally. I can do

[GENERAL] Trouble starting Postgresql after an upgrade

I’m having a little trouble and I hope someone can point me towards a fix. ☺ We’ve been using Pg 9.3.4 and just upgraded to 9.5.1. I’ve installed it on 1 server and it works. ☺ However, when I copied those binaries over to a 2nd server, I find that they won’t start normally. I can do

Re: [GENERAL] pg_restore out of memory

Yes. Both 9.1.8, I checked right now. -- Miguel A Qua, 13-07-2016 às 13:59 -0700, John R Pierce escreveu: > On 7/13/2016 1:51 PM, Miguel Ramos wrote: > > Finally, here are the log messages at the moment of the error. > > It is clearly not while building indices. > > > > The table in question

Re: [GENERAL] FTS with more than one language in body and with unknown query language?

Hi, On 14.07.2016 01:16, Stefan Keller wrote: Hi, I have a text corpus which contains either German or English docs and I expect queries where I don't know if it's German or English. So I'd like e.g. that a query "forest" matches "forest" in body_en but also "Wald" in body_de. I created a

Re: [GENERAL] Server side backend permanent session memory usage ?

"Day, David" writes: > There seems to be an unbounded growth of memory usage by the backend > postgres process representing a "permanent" session in our system. It's hard to evaluate this report with so little information, but there are at least three possible explanations:

[GENERAL] Server side backend permanent session memory usage ?

Hi, There seems to be an unbounded growth of memory usage by the backend postgres process representing a "permanent" session in our system. The size/res values retrieved by running the "top" utility seem to exceed the amount I would expect given the mem and buf tuning parameters of the

Re: [GENERAL] Merging timeseries in postgres

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston Sent: Thursday, 14 July, 2016 08:23 To: Nick Babadzhanian Cc: Tim Smith; pgsql-general Subject: Re: [GENERAL] Merging timeseries in postgres On Thu, Jul 14, 2016 at 8:18 AM, Nick

Re: [GENERAL] Strange array_to_table / unnest result

Hi 2016-07-14 14:55 GMT+02:00 Johann Spies : > When I unnest (regexp_split_to_array) or regexep_split_to_table > > I get one value but the length of the array without the unnest is 193. > > Why would that be? > > wos=# select array_length(regexp_split_to_array(tsv::text,

[GENERAL] Strange array_to_table / unnest result

When I unnest (regexp_split_to_array) or regexep_split_to_table I get one value but the length of the array without the unnest is 193. Why would that be? wos=# select array_length(regexp_split_to_array(tsv::text, E'\\\s+'),1), unnest(regexp_split_to_array(tsv::text, E'\\\s+')) wos-# from

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

Hi, On Wed, 2016-07-13 at 20:56 +, Steve Langlois wrote: > I've been searching for a 9.2.15 version of the postgresql script for "init > script for starting up the PostgreSQL". I have managed to find older versions > than what we are currently using, 8.2.5 but haven't had any luck finding a

Re: [GENERAL] Merging timeseries in postgres

On Thu, Jul 14, 2016 at 8:18 AM, Nick Babadzhanian wrote: > Whats exactly is wrong with the following query? > > select > dx date, > nx, > nx1 > from > test t > join test1 t1 on t.dx=t1.dx1 > ; > > ​Please don't top-post. test t

Re: [GENERAL] Merging timeseries in postgres

Nevermind, I misunderstood your question. The answer is an outer join and if you want the exact output you provided then you can use the following clause. coalesce(dx, dx1) as date Is there any reason why these are two different tables? I'd consider changing data structure. - Original

Re: [GENERAL] Merging timeseries in postgres

Whats exactly is wrong with the following query? select dx date, nx, nx1 from test t join test1 t1 on t.dx=t1.dx1 ; - Original Message - From: "Tim Smith" To: "pgsql-general"

Re: [GENERAL] Merging timeseries in postgres

On Thu, Jul 14, 2016 at 7:56 AM, Tim Smith wrote: > > 2003-01-03 (null) 0.003 ​Where​ did the "0.003" come from? The result you are looking for works if you full outer join on dx1 - at least for the sample data. David J.

[GENERAL] Merging timeseries in postgres

Hi, I've got a bit of query-writers block ! I've tried various join styles but can't get it to do what I want to achieve. Assume I have a bunch of time-series tables : create table test(dx date,n numeric); create table test1(dx1 date,nx1 numeric); insert into test values('2000-01-01','0.001');

Re: [GENERAL] Memory usage per session

Hi >I think the "problem" that he is having is fixable only by changing how >PostgreSQL itself works. >His problem is a PL/pgSQL function which is 11K lines in length. >When invoked, this function is "compiled" into a large tokenized parse tree. >This parse tree is only usable in the session

[GENERAL] Identify ldap connections in logfiles

Is there a way to identify ldap connections to pgsql 9.3 from log files? Thanks, Rick -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_restore out of memory

A Qua, 13-07-2016 às 18:42 -0400, Tom Lane escreveu: > I wrote: > > I'm still suspicious that this might be some sort of NOTICE- > > processing- > > related buffer bloat.  Could you try loading the data with the > > server's > > log_min_messages level cranked down to NOTICE, so you can see from

Re: [GENERAL] pg_restore out of memory

A Qua, 13-07-2016 às 17:15 -0400, Tom Lane escreveu: > Miguel Ramos writes: > > So, what does this mean? > > Was it the client that aborted? I think I saw that "unexpected > > message > > type 0x58" on other types of interruptions. > > Yeah, 0x58 is ASCII 'X'

Re: [GENERAL] pg_restore out of memory

That's 3 years and 3 months with absolutely zero maintenance. Apart from the scripts I left back then. During that time, it was used by an average of 10 people, some 9T of sensor data entered at the rate of 60G/week, and another 3T of analysis data was produced. The expression "cutting down on

Re: [GENERAL] pglogical cascading replication (chaining replication)

I already tried to contact them, but no luck so far. Although it seems to me that the change-set is actually forwarded, its the decoding that is failing on the receiving host. Check the log output for p2 and p3 in my previous message. Regards, Nick. - Original Message - From: "Joshua