Re: [GENERAL] Add relcreated (timestamp) column to pg_class catalog to record the time an object was created

Tom Lane wrote: > Melvin Davidson writes: > > However, Customer Feedback ( > > https://postgresql.uservoice.com/forums/21853-general > > ) does seem to > > indicate it and give positive results. > > I had never heard

Re: [GENERAL] Clarify "allow_system_table_mods"

Adrian Klaver writes: > On 04/25/2016 05:29 PM, Stephen Frost wrote: >> It's not an option *to* initdb, it's an option which is used *by* >> initdb. > That really did not clear things up:) Does it mean that you can > pre-populate the $DATA directory with a

Re: [GENERAL] Columnar store as default for PostgreSQL 10?

>It is not difficult to simulate column store in a row store system if >you're willing to decompose your tables into (what is essentially) >BCNF fragments. It simply is laborious for designers and programmers. I could see a true column store having much better performance than tricking a row

Re: [GENERAL] Clarify "allow_system_table_mods"

On Mon, Apr 25, 2016 at 8:41 PM, Adrian Klaver wrote: > On 04/25/2016 05:29 PM, Stephen Frost wrote: > >> * Melvin Davidson (melvin6...@gmail.com) wrote: >> >>> Hmmm, if you go back a few comments, you will note that per initdb --help >>> there is no such option

Re: [GENERAL] Columnar store as default for PostgreSQL 10?

On Thu, 21 Apr 2016 09:08:22 -0700, "David G. Johnston" wrote: >?I have little experience (and nothing practical) with columnar store but >at a high level I don't see the point. At the high level, it's about avoiding fetching data you don't need. In a row store

Re: [GENERAL] Clarify "allow_system_table_mods"

On 04/25/2016 05:29 PM, Stephen Frost wrote: * Melvin Davidson (melvin6...@gmail.com) wrote: Hmmm, if you go back a few comments, you will note that per initdb --help there is no such option available. It's not an option *to* initdb, it's an option which is used *by* initdb. That really did

Re: [GENERAL] Clarify "allow_system_table_mods"

* Melvin Davidson (melvin6...@gmail.com) wrote: > Hmmm, if you go back a few comments, you will note that per initdb --help > there is no such option available. It's not an option *to* initdb, it's an option which is used *by* initdb. I'm afraid I'm done with this particular discussion.

Re: [GENERAL] Clarify "allow_system_table_mods"

On Mon, Apr 25, 2016 at 8:18 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Monday, April 25, 2016, Stephen Frost wrote: > >> Melvin, >> >> * Melvin Davidson (melvin6...@gmail.com) wrote: >> > So in essence "*Allows modification of the structure of system

Re: [GENERAL] Clarify "allow_system_table_mods"

On Monday, April 25, 2016, Stephen Frost wrote: > Melvin, > > * Melvin Davidson (melvin6...@gmail.com ) wrote: > > So in essence "*Allows modification of the structure of system tables" > does > > NOT allow _structural_ changes (probably only dml changes) > >

Re: [GENERAL] Clarify "allow_system_table_mods"

Melvin, * Melvin Davidson (melvin6...@gmail.com) wrote: > So in essence "*Allows modification of the structure of system tables" does > NOT allow _structural_ changes (probably only dml changes) > and the documentation should be changed to clarify. That would imply that other changes are

Re: [GENERAL] Clarify "allow_system_table_mods"

On Mon, Apr 25, 2016 at 8:05 PM, Stephen Frost wrote: > * Melvin Davidson (melvin6...@gmail.com) wrote: > > Then could you please clarify exactly what structural mods are permitted > by > > *"* > > *Allows modification of the structure of system tables" ?* > > I would say, in

Re: [GENERAL] Clarify "allow_system_table_mods"

* Melvin Davidson (melvin6...@gmail.com) wrote: > Then could you please clarify exactly what structural mods are permitted by > *"* > *Allows modification of the structure of system tables" ?* I would say, in short, those modifications which are implemented by PG developers who know what's safe

Re: [GENERAL] Clarify "allow_system_table_mods"

"David G. Johnston" writes: > On Monday, April 25, 2016, Melvin Davidson wrote: >> I need clarification on allow_system_table_mods parameter > If it's going to prevent the action it should be able to do so without > crashing the server..and I

Re: [GENERAL] Clarify "allow_system_table_mods"

On Mon, Apr 25, 2016 at 7:57 PM, Stephen Frost wrote: > David, Melvin, > > * David G. Johnston (david.g.johns...@gmail.com) wrote: > > On Monday, April 25, 2016, Melvin Davidson wrote: > > > I need clarification on allow_system_table_mods parameter > >

Re: [GENERAL] Clarify "allow_system_table_mods"

On Mon, Apr 25, 2016 at 7:50 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Monday, April 25, 2016, Melvin Davidson wrote: > >> I need clarification on allow_system_table_mods parameter >> Per the documentation: >> *Allows modification of the structure of

Re: [GENERAL] Clarify "allow_system_table_mods"

David, Melvin, * David G. Johnston (david.g.johns...@gmail.com) wrote: > On Monday, April 25, 2016, Melvin Davidson wrote: > > I need clarification on allow_system_table_mods parameter > > Per the documentation: > > *Allows modification of the structure of system tables.*

Re: [GENERAL] Clarify "allow_system_table_mods"

On Monday, April 25, 2016, Melvin Davidson wrote: > I need clarification on allow_system_table_mods parameter > Per the documentation: > *Allows modification of the structure of system tables.* This is used by > initdb. This parameter can only be set at server start. > >

Re: [GENERAL] Error: no connection to the server

On Mon, Apr 25, 2016 at 7:32 PM, Sameer Kumar wrote: > > > On Mon, 25 Apr 2016 15:59 Marco Bambini, wrote: > >> Hi, >> I have a multithreaded C client and sometimes I receive the "no >> connection to the server" error message. >> > > Please add more

Re: [GENERAL] Error: no connection to the server

On Mon, 25 Apr 2016 15:59 Marco Bambini, wrote: > Hi, > I have a multithreaded C client and sometimes I receive the "no connection > to the server" error message. > Please add more details of the - version of Postgres. - Platform and OS details Are you using any Middleware

Re: [GENERAL] Clarify "allow_system_table_mods"

On Mon, Apr 25, 2016 at 4:26 PM, Melvin Davidson wrote: > >my previous answer did not make sense as postgresql.conf is set up by > initdb > Yeah, that kind of puzzles me too. > > >-O allow_system_table_mods = on > Thanks, I'll give that a try and create a new cluster,

Re: [GENERAL] Clarify "allow_system_table_mods"

>my previous answer did not make sense as postgresql.conf is set up by initdb Yeah, that kind of puzzles me too. >-O allow_system_table_mods = on Thanks, I'll give that a try and create a new cluster, then get back to you afterwards. On Mon, Apr 25, 2016 at 4:05 PM, Adrian Klaver

Re: [GENERAL] Clarify "allow_system_table_mods"

On 04/25/2016 09:30 AM, Melvin Davidson wrote: I need clarification on allow_system_table_mods parameter Per the documentation: *Allows modification of the structure of system tables.* This is used by initdb. This parameter can only be set at server start. A millisecond after hitting enter I

Re: [GENERAL] Clarify "allow_system_table_mods"

On 04/25/2016 09:30 AM, Melvin Davidson wrote: I need clarification on allow_system_table_mods parameter Per the documentation: *Allows modification of the structure of system tables.* This is used by initdb. This parameter can only be set at server start. I am reading the above as meaning

Re: [GENERAL] Types of blocks in the `pg_stat_statements`

2016-04-25 15:06 GMT+02:00 Victor Yegorov : > Greetings. > > I cannot get understanding about what different types of blocks means here: > http://www.postgresql.org/docs/current/interactive/pgstatstatements.html > > > I assume, that `shared` are blocks from the

Re: [GENERAL] Calculating Minkowski distance between two rows

I am inclined to go with Francisco's solution Daniel -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Francisco Olarte Sent: April-25-16 10:46 To: Babak Alipour Cc: Adrian Klaver; pgsql-general@postgresql.org Subject:

[GENERAL] Clarify "allow_system_table_mods"

I need clarification on allow_system_table_mods parameter Per the documentation: *Allows modification of the structure of system tables.* This is used by initdb. This parameter can only be set at server start. However, attempting to modify pg_class to add another column fails with

Re: [GENERAL] Intemittendly get "server process (PID 5884) exited with exit code 3"

"Wetzel, Juergen (Juergen)" writes: > I'm working with postgres version 9.3.10 on Windows. From time to time a > postgres process terminates with following messages: > LOG: server process (PID 5884) exited with exit code 3 As far as I can recall at the moment, no Postgres

[GENERAL] Intemittendly get "server process (PID 5884) exited with exit code 3"

Hi, I'm working with postgres version 9.3.10 on Windows. From time to time a postgres process terminates with following messages: LOG: server process (PID 5884) exited with exit code 3 LOG: terminating any other active server processes WARNING: terminating connection because of crash of

Re: [GENERAL] Calculating Minkowski distance between two rows

Hi: On Mon, Apr 25, 2016 at 4:26 PM, Babak Alipour wrote: > That is correct. The function I've written only works when the two tables > are named table_train and table_test; is it possible to generalize that to > take in any two tables? And only when all table_train

Re: [GENERAL] Calculating Minkowski distance between two rows

On 04/25/2016 07:26 AM, Babak Alipour wrote: That is correct. The function I've written only works when the two tables are named table_train and table_test; is it possible to generalize that to take in any two tables? I'm heading out the door and off the top of my head: 1) Get tables names as

Re: [GENERAL] Columnar store as default for PostgreSQL 10?

On Mon, Apr 25, 2016 at 9:20 AM, Alvaro Herrera wrote: > Bráulio Bhavamitra wrote: >> Hi all, >> >> I'm finally having performance issues with PostgreSQL when doing big >> analytics queries over almost the entire database of more than 100gb of >> data. >> >> And what I

Re: [GENERAL] psql color hostname prompt

Hi: On Mon, Apr 25, 2016 at 4:04 PM, Achilleas Mantzios wrote: > Hello, have done that, looked really nice, but unfortunately this resulted > in a lot of garbled output, in case of editing functions, huge queries, up > arrows, etc... Did you use %[ %] to delimit

Re: [GENERAL] psql color hostname prompt

On Mon, Apr 25, 2016 at 08:55:21AM -0500, Cal Heldenbrand wrote: > The only outside tool it requires is lsof to determine the hostname of the > remote socket. Otherwise it uses plain stuff like awk / sec and bash tools. Why would you need lsof to get hostname for remote connection, when you can

Re: [GENERAL] psql color hostname prompt

Hi Cal: On Mon, Apr 25, 2016 at 3:55 PM, Cal Heldenbrand wrote: > I whipped up a psqlrc and companion shell script to provide a colored prompt > with the hostname of the machine you're connected to. It works for both > local sockets and remote connections too. Color may be

Re: [GENERAL] Columnar store as default for PostgreSQL 10?

On Mon, Apr 25, 2016 at 11:20 AM Alvaro Herrera wrote: > Bráulio Bhavamitra wrote: > > Hi all, > > > > I'm finally having performance issues with PostgreSQL when doing big > > analytics queries over almost the entire database of more than 100gb of > > data. > > > > And

Re: [GENERAL] Calculating Minkowski distance between two rows

That is correct. The function I've written only works when the two tables are named table_train and table_test; is it possible to generalize that to take in any two tables? Thanks in advance. >Babak On Mon, Apr 25, 2016 at 10:24 AM, Adrian Klaver wrote: > On

Re: [GENERAL] Calculating Minkowski distance between two rows

On 04/25/2016 07:07 AM, Babak Alipour wrote: Greetings everyone, I'm a novice plpgsql user. For an application, I'm trying to write a user-defined function that takes a row of some table (let's say with k fields) and takes another row from another table (again with k fields); then calculate the

Re: [GENERAL] Columnar store as default for PostgreSQL 10?

Bráulio Bhavamitra wrote: > Hi all, > > I'm finally having performance issues with PostgreSQL when doing big > analytics queries over almost the entire database of more than 100gb of > data. > > And what I keep reading all over the web is many databases switching to > columnar store (RedShift,

[GENERAL] Calculating Minkowski distance between two rows

Greetings everyone, I'm a novice plpgsql user. For an application, I'm trying to write a user-defined function that takes a row of some table (let's say with k fields) and takes another row from another table (again with k fields); then calculate the Euclidean, Manhattan or generally Minkowski

Re: [GENERAL] psql color hostname prompt

On 25/04/2016 16:55, Cal Heldenbrand wrote: Hi everyone, The default psql prompt can be a little frustrating when managing many hosts. Typing the wrong command on the wrong host can ruin your day. ;-) I whipped up a psqlrc and companion shell script to provide a colored prompt with the

[GENERAL] psql color hostname prompt

Hi everyone, The default psql prompt can be a little frustrating when managing many hosts. Typing the wrong command on the wrong host can ruin your day. ;-) I whipped up a psqlrc and companion shell script to provide a colored prompt with the hostname of the machine you're connected to. It

[GENERAL] Types of blocks in the `pg_stat_statements`

Greetings. I cannot get understanding about what different types of blocks means here: http://www.postgresql.org/docs/current/interactive/pgstatstatements.html I assume, that `shared` are blocks from the `shared_buffers` and `temp` are blocks used by temporary files (absence of `dirtied` and

Re: [GENERAL] Background worker plus language handler for Andl: OK?

> ow...@postgresql.org] On Behalf Of David Wilson > I've been reading your posts over the past few days and while I find it fun > to follow, I can't help but wonder why there there is urgency in > reimplementing a protocol within PG itself. I think it's an interesting problem -- glad you find it

Re: [GENERAL] Background worker plus language handler for Andl: OK?

On Mon, Apr 25, 2016 at 03:18:30PM +1000, da...@andl.org wrote: > It seems to me that it should be possible to create a language front > end for Andl by creating a background worker and a language handler. I've been reading your posts over the past few days and while I find it fun to follow, I

Re: [GENERAL] Error: no connection to the server

Marco Bambini wrote: > I have a multithreaded C client and sometimes I receive the "no connection to > the server" error > message. > I haven't found any documentation about it and about how to fix this issue. > > Anyone can point me to the right direction? The error message is reported in

[GENERAL] Error: no connection to the server

Hi, I have a multithreaded C client and sometimes I receive the "no connection to the server" error message. I haven't found any documentation about it and about how to fix this issue. Anyone can point me to the right direction? How can I fix it? Thanks a lot. -- Marco Bambini -- Sent via