Re: Code of Conduct plan

On Fri, Jun 8, 2018 at 7:53 AM, Tom Lane wrote: > Christophe Pettus writes: > > 2. I don't think that there is a country where someone being driven out > of a technical community by harassment is an acceptable local value. > > Yeah, this. People that I've known and respected, and who did not se

Re: Code of Conduct plan

On 06/08/2018 12:09 AM, Gavin Flower wrote: On 08/06/18 16:55, Ron wrote: On 06/07/2018 04:55 AM, Gavin Flower wrote: [snip] The Americans often seem to act as though most people lived in the USA, therefore we should all be bound by what they think is correct! "You" are wearing a tee-shirt

Re: Code of Conduct plan

On Fri, 8 Jun 2018 at 06:01, Gavin Flower wrote: > On 08/06/18 14:21, Christophe Pettus wrote: > >> On Jun 7, 2018, at 02:55, Gavin Flower > wrote: > >> The Americans often seem to act as though most people lived in the USA, > therefore we should all be bound by what they think is correct! > > I

Re: Code of Conduct plan

Christophe Pettus writes: > 2. I don't think that there is a country where someone being driven out of a > technical community by harassment is an acceptable local value. Yeah, this. People that I've known and respected, and who did not seem at all thin-skinned, have left this community because

Re: Code of Conduct plan

On Fri, Jun 8, 2018 at 7:09 AM, Christophe Pettus wrote: > > > On Jun 7, 2018, at 21:00, Gavin Flower > wrote: > > > >> I have to say that this seems like a red herring to me. > > Not entirely. American web sites tend to insist on weird date format, > and insist on the archaic imperial units ra

Re: Code of Conduct plan

On 08/06/18 17:09, Christophe Pettus wrote: [...] It is equally unlikely that the Code of Conduct committee will need to decide what a car is, or whether or not someone has succeeded at university. I'm not trying to be snide, but this does seem to be exactly what I was talking about: When ask

Re: Code of Conduct plan

On 08/06/18 16:55, Ron wrote: On 06/07/2018 04:55 AM, Gavin Flower wrote: [snip] The Americans often seem to act as though most people lived in the USA, therefore we should all be bound by what they think is correct! "You" are wearing a tee-shirt (or hoodie), blue jeans and Nikes, while eatin

Re: Code of Conduct plan

> On Jun 7, 2018, at 21:00, Gavin Flower wrote: > >> I have to say that this seems like a red herring to me. > Not entirely. American web sites tend to insist on weird date format, and > insist on the archaic imperial units rather than the metric system that most > people in the world use.

Re: Code of Conduct plan

On 06/07/2018 04:55 AM, Gavin Flower wrote: [snip] The Americans often seem to act as though most people lived in the USA, therefore we should all be bound by what they think is correct! "You" are wearing a tee-shirt (or hoodie), blue jeans and Nikes, while eating a fast food hamburger, drinki

Re: Code of Conduct plan

On 08/06/18 14:21, Christophe Pettus wrote: On Jun 7, 2018, at 02:55, Gavin Flower wrote: The Americans often seem to act as though most people lived in the USA, therefore we should all be bound by what they think is correct! I have to say that this seems like a red herring to me. Not entirely

Re: Service pgpool

Hi, > below my problem about daemon : > > Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops the > pgpool daemon. > Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered failed > state. > Jun 07 14:06:45 vm02 systemd[1]: pgpool-II-10.service failed. Could you s

Re: Code of Conduct plan

> On Jun 7, 2018, at 02:55, Gavin Flower wrote: > The Americans often seem to act as though most people lived in the USA, > therefore we should all be bound by what they think is correct! I have to say that this seems like a red herring to me. 1. The CoC committee handles actual incidents inv

Re: Query hitting empty tables taking 48 minutes

> On Jun 7, 2018, at 4:58 PM, David G. Johnston > wrote: > > On Thu, Jun 7, 2018 at 3:02 PM, Robert Creager > wrote: > ​[...]​ > job_id | f | 1 | cc54ca5d-0dca-4b35-acd9-e0fe69c6b247 > > IIUC, the system believes​ your job_entry table h

Re: Query hitting empty tables taking 48 minutes

On Thu, Jun 7, 2018 at 3:02 PM, Robert Creager wrote: > Executing with the job_id shown in the stats of the empty table below > (didn’t change after bunches of executions). The job_entry table has very > ephemeral data in general. > > tapesystem=# EXPLAIN ANALYZE EXECUTE foo('cc54ca5d-0dca-4b35-

Re: Query hitting empty tables taking 48 minutes

Re-sending from a subscribed address (sigh). On Jun 7, 2018, at 4:18 PM, Robert wrote: > On Jun 7, 2018, at 2:15 PM, Laurenz Albe > wrote: > > Robert Creager wrote: >> I have a system running FreeBSD 11.1-STABLE, PostgreSQL 9.6.8,Java OpenJDK >> 1.8.0_131, >

RE: Service pgpool

And also the contents of the unit file itself and some more details whether is it the first time you are trying to get it work or it used to work but suddenly stopped working etc. The contents of the unit file could give a clue whether it was some typo or the sequence at which the different dire

Sv: Re: inner join elimination

På torsdag 07. juni 2018 kl. 23:44:04, skrev pinker mailto:pin...@onet.eu>>: As far as I know PostgreSQL does only OUTER JOIN Elimination, with inner join it doesn't work.   See this thread: https://www.postgresql.org/message-id/flat/VisenaEmail.2b.7dfa64bdab147c49.1600d1d9df0%40tc7-visena#Visena

Re: Query hitting empty tables taking 48 minutes

> On Jun 7, 2018, at 3:34 PM, Tom Lane wrote: > > Robert Creager writes: >> Jun 7 17:24:21 blackpearl postgres[10670]: [7737-1] >> db=tapesystem,user=Administrator,app=[unknown],client=127.0.0.1 LOG: >> duration: 2903612.206 ms execute fetch from S_2037436/C_2037437: SELECT * >> FROM ds3

Re: inner join elimination

As far as I know PostgreSQL does only OUTER JOIN Elimination, with inner join it doesn't work. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: Query hitting empty tables taking 48 minutes

Robert Creager writes: > Jun 7 17:24:21 blackpearl postgres[10670]: [7737-1] > db=tapesystem,user=Administrator,app=[unknown],client=127.0.0.1 LOG: > duration: 2903612.206 ms execute fetch from S_2037436/C_2037437: SELECT * > FROM ds3.blob WHERE EXISTS (SELECT * FROM ds3.job_entry WHERE blob

Code of Conduct committee: call for volunteers

The proposed Postgres Code of Conduct [1] calls for an investigation and enforcement committee, which is to be appointed by and ultimately answerable to the core team, though no core members may sit on it. The core team is pleased to announce that Stacey Haysler has agreed to serve as the first Ch

Re: Query hitting empty tables taking 48 minutes

Robert Creager wrote: > I have a system running FreeBSD 11.1-STABLE, PostgreSQL 9.6.8,Java OpenJDK > 1.8.0_131, > jdbc 9.3-1104-jdbc41 which is exhibiting very bizarre behavior. > A query is executing against a couple of tables that have 1 and 0 records in > them. > ds3.job_entry has 0 rows, ds3.

Re: Query hitting empty tables taking 48 minutes

> On Jun 7, 2018, at 1:14 PM, Adrian Klaver wrote: > > On 06/07/2018 11:55 AM, Robert Creager wrote: >>> On Jun 7, 2018, at 12:40 PM, Adrian Klaver >> > wrote: >>> >>> On 06/07/2018 11:17 AM, Robert Creager wrote: I have a system running FreeBSD 11.1-STA

Re: Query hitting empty tables taking 48 minutes

On 06/07/2018 01:13 PM, Adrian Klaver wrote: On 06/07/2018 12:11 PM, Rob Sargent wrote: What's the url doing in "blob_id = ds3.blob.id

Re: Query hitting empty tables taking 48 minutes

> On Jun 7, 2018, at 12:11 PM, Rob Sargent wrote: > > What's the url doing in "blob_id = ds3.blob.id

Re: Query hitting empty tables taking 48 minutes

On 06/07/2018 11:55 AM, Robert Creager wrote: On Jun 7, 2018, at 12:40 PM, Adrian Klaver > wrote: On 06/07/2018 11:17 AM, Robert Creager wrote: I have a system running FreeBSD 11.1-STABLE, PostgreSQL 9.6.8,Java OpenJDK 1.8.0_131, jdbc 9.3-1104-jdbc41 which i

Re: Query hitting empty tables taking 48 minutes

On 06/07/2018 12:11 PM, Rob Sargent wrote: What's the url doing in "blob_id = ds3.blob.id

Re: Query hitting empty tables taking 48 minutes

On 06/07/2018 12:55 PM, Robert Creager wrote: On Jun 7, 2018, at 12:40 PM, Adrian Klaver > wrote: On 06/07/2018 11:17 AM, Robert Creager wrote: I have a system running FreeBSD 11.1-STABLE, PostgreSQL 9.6.8,Java OpenJDK 1.8.0_131, jdbc 9.3-1104-jdbc41 which

Re: Query hitting empty tables taking 48 minutes

> On Jun 7, 2018, at 12:40 PM, Adrian Klaver wrote: > > On 06/07/2018 11:17 AM, Robert Creager wrote: >> I have a system running FreeBSD 11.1-STABLE, PostgreSQL 9.6.8,Java OpenJDK >> 1.8.0_131, jdbc 9.3-1104-jdbc41 which is exhibiting very bizarre behavior. >> A query is executing against a

Re: Query hitting empty tables taking 48 minutes

On 06/07/2018 11:17 AM, Robert Creager wrote: I have a system running FreeBSD 11.1-STABLE, PostgreSQL 9.6.8,Java OpenJDK 1.8.0_131, jdbc 9.3-1104-jdbc41 which is exhibiting very bizarre behavior.  A query is executing against a couple of tables that have 1 and 0 records in them.  ds3.job_entr

Re: json_populate_recordset

On 06/07/2018 09:56 AM, Pavel Stehule wrote: 2018-06-07 18:51 GMT+02:00 Adrian Klaver >: From here: https://www.postgresql.org/docs/10/static/functions-json.html select * from

Re: Service pgpool

On 06/07/2018 11:25 AM, Joshua D. Drake wrote: On 06/07/2018 11:16 AM, Jean Claude wrote: Hi all, below my problem about daemon : Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops the pgpool daemon. Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered fail

Re: Service pgpool

On 06/07/2018 11:16 AM, Jean Claude wrote: Hi all, below my problem about daemon : Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops the pgpool daemon. Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered failed state. Jun 07 14:06:45 vm02 systemd[1]: pgpo

Query hitting empty tables taking 48 minutes

I have a system running FreeBSD 11.1-STABLE, PostgreSQL 9.6.8,Java OpenJDK 1.8.0_131, jdbc 9.3-1104-jdbc41 which is exhibiting very bizarre behavior. A query is executing against a couple of tables that have 1 and 0 records in them. ds3.job_entry has 0 rows, ds3.blob has 1 row. If I execute

Service pgpool

Hi all, below my problem about daemon : Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops the pgpool daemon. Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered failed state. Jun 07 14:06:45 vm02 systemd[1]: pgpool-II-10.service failed. Can you help me? Than

Re: json_populate_recordset

2018-06-07 18:51 GMT+02:00 Adrian Klaver : > From here: > > https://www.postgresql.org/docs/10/static/functions-json.html > > select * from json_populate_record(null::myrowtype, '{"a": 1, "b": ["2", > "a b"], "c": {"d": 4, "e": "a b c"}}') > > What is the null::myrowtype doing? > this function us

json_populate_recordset

From here: https://www.postgresql.org/docs/10/static/functions-json.html select * from json_populate_record(null::myrowtype, '{"a": 1, "b": ["2", "a b"], "c": {"d": 4, "e": "a b c"}}') What is the null::myrowtype doing? Thanks, -- Adrian Klaver adrian.kla...@aklaver.com

Re: Microsoft buys GitHub, is this a threat to open-source

I do not see this as a threat at all. On Tue, Jun 5, 2018 at 1:10 AM Michael Nolan wrote: > Microsoft has bought GitHub for $7.5 billion, is this a threat to the open > source community? > -- > Mike Nolan > >

Re: Microsoft buys GitHub, is this a threat to open-source

On 2018-06-07 12:47, Vik Fearing wrote: On 07/06/18 13:46, Thiemo Kellner wrote: Zitat von Achilleas Mantzios : Who hasn't missed sourceforge ? or ... freshmeat while we'are at it :) I am sticking to sourceforge still. I never understood what people made leave it. For many people, this i

Re: Microsoft buys GitHub, is this a threat to open-source

On 06/07/2018 06:54 AM, Adam Tauno Williams wrote: On Thu, 2018-06-07 at 16:04 +0200, Thiemo Kellner, NHC Barhufpflege wrote: Zitat von Vik Fearing : For many people, this is why sourceforge died: https://en.wikipedia.org/wiki/SourceForge#Project_hijackings_and_bu ndled_malware Wow! I missed t

Re: Microsoft buys GitHub, is this a threat to open-source

On Thu, 2018-06-07 at 16:04 +0200, Thiemo Kellner, NHC Barhufpflege wrote: > Zitat von Vik Fearing : > > For many people, this is why sourceforge died: > > https://en.wikipedia.org/wiki/SourceForge#Project_hijackings_and_bu > > ndled_malware > Wow! I missed that completely. This is grave. That was

Re: Microsoft buys GitHub, is this a threat to open-source

Zitat von Vik Fearing : For many people, this is why sourceforge died: https://en.wikipedia.org/wiki/SourceForge#Project_hijackings_and_bundled_malware Wow! I missed that completely. This is grave. This message was sent using IM

Re: Microsoft buys GitHub, is this a threat to open-source

On Thu, Jun 07, 2018 at 11:57:06AM +0200, Jehan-Guillaume (ioguix) de Rorthais wrote: > How do you backup your projects issues on github? Using the API with some > loops? I personally don't care much about this part. As long as the code survives.. -- Michael signature.asc Description: PGP sign

Re: Microsoft buys GitHub, is this a threat to open-source

On 07/06/18 13:46, Thiemo Kellner wrote: > Zitat von Achilleas Mantzios : > >> Who hasn't missed sourceforge ? or ... freshmeat while we'are at it :) > > I am sticking to sourceforge still. I never understood what people made > leave it. For many people, this is why sourceforge died: https://en.

Re: Microsoft buys GitHub, is this a threat to open-source

On Thu, 2018-06-07 at 13:46 +0200, Thiemo Kellner wrote: > Zitat von Achilleas Mantzios : > > Who hasn't missed sourceforge ? or ... freshmeat while we'are at it > > :) > I am sticking to sourceforge still. I never understood what people   > made leave it. New-and-shiney! I've been involved in O

Re: Microsoft buys GitHub, is this a threat to open-source

Zitat von Achilleas Mantzios : Who hasn't missed sourceforge ? or ... freshmeat while we'are at it :) I am sticking to sourceforge still. I never understood what people made leave it. I was investigating a bit if I should move on to github too but I do not remember what prevented me from d

Re: Microsoft buys GitHub, is this a threat to open-source

> Of course, this only holds for the very relaxed definition of open > source. RMS would/will be using this as a clear example of MS destroying > open source and the weakness of the general open source movement when it > fails to emphasise freedom. He's already said that GitHub isn't appropriate

Re: Microsoft buys GitHub, is this a threat to open-source

On 07/06/2018 13:56, Adam Tauno Williams wrote: On Thu, 2018-06-07 at 11:54 +0100, Paul Linehan wrote: Only to the extent that GitHub was a threat before this. They never embraced Open Source! They cynically portrayed themselves as the developer's best pal when, in fact, they are/were nothing mo

Re: Microsoft buys GitHub, is this a threat to open-source

On Thu, 2018-06-07 at 11:54 +0100, Paul Linehan wrote: > Only to the extent that GitHub was a threat before this. They never > embraced Open Source! > They cynically portrayed themselves as the developer's best pal when, > in fact, they are/were nothing more and nothing less than another > commeric

Re: Microsoft buys GitHub, is this a threat to open-source

> Sourceforge seems to be out of favor, too, so are there any open source > platforms that provide services that sourceforge and github do? In a word: GitLab! Pól... > Rich

Re: Microsoft buys GitHub, is this a threat to open-source

> Microsoft has bought GitHub for $7.5 billion, is this a threat to the open > source community? Only to the extent that GitHub was a threat before this. They never embraced Open Source! They cynically portrayed themselves as the developer's best pal when, in fact, they are/were nothing more and

Re: Microsoft buys GitHub, is this a threat to open-source

On Tue, 5 Jun 2018 10:22:02 +0900 Michael Paquier wrote: [...] > I do so for all my stuff on github for example. How do you backup your projects issues on github? Using the API with some loops?

Re: Code of Conduct plan

On 07/06/18 21:49, Raymond O'Donnell wrote: On 07/06/18 09:04, Pablo Hendrickx wrote: You don't have to be a magician to predict this is going to harm the community. Please keep your American social politics out of Postgres, thank you! As a long-time lurker and occasional participant on this

Re: Code of Conduct plan

On 07/06/18 09:04, Pablo Hendrickx wrote: You don't have to be a magician to predict this is going to harm the community. Please keep your American social politics out of Postgres, thank you! As a long-time lurker and occasional participant on this list, I don't think this has ever been an i

Plans cache eviction from process local Memory

Hi! I would like to know how postgres will behave with a big amount of cached plans from prepared statements on 1 connection. Let's say there is an application level connection pooling and one connection can last for many weeks. Many plans are cached from many prepared statements, is there any post

Re: Unknown database folders in base directory

Re: Adarsh Sharma 2018-06-07 > *drwx-- 2 postgres postgres 163840 Mar 19 18:18 2567078690* > *drwx-- 2 postgres postgres 237568 Mar 19 19:10 2567168798* > *drwx-- 2 postgres postgres 151552 Mar 19 19:19 2567176994* > *drwx-- 2 postgres postgres 172032 Mar 19 19:34 2567193375*

Unknown database folders in base directory

Hi, I was checking one disk space issue in PostgreSQL server and noticed that there are some folders which are not mapping to databases. I am not able to link those folders with any database oid. Can we safely delete those folders after shutting down the postgres? It is recommended to delete any f

Re: Doing a \set through perl DBI ?

David: On Wed, Jun 6, 2018 at 5:36 PM, David Gauthier wrote: > Hi: > > Is there a way to do the equivalent of a "\set foo 1" through perl dbi ? > I tried... > $dbh->do("\\set foo 1"); > and got a syntax error > > Of course, I'd also have to be able to access the value of foo once its set. > I

Re: Code of Conduct plan

You don't have to be a magician to predict this is going to harm the community. Please keep your American social politics out of Postgres, thank you! -- Met vriendelijke groeten, Pablo Hendrickx Open Source DBA +32 489 73 09 37 pablo.hendri...@exitas.be

Re: Code of Conduct plan

On Thu, Jun 7, 2018 at 2:14 AM, Jan Claeys wrote: > On Wed, 2018-06-06 at 07:27 +0200, Chris Travers wrote: > > The real fear here is the code of conduct being co-opted as a weapon > > of world-wide culture war and that's what is driving a lot of the > > resistance here. This is particularly an