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 error
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
[...]
>
(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 $sql_st
> 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 pg_hba.conf
hostreplication rep 64.
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,
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 S
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 had added to my pg_hba.conf
hostreplication r
> 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 PM, Adrian Klaver
> wrote:
>
> On 09/05/