[GENERAL] System aggregation

ScaleMP apparently has a facility where a single system image can be spread over multiple host computers, possibly with guest paravirtualisation, although the non-priced variant only supports memory aggregation. http://www.scalemp.com/products/product-comparison/ There also used to be somethin

[GENERAL] Shrinking TSvectors

Hi, does anyone have any pointers for shrinking tsvectors I have looked at the contents of some of these fields and they contain many details that are not needed. For example... "'+1':935,942 '-0500':72 '-0578':932 '-0667':938 '-266':937 '-873':944 '-9972':945 '/partners/application.html':22

[GENERAL] Not signed yum repository packages

Trying to upgrade 9.4 and 9.5 in Fedora 22: # dnf upgrade ... Error: Package postgresql94-9.4.7-1PGDG.f22.x86_64.rpm is not signed Regards, Clodoaldo

Re: [GENERAL] Not signed yum repository packages

Hi, On Tue, 2016-04-05 at 08:39 -0300, Clodoaldo Neto wrote: > Trying to upgrade 9.4 and 9.5 in Fedora 22: > > # dnf upgrade > ... > Error: Package postgresql94-9.4.7-1PGDG.f22.x86_64.rpm is not signed Sorry about that, I think we are hitting a bug there. Just added missing signatures too all 9

Re: [GENERAL] Shrinking TSvectors

On Tue, Apr 5, 2016 at 2:37 PM, Howard News wrote: > Hi, > > does anyone have any pointers for shrinking tsvectors > > I have looked at the contents of some of these fields and they contain > many details that are not needed. For example... > > "'+1':935,942 '-0500':72 '-0578':932 '-0667':938 '-2

[GENERAL] What does Rows Counted mean

pgAdmin shows this: Name: tableA OID Owner Tablespace Rows (estimated) : 10 Rows (Counted) : not counted What is Rows (Counted) and why it is showing not counted even though the table has been analyzed. thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To ma

Re: [GENERAL] Shrinking TSvectors

On 05.04.2016 14:37, Howard News wrote: Hi, does anyone have any pointers for shrinking tsvectors I have looked at the contents of some of these fields and they contain many details that are not needed. For example... "'+1':935,942 '-0500':72 '-0578':932 '-0667':938 '-266':937 '-873':944 '-997

Re: [GENERAL] What does Rows Counted mean

On 04/05/2016 07:11 AM, Rakesh Kumar wrote: pgAdmin shows this: Name: tableA OID Owner Tablespace Rows (estimated) : 10 Rows (Counted) : not counted What is Rows (Counted) and why it is showing not counted even though the table has been analyzed. Where is the above coming from in pgAd

Re: [GENERAL] Shrinking TSvectors

On 05/04/2016 14:44, Oleg Bartunov wrote: On Tue, Apr 5, 2016 at 2:37 PM, Howard News > wrote: Hi, does anyone have any pointers for shrinking tsvectors I have looked at the contents of some of these fields and they contain many details tha

Re: [GENERAL] Shrinking TSvectors

On Tue, Apr 5, 2016 at 5:37 PM, Howard News wrote: > > > On 05/04/2016 14:44, Oleg Bartunov wrote: > > > > On Tue, Apr 5, 2016 at 2:37 PM, Howard News > wrote: > >> Hi, >> >> does anyone have any pointers for shrinking tsvectors >> >> I have looked at the contents of some of these fields and the

Re: [GENERAL] Shrinking TSvectors

On 04/05/2016 07:37 AM, Howard News wrote: On 05/04/2016 14:44, Oleg Bartunov wrote: On Tue, Apr 5, 2016 at 2:37 PM, Howard News mailto:howardn...@selestial.com>> wrote: Hi, does anyone have any pointers for shrinking tsvectors I have looked at the contents of some of these fi

Re: [GENERAL] Shrinking TSvectors

On 05/04/2016 15:15, Artur Zakirov wrote: On 05.04.2016 14:37, Howard News wrote: Hi, does anyone have any pointers for shrinking tsvectors I have looked at the contents of some of these fields and they contain many details that are not needed. For example... "'+1':935,942 '-0500':72 '-0578

Re: [GENERAL] What does Rows Counted mean

This is on the object browser. When you navigate to the table and click on the table name, you will see the output on the right side and check the Properties tab. On Tue, Apr 5, 2016 at 10:37 AM, Adrian Klaver wrote: > On 04/05/2016 07:11 AM, Rakesh Kumar wrote: >> >> pgAdmin shows this: >> >> Na

Re: [GENERAL] What does Rows Counted mean

On Tue, Apr 5, 2016 at 11:38 AM, Rakesh Kumar wrote: > This is on the object browser. When you navigate to the table and > click on the table name, you will see the output on the right side and > check the Properties tab. > > On Tue, Apr 5, 2016 at 10:37 AM, Adrian Klaver > wrote: > > On 04/05/2

Re: [GENERAL] What does Rows Counted mean

On Tue, Apr 5, 2016 at 1:10 PM, Melvin Davidson wrote: > FYI, in PgAdmin, there is an Option which determines if a _physical row > count_ should be performed if the _estimated_ row count is less than a > specified amount. It defaults to 2000. > To change it, Click on File, Options and under Brow

[GENERAL] Exclude constraint using custom operator

Hello I'd like to use the Nested Set model[1] to represent a hierarchical data structure in PostgreSQL. I'm considering using a single int4range column instead of the traditional two columns (lft and rgt) because the two values do in fact represent a range of integers. This should allow me to a

Re: [GENERAL] What does Rows Counted mean

On 04/05/2016 10:10 AM, Melvin Davidson wrote: FYI, in PgAdmin, there is an Option which determines if a _physical row count_ should be performed if the _estimated_ row count is less than a specified amount. It defaults to 2000. To change it, Click on File, Options and under Browser click P

Re: [GENERAL] What does Rows Counted mean

On Tue, Apr 5, 2016 at 1:37 PM, Adrian Klaver wrote: > On 04/05/2016 10:10 AM, Melvin Davidson wrote: > >> >> >> > >> FYI, in PgAdmin, there is an Option which determines if a _physical row >> count_ should be performed if the _estimated_ row count is less than a >> specified amount. It defaults

Re: [GENERAL] BSD initdb without ICU support and switch later

Hi there. Just wondering if anyone has got ICU support/patch applied to 9.5 yet. We are holding on 9.4 for now but want to get onto 9.5 asap but can't due to the ICU limitation. Any help appreciated. Thanks. -- View this message in context: http://postgresql.nabble.com/BSD-initdb-without-IC

Re: [GENERAL] comparing two JSON objects in 9.3

Wow. This is exactly what I'm looking for . The standard audit from here https://wiki.postgresql.org/wiki/Audit_trigger is not good enough for me - I want to audit only changed values and ignore all other ones. Thank you Felix! Regards, Yuri. -- View this message in context: http://postgresql.

[GENERAL] I can't see wal receiver process in one node

Hi everybody I have a question about the replication process, I have a cluster with three nodes A,B and C in PostgreSQL 9.3 with streaming replication in cascade mode MASTER->SLAVE-SLAVE. The question is a single process that I can't see in Node B but yes I can see it in the Node C. This process

[GENERAL] Problem after replication switchover

Hi, I hope I'm mailing this to the correct mailing list. We get errors inserting into a table: 2016-04-04 07:27:51 CEST [43342-2] @ ERROR: could not read block 28991 in file "base/16390/572026": read only 0 of 8192 bytes 2016-04-04 07:27:51 CEST [43342-3] @ STATEMENT: INSERT INTO (...) VALUES

Re: [GENERAL] PG 9.3.12: Replication appears to have worked, but getting error messages in logs

On 4/4/16 10:57 PM, Michael Paquier wrote: > On Sun, Apr 3, 2016 at 2:50 PM, David Caldwell wrote: >> Hello, >> >> We're using streaming replication. Our technique for spinning up a db >> slave is this: >> >> rsync from master (gross copy) >> pg_start_backup() on server >> rsync from master (corre

Re: [GENERAL] Problem after replication switchover

On Tuesday, April 05, 2016 12:55:04 PM Lars Arvidson wrote: > Is there something I missed in the switchover or could this be a bug? > I'd guess it's probably more like option 3 - Glusterfs ate my database. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] template1 being accessed

On Tue, 5 Apr 2016 14:35 Luca Ferrari, wrote: > (sorry, back to the list) > > On Tue, Apr 5, 2016 at 6:11 AM, John R Pierce wrote: > > its also possible some management software might use it as a default > place > > to connect so they can get a list of databases or whatever . > > This is probabl

Re: [GENERAL] I can't see wal receiver process in one node

On Wed, 6 Apr 2016 03:13 DrakoRod, wrote: > Hi everybody > > I have a question about the replication process, I have a cluster with > three > nodes A,B and C in PostgreSQL 9.3 with streaming replication in cascade > mode > MASTER->SLAVE-SLAVE. The question is a single process that I can't see in

Re: [GENERAL] template1 being accessed

On 4/5/2016 5:35 PM, Sameer Kumar wrote: Or if you are using pgpool for connection pooling/load balancing, it might connect to template1 and do health checks. we're literally talking about maybe one connect per DAY looking at those graphs. a spike at 500m means one connect for 2 data points