Re: [GENERAL] Merge join vs merge semi join against primary key

2015-10-10 Thread Jeremy Harris
On 09/10/15 20:52, Sean Rhea wrote: [...] >-> Index Scan using customers_pkey on customers (cost=0.00..64192.97 > rows=184 width=8) (actual time=103.354..126.459 rows=359 loops=1) > Filter: (group_id = 45) > Rows Removed by Filter: 141684 > Total runtime: 146.659 ms [...]

Re: [GENERAL] Trouble setting up replication

2015-10-10 Thread Adrian Klaver
On 10/10/2015 12:02 PM, Chuck Martin wrote: On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote: On 09/05/2015 02:27 PM, Chuck Martin wrote: On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote: On 09/05/2015 11:00 AM, Chuck Martin wrote: I

[GENERAL] *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?

2015-10-10 Thread Steve Petrie, P.Eng.
(Thanks to Adrian Klaver & Rob Stone, for their responses to my earlier posting, subject "[GENERAL] BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?". I worked around the unavailability of sqlstate '0' after a successful SQL command, by creating proxy PHP variables

Re: [GENERAL] Trouble setting up replication

2015-10-10 Thread Chuck Martin
> On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote: > > On 09/05/2015 02:27 PM, Chuck Martin wrote: >>> On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote: >>> >>> On 09/05/2015 11:00 AM, Chuck Martin wrote: > I had added to my

Re: [GENERAL] Trouble setting up replication

2015-10-10 Thread Chuck Martin
> On Oct 10, 2015, at 3:44 PM, Adrian Klaver wrote: > > On 10/10/2015 12:02 PM, Chuck Martin wrote: >> >>> On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote: >>> >>> On 09/05/2015 02:27 PM, Chuck Martin wrote: > On Sep 5, 2015, at 4:29

Re: [GENERAL] *** QUESTION *** After successful 'BEGIN;' command -- why PGSQL_TRANSACTION_ACTIVE and not PGSQL_TRANSACTION_INTRANS?

2015-10-10 Thread Adrian Klaver
On 10/10/2015 11:43 AM, Steve Petrie, P.Eng. wrote: (Thanks to Adrian Klaver & Rob Stone, for their responses to my earlier posting, subject "[GENERAL] BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?". I worked around the unavailability of sqlstate '0' after a successful

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

2015-10-10 Thread Adrian Klaver
On 10/09/2015 08:30 PM, Victor Blomqvist wrote: Note that these errors most of the time only happens very briefly at the same time as the ALTER is run. When I did some experiments today the server in total had around 3k req/s with maybe 0.1% of them touching the table being updated, and the

Re: [GENERAL] Trouble setting up replication

2015-10-10 Thread John R Pierce
On 10/10/2015 12:02 PM, Chuck Martin wrote: I only find one version of pg_basebackup on the replicant server, but CentOS 7 comes with PG 9.2, so I suspect that pg_basebackup is left over from that installation. But I’m not sure how to update that. yum update pg_basebackup did not work. try,