Re: [GENERAL] Postgres 9.6 Parallel Query

On Thu, Apr 27, 2017 at 6:38 PM, basti wrote: > Hello, > > is there a recomment to set max_worker_processes and > max_parallel_workers_per_gather per cpu core or thread? > This largely depends on what type of processing is done by parallel workers, e.g. if the task

Re: [GENERAL]

Hi, John et al, On Wed, May 10, 2017 at 11:02 PM, John R Pierce wrote: > On 5/10/2017 7:45 PM, Igor Korot wrote: >> >> I found >> this:https://wiki.postgresql.org/wiki/Retrieve_primary_key_columns, >> but now I need >> to connect this with information_schema.columns. >> >>

Re: [GENERAL]

On 5/10/2017 7:45 PM, Igor Korot wrote: I found this:https://wiki.postgresql.org/wiki/Retrieve_primary_key_columns, but now I need to connect this with information_schema.columns. What is best way to do it? Or maybe that query I referenced is completely wrong? if you're using pg_catalog

Re: [GENERAL]

Hi, guys, On Sun, May 7, 2017 at 1:40 PM, Igor Korot wrote: > David, > > On Sun, May 7, 2017 at 8:57 AM, David Rowley > wrote: >> On 8 May 2017 at 00:42, Igor Korot wrote: >>> Basically what I'd like to see is the definition

Re: [GENERAL] Querying a policy

Jeff, * Jean-Francois Bernier (jean.francois.bern...@boreal-is.com) wrote: > We are evaluating migrating our software RLS to Postgres by using policies. Neat! > Having a "FOR UPDATE POLICY" on a table, I was wondering if there is a way to > know, before trying an Update and getting an error,

[GENERAL] Querying a policy

Hi all! We are evaluating migrating our software RLS to Postgres by using policies. Having a "FOR UPDATE POLICY" on a table, I was wondering if there is a way to know, before trying an Update and getting an error, if the current row can be updated ? The goal is to show or hide the edit button

Re: [GENERAL] Python versus Other Languages using PostgreSQL

On 5/10/2017 2:43 PM, Adrian Klaver wrote: 1) Uber 2)Yahoo 3) Instagram and, each of those giant businesses has their own entirely custom 'platforms', so its not really fair to call them 'largest web platforms' as each of those custom platforms is in use at only one business. Sure,

Re: [GENERAL] Python versus Other Languages using PostgreSQL

On 05/10/2017 12:46 PM, Paul Hughes wrote: Adrian Klaver Wrote: Many on this list(myself included) will want to know how you came to that conclusion and I am speaking as someone who uses Python, Django and Postgres. I came to that conclusion when I saw a list of the top 15 websites (based

Re: [GENERAL] Python versus Other Languages using PostgreSQL

Hi Paul, See comments at the end... On 10/05/17 08:00, Paul Hughes wrote: Thank you all for taking the time to answer my questions. I've been out of the programming world for a long time, so I am back to being a newbie. Even if you stay in the game, technology changes - so one has to keep

Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables

Hi Tom, Mathieu, On 2017-05-10 17:02:11 -0400, Tom Lane wrote: > Mathieu Fenniak writes: > > Andres, it seems like the problem is independent of having large data > > manipulations mixed with schema changes. The below test case demonstrates > > it with just schema

Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables

Mathieu Fenniak writes: > Andres, it seems like the problem is independent of having large data > manipulations mixed with schema changes. The below test case demonstrates > it with just schema changes. > Tom, I've tested your patch, and it seems to have a positive

Re: [GENERAL] Python versus Other Languages using PostgreSQL

Adrian Klaver Wrote: >>Many on this list(myself included) will want to know how you came to that conclusion and I am speaking as someone who uses Python, Django and Postgres. I came to that conclusion when I saw a list of the top 15 websites (based on traffic). On that list, *all* of the sites

Re: [GENERAL] relation create time

On Wed, May 10, 2017 at 12:31 PM, Peter Eisentraut < peter.eisentr...@2ndquadrant.com> wrote: > On 5/10/17 12:05, Hu, Patricia wrote: > > I am trying to find out when a table was created in postgresql. Thought > > it would be easy (coming from Oracle world), but haven’t had any luck, > >

Re: [GENERAL] relation create time

Thanks for your prompt reply Peter. Sure I could write a trigger to capture and store it, but for such common functionalities seems to me it would be best to have it in the engine, vs. each application having to write its own trigger and reinvent the wheel. Is there any concerns on adding it

Re: [GENERAL] character encoding of the postgres database

Thank you. On Wed, May 10, 2017 at 12:54 PM, Adrian Klaver wrote: > On 05/10/2017 08:48 AM, Sandeep Gupta wrote: >> >> Currently, the postgres database by has SQL_ASCII encoding. >> >> psql -p 5771 postgres -l >> List of databases >>Name

Re: [GENERAL] logging of application level user in audit trigger

Ok , i do see there is already the handling of application_name in the trigger , this is quite sufficient for my current needs. regds mallah. On Wed, May 10, 2017 at 10:58 PM, Rajesh Mallah wrote: > Hi Scott / List , > > Thanks for the response, > > the

Re: [GENERAL] logging of application level user in audit trigger

Hi Scott / List , Thanks for the response, the application_name usage seems to be more natural as it is something inbuilt. the audit trigger repo seems to have got update only in past 2 years . are there other more active projects doing the same thing ? in my opinion (which may be flawed)

Re: [GENERAL] Upgrading postgresql minor version

On Wed, May 10, 2017 at 9:34 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, May 10, 2017 at 8:13 AM, Ron Ben wrote: > >> Not possible >> https://www.postgresql.org/download/linux/debian/ >> >> To upgrade I do: apt-get install postgresql-9.3 >> There is

Re: [GENERAL] character encoding of the postgres database

On 05/10/2017 08:48 AM, Sandeep Gupta wrote: Currently, the postgres database by has SQL_ASCII encoding. psql -p 5771 postgres -l List of databases Name| Owner | Encoding | Collate | Ctype | Access privileges

Re: [GENERAL] Upgrading postgresql minor version

On Wed, May 10, 2017 at 8:13 AM, Ron Ben wrote: > Not possible > https://www.postgresql.org/download/linux/debian/ > > To upgrade I do: apt-get install postgresql-9.3 > There is no way to "roll back" from here. > I can not choose which version to install, it install the

Re: [GENERAL] relation create time

On 5/10/17 12:05, Hu, Patricia wrote: > I am trying to find out when a table was created in postgresql. Thought > it would be easy (coming from Oracle world), but haven’t had any luck, > especially since we are on RDS and can’t peek at the timestamp on the > file system. Is this information stored

Re: [GENERAL] character encoding of the postgres database

On 5/10/17 11:48, Sandeep Gupta wrote: > Currently, the postgres database by has SQL_ASCII encoding. > Is it possible to start the postgres database with UTF-8 encoding, instead > of modifying it later. This is done when initdb is run, with the --locale and/or --encoding option. -- Peter

[GENERAL] relation create time

I am trying to find out when a table was created in postgresql. Thought it would be easy (coming from Oracle world), but haven't had any luck, especially since we are on RDS and can't peek at the timestamp on the file system. Is this information stored anywhere in the catalog? Or I need to

Re: [GENERAL] Select from tableA - if not exists then tableB

On Tue, May 9, 2017 at 6:00 PM, Patrick B wrote: > SELECT > split_part(n1.path::text, '/'::text, 18)::integer AS id, > split_part(n1.path::text, '/'::text, 14)::integer AS clientid, > lower(n1.md5::text)::character(32) AS md5, 0 AS cont, >

[GENERAL] character encoding of the postgres database

Currently, the postgres database by has SQL_ASCII encoding. psql -p 5771 postgres -l List of databases Name| Owner | Encoding | Collate | Ctype | Access privileges ---+-+---+-+---+- postgres | sandeep

Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables

Hi Andres, Tom, Andres, it seems like the problem is independent of having large data manipulations mixed with schema changes. The below test case demonstrates it with just schema changes. Tom, I've tested your patch, and it seems to have a positive impact for sure. I've documented a test case

Re: [GENERAL] Upgrading postgresql minor version

On Wednesday 10 May 2017 17:13:50 Ron Ben wrote: > Not possible > https://www.postgresql.org/download/linux/debian/ > > To upgrade I do: apt-get install postgresql-9.3 > There is no way to "roll back" from here. > I can not choose which version to install, it install the latest version > packed

Re: [GENERAL] Upgrading postgresql minor version

På onsdag 10. mai 2017 kl. 17:13:50, skrev Ron Ben >: Not possible  https://www.postgresql.org/download/linux/debian/   To upgrade I do: apt-get install postgresql-9.3 There is no way to "roll back" from here. I can not choose which version to

Re: [GENERAL] Upgrading postgresql minor version

Not possible  https://www.postgresql.org/download/linux/debian/   To upgrade I do: apt-get install postgresql-9.3 There is no way to "roll back" from here. I can not choose which version to install, it install the latest version packed for debian. Currently its 9.3.16   The docuntation says that

Re: [GENERAL] Upgrading postgresql minor version

På onsdag 10. mai 2017 kl. 16:55:50, skrev Ron Ben >:   I think you miss understood me. pg_dump dumps the data. the tables, functions and the data saved in them. I have daily backups for this so i'm not worried.   What i'm woried about are the

Re: [GENERAL] Upgrading postgresql minor version

I think you miss understood me. pg_dump dumps the data. the tables, functions and the data saved in them. I have daily backups for this so i'm not worried.   What i'm woried about are the "executables files". These files are what is actualy being updated when you update the version. I want to be

Re: [GENERAL] Python versus Other Languages using PostgreSQL

On 05/09/2017 01:00 PM, Paul Hughes wrote: Thank you all for taking the time to answer my questions. I've been out of the programming world for a long time, so I am back to being a newbie. I was told this is the place for newcomers to ask questions. I apologize if my questions did not contain

Re: [GENERAL] Upgrading postgresql minor version

On Wednesday, May 10, 2017 9:08:16 AM EDT Ron Ben wrote: > Ron, You need to figure out how you can make your email client send something else than base64 encoded HTML with right-aligned text. Your messages are so hard to parse for me I just ignore them, and I assume there's other people

Re: [GENERAL] Python versus Other Languages using PostgreSQL

Thank you all for taking the time to answer my questions. I've been out of the programming world for a long time, so I am back to being a newbie. I was told this is the place for newcomers to ask questions. I apologize if my questions did not contain the necessary sophistication or nuance for some

Re: [GENERAL] Upgrading postgresql minor version

On 05/10/2017 06:08 AM, Ron Ben wrote: I'm about to upgrade my postgresql to the latest 9.3 version On my test server eveything works. However I want to save a backup of my production server before the upgrade... I'm not sure how I do that.

[GENERAL] Upgrading postgresql minor version

I'm about to upgrade my postgresql to the latest 9.3 version   On my test server eveything works. However I want to save a backup of my production server before the upgrade... I'm not sure how I do that.   It says that only system files are changed during upgrade... which folders exactly I need to

Re: [GENERAL] Python versus Other Languages using PostgreSQL

On Mon, May 08, 2017 at 05:45:53PM -0700, Paul Hughes wrote: > Why are Postgres and Python so married, I dare say that's a misconception. However, Python "works so well", that "professional amateurs" (like myself) who gravitate towards PostgreSQL for the obvious reasons might tend to chose

Re: [GENERAL] Convert from LATIN9 to UTF-8 / WAL Replication

On Wed, May 10, 2017 at 5:05 AM, Fabrízio de Royes Mello < fabri...@timbira.com.br> wrote: > > Em ter, 9 de mai de 2017 às 17:40, basti > escreveu: > >> Hello, >> >> I must convert a Latin9 Pg-cluster (Version 9.1) in utf-8 with minimal >> downtime, if possible. >>

Re: [GENERAL] Python versus Other Languages using PostgreSQL

As a long time user of the combination, Postgresql, Python, Django, Flask etc. here are my 2 cents: The frameworks of python; Django (enormous) or Flask (smaller) and there are more, are of superb quality, battle hardened and are used in many many companies and high volume sites around the