[GENERAL] Questionaire: Common WAL write rates on busy servers.

Hi, I've lately seen more and more installations where the generation of write-ahead-log (WAL) is one of the primary bottlenecks. I'm curious whether that's primarily a "sampling error" of mine, or whether that's indeed more common. The primary reason I'm curious is that I'm pondering a few pote

Re: [GENERAL] Protocol 2 and query parameters support

> On 2017-04-24 16:07:01 -0400, Rader, David wrote: >> As Tom mentioned, it sounds like the issue is that Presto expects to only >> use simple query, not extended query (no server-side prepared statements). >> The JDBC driver supports setting the prepare threshold to 0 to disable >> using server-si

Re: [GENERAL] Protocol 2 and query parameters support

On 2017-04-24 16:07:01 -0400, Rader, David wrote: > As Tom mentioned, it sounds like the issue is that Presto expects to only > use simple query, not extended query (no server-side prepared statements). > The JDBC driver supports setting the prepare threshold to 0 to disable > using server-side pre

Re: [GENERAL] Protocol 2 and query parameters support

On Sun, Apr 23, 2017 at 10:33 PM, Tatsuo Ishii wrote: > > Andres Freund writes: > >> On 2017-04-23 12:08:51 -0700, Konstantin Izmailov wrote: > >>> Some systems (Presto) are still using protocol 2, and I need to > understand > >>> the scope of changes in the middleware to support protocol 2. > >

Re: [GENERAL] Postgres 9.6.2 and pg_log

De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 3:15 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 11:27 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>> wrote: log_de

Re: [GENERAL] Block size recommendation for Red Hat Linux 7.2

On Mon, Apr 24, 2017 at 12:43 PM, pinker wrote: > I've seen very big differences with huge_pages set to on, especially in > context of CPU usage on multiple socket servers. > > You could play as well with storage options, for instance inode size and > check if there is any advantage for your db fr

Re: [GENERAL] Postgres 9.6.2 and pg_log

On Mon, Apr 24, 2017 at 11:27 AM, Mark Watson wrote: > > log_destination = 'stderr' # Valid values are > combinations of > > > # stderr, csvlog, syslog, and eventlog, > > > # depending on platform. csvlog > > > # requires logging_collector to be on. > > > > # This is

Re: [GENERAL] Block size recommendation for Red Hat Linux 7.2

I've seen very big differences with huge_pages set to on, especially in context of CPU usage on multiple socket servers. You could play as well with storage options, for instance inode size and check if there is any advantage for your db from inlining, which is supported by xfs. You can find more

Re: [GENERAL] Postgres 9.6.2 and pg_log

De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 2:18 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 10:58 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>> wrote: The lin

[GENERAL] changing type of column on partitionated table.

Hi ! I have Postgresql 9.4, a partitionated table and i must change the type of column. The changes over a master table DDL are applied to the childs? or must I change the inheritance to off and change it one by one? for each child and master table. what is the best way/practice

Re: [GENERAL] Postgres 9.6.2 and pg_log

On Mon, Apr 24, 2017 at 10:58 AM, Mark Watson wrote: > > The lines log_rotation_age and log_rotation_size are commented, and > currently are: > > #log_rotation_age = 1d # Automatic > rotation of logfiles will > > > # happen after that time. 0 disables. > > #log_ro

Re: [GENERAL] Block size recommendation for Red Hat Linux 7.2

Stick to 4k linux block size and you should be OK. I've yet to run into a situation where changing either has made any measurable difference. On Mon, Apr 24, 2017 at 11:58 AM, chiru r wrote: > Thanks Scott. > Please suggest the OS block sizes for Linux redhat 7.2, where as default > Linux block s

Re: [GENERAL] Postgres 9.6.2 and pg_log

De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 1:34 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 8:43 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>> wrote: Good day

Re: [GENERAL] Postgres 9.6.2 and pg_log

De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 1:34 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 8:43 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>> wrote: Good da

Re: [GENERAL] Block size recommendation for Red Hat Linux 7.2

Thanks Scott. Please suggest the OS block sizes for Linux redhat 7.2, where as default Linux block size is 4k. If we keep 8k block size at OS level is it improves PostgreSQL performance? Please suggest what is the suggestible default OS block size for Linux systems to install PostgreSQL. Thanks,

Re: [GENERAL] Postgres 9.6.2 and pg_log

On Mon, Apr 24, 2017 at 8:43 AM, Mark Watson wrote: > Good day all, > > > > I just noticed an anomaly regarding the logging. I have my logging set up > as follows: > > log_filename = 'postgresql-%d.log' > > log_truncate_on_rotation = on > ​I don't see "log_rotation_age" and/or "log_rotation_size

Re: [GENERAL] Block size recommendation for Red Hat Linux 7.2

On Mon, Apr 24, 2017 at 9:41 AM, chiru r wrote: > Hello, > > I am building new server to run PostgreSQL 9.5.4 version on it. Please > provide the recommended Block size for Linux systems. > > We are using PostgreSQL blocks size is 8k default one. > > postgres=# show block_size ; > block_size > --

[GENERAL] Postgres 9.6.2 and pg_log

Good day all, I just noticed an anomaly regarding the logging. I have my logging set up as follows: log_filename = 'postgresql-%d.log' log_truncate_on_rotation = on My log file postgresql-21.log contains only entries for today (April 24). When I restart the service, entries correctly start accu

[GENERAL] Block size recommendation for Red Hat Linux 7.2

Hello, I am building new server to run PostgreSQL 9.5.4 version on it. Please provide the recommended Block size for Linux systems. We are using PostgreSQL blocks size is 8k default one. postgres=# show block_size ; block_size 8192 (1 row) Is there any recommendation for separate

Re: [GENERAL] Failed dependencies for Pgadmin4 Web in Centos 7

On Mon, Apr 24, 2017 at 11:15 AM, Adrian Klaver wrote: > On 04/24/2017 05:06 AM, Clodoaldo Neto wrote: > Please reply to list also > Ccing list > > On Sun, Apr 23, 2017 at 4:58 PM, Adrian Klaver >> mailto:adrian.kla...@aklaver.com>> wrote: >> > > >> I disabled the priorities plugin and got no exc

Re: [GENERAL] Failed dependencies for Pgadmin4 Web in Centos 7

On 04/24/2017 05:20 AM, Clodoaldo Neto wrote: Ccing list. BTW aren't the Python packages better left in the epel repo if possible? I think the Python people will not care since they rely mostly in Pip. Agreed, when I tried out pgAdmin4, I found the easiest way was to set up a virtualenv an

Re: [GENERAL] Failed dependencies for Pgadmin4 Web in Centos 7

On 04/24/2017 05:06 AM, Clodoaldo Neto wrote: Please reply to list also Ccing list On Sun, Apr 23, 2017 at 4:58 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: I disabled the priorities plugin and got no excluded packages but still the same failed dependencies. Installe

Re: [GENERAL] [pgadmin-hackers] file permission on ssl key

On 04/23/2017 07:42 PM, Ashesh Vashi wrote: Hi Jeroen, This is pgAdmin hackers list. Please send mail to pgsql-general@postgresql.org mailing list for your postgresql related queries. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgr

Re: [GENERAL] DROP INDEX CASCADE doesn't want to drop unique constraints?

Ivan Voras wrote: > Hello, > > On trying to drop an index named "employer_employerid_key" which supports a > unique constraint: > >     "employer_employerid_key" UNIQUE CONSTRAINT, btree (employerid) > > I get this error: > > ERROR:  cannot drop index employer_employerid_key because constrain

[GENERAL] DROP INDEX CASCADE doesn't want to drop unique constraints?

Hello, On trying to drop an index named "employer_employerid_key" which supports a unique constraint: "employer_employerid_key" UNIQUE CONSTRAINT, btree (employerid) I get this error: ERROR: cannot drop index employer_employerid_key because constraint employer_employerid_key on table emplo

Re: [GENERAL] Memory consumption for Query

>> Other operations don't really consume much memory. Is there any way to find out that as well. >> You can run "EXPLAIN (ANALYZE) SELECT ..." to see how much memory is used for memory intense operations like sort, hash or materialize. I am aware of it. Sent from Outlook

Re: [GENERAL] Not sure this should be asked here but...

On Sun, 23 Apr 2017 12:31:29 +0200 Ron Ben wrote: > > A simple open source forum system can be enough simetng like php-bb > example: warez-bb.org > > the installation of such system is like 1 hour of work. > > In my point of view something like stack overflow is the best but i'm not > sure

Re: [GENERAL] Not sure this should be asked here but...

On Sun, Apr 23, 2017 at 5:31 AM, Ron Ben wrote: > > A simple open source forum system can be enough simetng like php-bb > example: warez-bb.org > > the installation of such system is like 1 hour of work. > > In my point of view something like stack overflow is the best but i'm not > sure if it's

Re: [GENERAL] Recover PostgreSQL database folder data

On Sat, Apr 22, 2017 at 9:11 AM, Edson Lidorio wrote: > > > On 22-04-2017 06:40, Magnus Hagander wrote: > > > > On Sat, Apr 22, 2017 at 3:05 AM, Cat wrote: > >> On Fri, Apr 21, 2017 at 08:20:38PM -0300, Edson Lidorio wrote: >> > Ls -la /var/lib/pgsql/9.6/data >> > >> > drwx--. 20 postgres p

Re: [GENERAL] Memory consumption for Query

dhaval jaiswal wrote: > How to check how much memory query is consuming. > > Is there tool can check of query consuming memory for the execution or output. > > Let's say for following query how to calculate memory consumption. > > select * from test where id=1; That query will not consume memor

Re: [GENERAL] Not sure this should be asked here but...

On 2017-04-23 12:31, Ron Ben wrote: A simple open source forum system can be enough simetng like php-bb example: warez-bb.org the installation of such system is like 1 hour of work. In my point of view something like stack overflow is the best but i'm not sure if it's open source. Setting u