Empty Range Bound Specified for Partition

Dear Professionals, Just i have installed "PostgreSQL 11.1". And i have started to create partitions. I've created RANGE partition table as like below. pgsql> create table test_parent_partition( item_id integer, item_name character varying, item_qty cha

Re: Parallel query and number of connections.

On 11/21/18 9:45 AM, Alessandro Aste wrote: Hi there, we are running postgresql 10.5 on a centos 7 server. We're seeing multiple connections (in pg_stat_activity) from our application with the same query , same user, same application_name, same query_start etc. We are 100% sure the query is

Re: replication lag despite corrective config

How big have been the delays after the new settings? I guess significantly lower than before, right? how much have they decreased? Am Mi., 21. Nov. 2018 um 13:18 Uhr schrieb Rene Romero Benavides < rene.romer...@gmail.com>: > You're welcome. > Since last Saturday when you addressed the 10 hour de

Re: replication lag despite corrective config

You're welcome. Since last Saturday when you addressed the 10 hour delay, with the new settings, have you seen more of such delay incidents? what the previous settings were? Beware that hot_standby_feedback = on and such long queries in the replica can increase bloat in the master, are you measurin

RE: pg_dump out of memory for large table with LOB

Thanks Tom Lane for your answer Same issue for pg_dump and LOB was also reported in https://postgrespro.com/list/thread-id/2211186 Concerning the 25% waste of space we experienced with LOB: We are using LOB because we save jpeg2000 images into the DB. We display them as thumbnails in a 6x10 multi

Parallel query and number of connections.

Hi there, we are running postgresql 10.5 on a centos 7 server. We're seeing multiple connections (in pg_stat_activity) from our application with the same query , same user, same application_name, same query_start etc. We are 100% sure the query is duplicated and not referring to multiple queries

RE: pg_dump out of memory for large table with LOB

JMLessard wrote: > What about updates where the bytea do not changed. Does a new copy of the > bytea will be made in the toast table or new row will point to the original > bytea? > > https://www.postgresql.org/docs/current/storage-toast.html says: > > The TOAST management code is triggered only

Sv: Re: Syndicating PostgreSQL mailing list to Discourse

På onsdag 21. november 2018 kl. 15:53:34, skrev legrand legrand < legrand_legr...@hotmail.com >: Hello, What you are proposing with https://rubytalk.org/ seems very interesting. It offers a quick view on mobile of "latests posts for all sites" in one click,

Re: ODBC Driver for 9.4

On 11/20/18 10:16 PM, Mohammed Siddiqui wrote: what the latest version of their ODBC Driver that supports the 9.4 PG DB ? https://www.postgresql.org/ftp/odbc/versions/ "Unless you have have a specific reason not to do so, you should always download the latest version." So 11.00.. If yo

Re: Syndicating PostgreSQL mailing list to Discourse

On 11/21/18 6:53 AM, legrand legrand wrote: Hello, What you are proposing with https://rubytalk.org/ seems very interesting. It offers a quick view on mobile of "latests posts for all sites" in one click, and many other grouping /filtering options (that miss PostgreSQL website), for users that

Re: Syndicating PostgreSQL mailing list to Discourse

Is there source-code available for rubytalk.org mail-list sync part? st 21. 11. 2018 v 15:53 odesílatel legrand legrand < legrand_legr...@hotmail.com> napsal: > Hello, > > What you are proposing with https://rubytalk.org/ seems very interesting. > > It offers a quick view on mobile of "latests po

Re: Syndicating PostgreSQL mailing list to Discourse

Hello, What you are proposing with https://rubytalk.org/ seems very interesting. It offers a quick view on mobile of "latests posts for all sites" in one click, and many other grouping /filtering options (that miss PostgreSQL website), for users that don't use fat client mailling list system (li

Re: Missing RHEL rpm(pg_catcheck-11) in postgres 11 repo.

Hi, On Fri, 2018-11-09 at 09:53 +, Chatterjee, Satyajit wrote: > We are looking to upgrade our application from Postgres 9.5 to 11x, but we > are unable to find the RPM named 'pg_catcheck-11x' for Redhat: > https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7.5-x86_64/. > > We r

Re: Default Privilege Table ANY ROLE

On Fri, Nov 16, 2018 at 03:17:59PM -0500, Tom Lane wrote: > Stephen Frost writes: > > There was much discussion of being able to have 'FOR ALL ROLES' or > > similar for ALTER DEFAULT PRIVILEGES when it went in, but there was a > > lot of concern about one user getting to define the default privile

ODBC Driver for 9.4

what the latest version of their ODBC Driver that supports the 9.4 PG DB ? Regards, Mohammed Younus Siddiqui