Re: [GENERAL] Recursive Arrays 101

Thanks for that tip, Achilleas. On Wed, Nov 4, 2015 at 7:53 AM, Rob Sargent wrote: > On 11/04/2015 03:03 AM, Achilleas Mantzios wrote: > > Sorry for being kind of late to the party (I was in 2015.PgConf.EU !!), > and not having read > most of the replies, what we have

Re: [GENERAL] Deadlock detected after pg_repack receives SIGINT

On Wed, Nov 4, 2015 at 10:16 PM, Jiří Hlinka wrote: > I'm on pg_repack 1.3.2 (latest sable, no devel version available to check > if it is already fixed). > > Michael: your memories are fresh and clear :-), yes, it is part of a > cleanup rollback. The problem is, that the

Re: [GENERAL] pg_archivecleanup not deleting anything?

On Wed, Nov 4, 2015 at 7:16 PM, Albe Laurenz wrote: > Michael Paquier wrote: The docs mention that "all WAL files" preceding a given point are removed, personally I understand that as "all 16MB-size segments shall die", hence excluding backup and history

Re: [GENERAL] Deadlock detected after pg_repack receives SIGINT

I'll check if the trigger activity was moving on or waiting for a lock from logs. I'm doing simple UPDATES, INSERTs and DELETEs on this table, but frequency of these DMLs is _very_ high (it is a queue table used for a one-way selective [just part of data are replicated] replication of queries

Re: [GENERAL] Drop or alter column under load give ERROR #42804 structure of query does not match function result type:

On Wed, Nov 4, 2015 at 1:31 AM, Tom Lane wrote: > Victor Blomqvist writes: > > In case any of you are interested of recreating this problem, I today had > > the time to create a short example that reproduce the error every time I > > try. > > Hmm. If you just

Re: [GENERAL] Auto-analyse on insert operations

Le 04/11/2015 14:45, Adrian Klaver a écrit : On 11/04/2015 05:32 AM, Bertrand Roos wrote: Hello, I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration): track_counts = on autovacuum = on log_autovacuum_min_duration = -1

Re: [GENERAL] Auto-analyse on insert operations

On 11/04/2015 06:35 AM, Bertrand Roos wrote: Le 04/11/2015 14:45, Adrian Klaver a écrit : On 11/04/2015 05:32 AM, Bertrand Roos wrote: Hello, I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration): track_counts = on autovacuum = on

Re: [GENERAL] MinGW-W64 compile error

"=?UTF-8?Q?Leonardo_M._Ram=c3=a9?=" writes: > El 04/11/15 a las 00:05, Tom Lane escribió: >> Why is it invoking g++ and not gcc? > I don't know. I just installed MinGW, then ./configure, maybe there's an > error in the configure script?. I looked at the configure script

Re: [GENERAL] Query regarding

Hi, On Wed, Nov 4, 2015 at 1:21 AM, M Tarkeshwar Rao < m.tarkeshwar@ericsson.com> wrote: > Hi all, > > We have started to convert some oracle sql scripts and converting them to > postgres, but facing some issues to create table. > > I have some common doubts in create table script ie. > >

Re: [GENERAL] Deadlock detected after pg_repack receives SIGINT

Thanks Jim and Michael for comments. I'm on pg_repack 1.3.2 (latest sable, no devel version available to check if it is already fixed). Michael: your memories are fresh and clear :-), yes, it is part of a cleanup rollback. The problem is, that the pgrepack_drop call this statement: DROP TABLE IF

Re: [GENERAL] Auto-analyse on insert operations

On Wed, 4 Nov 2015 14:32:37 +0100 Bertrand Roos wrote: > > I try to configure auto-analyse task with postgresql 9.4. > I have the following configuration (default configuration): > track_counts = on > autovacuum = on > log_autovacuum_min_duration = -1 >

[GENERAL] Auto-analyse on insert operations

Hello, I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration): track_counts = on autovacuum = on log_autovacuum_min_duration = -1 autovacuum_max_workers = 3 autovacuum_naptime = 300s autovacuum_vacuum_threshold = 50

Re: [GENERAL] Auto-analyse on insert operations

On 11/04/2015 05:32 AM, Bertrand Roos wrote: Hello, I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration): track_counts = on autovacuum = on log_autovacuum_min_duration = -1 autovacuum_max_workers = 3 autovacuum_naptime = 300s

Re: [GENERAL] Recursive Arrays 101

On 11/04/2015 03:03 AM, Achilleas Mantzios wrote: Sorry for being kind of late to the party (I was in 2015.PgConf.EU !!), and not having read most of the replies, what we have been successfully doing for this problem for our app is do it this way : parents int[] -- where parents stores the

Re: [GENERAL] Auto-analyse on insert operations

Le 04/11/2015 14:55, Bill Moran a écrit : On Wed, 4 Nov 2015 14:32:37 +0100 Bertrand Roos wrote: I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration): track_counts = on autovacuum = on

Re: [GENERAL] Auto-analyse on insert operations

On 11/04/2015 07:43 AM, Bertrand Roos wrote: Le 04/11/2015 14:55, Bill Moran a écrit : On Wed, 4 Nov 2015 14:32:37 +0100 Bertrand Roos wrote: I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration):

Re: [GENERAL] Auto-analyse on insert operations

Bertrand Roos writes: > In fact, I was telling the question because I have read on some forums > that the auto vacuum deamon only count dead tuple so only update and > delete operations can cause the scheduling of auto-analyse. That might have been true years ago, don't

Re: [GENERAL] Auto-analyse on insert operations

On Wed, 4 Nov 2015 16:43:57 +0100 Bertrand Roos wrote: > > Le 04/11/2015 14:55, Bill Moran a écrit : > > On Wed, 4 Nov 2015 14:32:37 +0100 > > Bertrand Roos wrote: > >> I try to configure auto-analyse task with postgresql 9.4. > >> I have the

Re: [GENERAL] MinGW-W64 compile error

El 04/11/15 a las 00:05, Tom Lane escribió: "=?UTF-8?Q?Leonardo_M._Ram=c3=a9?=" writes: Hi, I'm trying to build the client library of PostgreSql 9.3.x using this version of MinGW's gcc: ... g++ -DFRONTEND -I../../src/include -I./src/include/port/win32 -DEXEC_BACKEND

[GENERAL] Query regarding

Hi all, We have started to convert some oracle sql scripts and converting them to postgres, but facing some issues to create table. I have some common doubts in create table script ie. ALTER TABLE employee DROP PRIMARY KEY CASCADE; DROP employee CASCADE CONSTRAINTS; CREATE TABLE employee (

Re: [GENERAL] MinGW-W64 compile error

El 04/11/15 a las 06:00, Leonardo M. Ramé escribió: El 04/11/15 a las 00:05, Tom Lane escribió: "=?UTF-8?Q?Leonardo_M._Ram=c3=a9?=" writes: Hi, I'm trying to build the client library of PostgreSql 9.3.x using this version of MinGW's gcc: Nevermind, deleted my MinGW

Re: [GENERAL] Recursive Arrays 101

Sorry for being kind of late to the party (I was in 2015.PgConf.EU !!), and not having read most of the replies, what we have been successfully doing for this problem for our app is do it this way : parents int[] -- where parents stores the path from the node to the root of the tree and then

Re: [GENERAL] pg_archivecleanup not deleting anything?

Michael Paquier wrote: >>> The docs mention that "all WAL files" preceding a given point are >>> removed, personally I understand that as "all 16MB-size segments shall >>> die", hence excluding backup and history files from the stack. But one >>> may understand that "WAL files" means everything in

Re: [GENERAL] Query regarding

Le 4 nov. 2015 10:23 AM, "M Tarkeshwar Rao" a écrit : > > Hi all, > > We have started to convert some oracle sql scripts and converting them to postgres, but facing some issues to create table. > > I have some common doubts in create table script ie. > > ALTER TABLE

Re: [GENERAL] Query regarding

M Tarkeshwar Rao schrieb am 04.11.2015 um 10:21: > Hi all, > > We have started to convert some oracle sql scripts and converting them to > postgres, but facing some issues to create table. > > I have some common doubts in create table script ie. > > ALTER TABLE employee > DROP PRIMARY KEY