Re: Oracle vs PG

A Twitter thread from someone who talked with the reporter (also read Werner's statement referenced in the first tweet): https://twitter.com/andy_pavlo/status/1055154039606910976 Mark

Re: Should pg 11 use a lot more memory building an spgist index?

On Tue, Oct 23, 2018 at 20:23:14 -0500, Bruno Wolff III wrote: While reloading a database cluster to move from 10.5 to 11, I'm getting out of memory crashes that I did see when doing reloads on pg 10. The statement flagged in the log is this: 2018-10-23 16:44:34.815 CDT [126839] STATEMENT: A

Compile and build portable postgresql for mac

Hi all, How to compile and build portable postgresql for mac. Can someone point me how the builds are done for general distribution. A script would be appreciated if anyone has it. Regards, Pratik

Portworx snapshots

Hello, We are working on integrating portworx on kubernetes as our volume provider for PostgreSQL. Portworx says that on a running PostgreSQL it can: - replicate volumes for failover - take snapshots of volumes - backup volumes There are some articles describing these capabilities:

Re: How to retrieve the partition info for each partition table?

Hi everyone. Kindly remove me from the email list. Than you. On Wed, Oct 24, 2018 at 11:58 AM Igor Neyman wrote: > > > *From:* Yuxia Qiu [mailto:yuxiaq...@gmail.com ] > *Sent:* Wednesday, October 24, 2018 1:29 PM > *To:* pgsql-general@lists.postgresql.org > *Subject:* How to retrieve the partiti

RE: How to retrieve the partition info for each partition table?

From: Yuxia Qiu [mailto:yuxiaq...@gmail.com] Sent: Wednesday, October 24, 2018 1:29 PM To: pgsql-general@lists.postgresql.org Subject: How to retrieve the partition info for each partition table? HI, I have created some partition table, as example b

RE: How to retrieve the partition info for each partition table?

From: Yuxia Qiu [mailto:yuxiaq...@gmail.com] Sent: Wednesday, October 24, 2018 1:29 PM To: pgsql-general@lists.postgresql.org Subject: How to retrieve the partition info for each partition table? HI, I have created some partition table, as example bellow: CREATE TABLE public.measurement (

How to retrieve the partition info for each partition table?

HI, I have created some partition table, as example bellow: CREATE TABLE public.measurement ( city_id integer NOT NULL, logdate date NOT NULL, peaktemp integer, unitsales integer ) PARTITION BY RANGE (logdate) ; CREATE TABLE public.measurement_y2006m02 PARTITION OF public.measu

Re: Postgres 10, slave not catching up with master

Yes, as stated, the lag went very much down after disabling wal compression, it's manageable at least. Network is 10GB. Lep pozdrav, *Boris Sagadin* InfoSplet, informacijske tehnologije, d.o.o. *www.infosplet.com* | Tel: 0590 / 45 800, GSM: 041 / 337 848 On Wed, Oct 2

Re: Tool for comparing parameters

Check_pgactivity plugin for Nagios can also compare if anyone change any settings. On Wed, 24 Oct 2018 at 8:11 PM, Thomas Kellerer wrote: > bhargav kamineni schrieb am 24.10.2018 um 16:30: > > Is there any opensource or paid tool that compares postgresql database > parameters? (NOT SCHEMA) . >

Re: Tool for comparing parameters

bhargav kamineni schrieb am 24.10.2018 um 16:30: > Is there any opensource or paid tool  that compares postgresql database > parameters? (NOT SCHEMA) . You could dump the content of pg_settings into CSV files (sorted by name) and then run a diff on both CSV files. Thomas

Tool for comparing parameters

Hi Team, Is there any opensource or paid tool that compares postgresql database parameters? (NOT SCHEMA) . Thanks Bhargav K

Re: no libpq.pc for Centos 6 or Centos 7

On 10/24/18 7:10 AM, Steve Clark wrote: On 10/24/2018 09:38 AM, Adrian Klaver wrote: On 10/24/18 6:28 AM, Steve Clark wrote: Hello List, I can't seem to find a pkgconfig file for postgresql on centos 6 or centos 7. Centos packages installed $ rpm -qa|grep postgresql postgresql-server-9.2.24-

Re: no libpq.pc for Centos 6 or Centos 7

On 10/24/2018 09:38 AM, Adrian Klaver wrote: > On 10/24/18 6:28 AM, Steve Clark wrote: >> Hello List, >> >> I can't seem to find a pkgconfig file for postgresql on centos 6 or centos >> 7. >> >> Centos packages installed >> $ rpm -qa|grep postgresql >> postgresql-server-9.2.24-1.el7_5.x86_64 >> p

Re: Deadlock while doing VACUUM and DROP

Michal Merta writes: > I encountered deadlock during DROP TABLE statement: > 2018-10-23 14:49:55 CEST psql > ERROR: deadlock detected > 2018-10-23 14:49:55 CEST psql > DETAIL: Process 89171 waits for > AccessExclusiveLock on relation 17582 of database 16390; blocked by > process 50837. > Pr

Deadlock while doing VACUUM and DROP

Hello everyone, I encountered deadlock during DROP TABLE statement: 2018-10-23 14:49:55 CEST psql > ERROR:  deadlock detected 2018-10-23 14:49:55 CEST psql > DETAIL:  Process 89171 waits for AccessExclusiveLock on relation 17582 of database 16390; blocked by process 50837.     Process 5083

Re: no libpq.pc for Centos 6 or Centos 7

On 10/24/18 6:28 AM, Steve Clark wrote: Hello List, I can't seem to find a pkgconfig file for postgresql on centos 6 or centos 7. Centos packages installed $ rpm -qa|grep postgresql postgresql-server-9.2.24-1.el7_5.x86_64 postgresql-9.2.24-1.el7_5.x86_64 postgresql-devel-9.2.24-1.el7_5.x86_64

Re: Postgres 10, slave not catching up with master

Hi El mié., 24 de oct. de 2018 a la(s) 00:39, Boris Sagadin ( bo...@infosplet.com) escribió: > Yes, times are all identical, set to UTC, ntpd is used. > > log_delay > --- > 15.788175 > > This is delay at this moment, but we graph replication delay and it's > fluctuating between 0 and 30s

no libpq.pc for Centos 6 or Centos 7

Hello List, I can't seem to find a pkgconfig file for postgresql on centos 6 or centos 7. Centos packages installed $ rpm -qa|grep postgresql postgresql-server-9.2.24-1.el7_5.x86_64 postgresql-9.2.24-1.el7_5.x86_64 postgresql-devel-9.2.24-1.el7_5.x86_64 postgresql-libs-9.2.24-1.el7_5.x86_64 Cen

Time-based table design / index selection

I come form a DB background using Oracle (which is quite outdated) and more recently SQL Server, 2012 and 2016, so would like some ideas from the group. I have 2 tables which represent a time-based relationship between various object types, most of which also have a geographical component. There a

Re: Oracle vs PG

Michael Paquier writes: > On Wed, Oct 24, 2018 at 07:31:57AM +0200, Laurenz Albe wrote: > >> I have seen people use savepoints in PostgreSQL to emulate Oracle's >> "statement rollback" behavior: If a statement fails, only the statement >> is undone, but the transaction continues. >> >> If you in

Re: Should pg 11 use a lot more memory building an spgist index?

Bruno Wolff III writes: > If I have a substantial database dump file to provide for reproducing this > do you prefer it on a web server somewhere? I expect that mailing very > large attachments to the lists is a bad idea. No, don't do that. If you can make sample data available for download, o

Re: Should pg 11 use a lot more memory building an spgist index?

On Wed, Oct 24, 2018 at 09:33:48 +0100, Tom Lane wrote: Bruno Wolff III writes: While reloading a database cluster to move from 10.5 to 11, I'm getting out of memory crashes that I did see when doing reloads on pg 10. The statement flagged in the log is this: 2018-10-23 16:44:34.815 CDT [1268

Re: Should pg 11 use a lot more memory building an spgist index?

Bruno Wolff III writes: > While reloading a database cluster to move from 10.5 to 11, I'm getting > out of memory crashes that I did see when doing reloads on pg 10. > The statement flagged in the log is this: > 2018-10-23 16:44:34.815 CDT [126839] STATEMENT: ALTER TABLE ONLY > public.iplocatio