Profile

Cover photo
Christopher Browne
Lives in Toronto, Ontario
314 followers|195,118 views
AboutPostsPhotosVideosReviews

Stream

Christopher Browne

Shared publicly  - 
 
Sometimes defacements really improve things!
1
Ross Ridge's profile photo
 
You might want to rotate that picture.
Add a comment...

Christopher Browne

Shared publicly  - 
 
OK, so the PanAm games are keen on "being a success," but have forbidden interested people from linking to it to do things like saying "Exciting things taking place at PanAm Games in Toronto!  Look...  Here...  Um, oops, they tell me that I'm not licensed to direct you to their web site.  Sorry about that, no sportsing taking place here, go on with your non-PanAm-y business..."
Maybe it’s a case of overzealous lawyering, but the legalese on the official Pan Am Games website states that no one is allowed to link to it without written permission. “Links to this Site are not permitted except with the written consent of TO2015™.
2
Ross Ridge's profile photoDavid Collier-Brown's profile photoPat Wendorf's profile photoLeandro “Lê Corſetti van Utrecht” Guimarães Faria Corcete DUTRA's profile photo
8 comments
 
…or perhaps people will criticize, yet avoid linking, thus diminishing their chances of success.
Add a comment...

Christopher Browne

Shared publicly  - 
 
Some things wanted for #slony  
- Users with very large tables would like parallel data copying.  Given ability to duplicate snapshots (roughly PG 9.2+), this should be quite possible.
- There is a desire for slonik to become a "library", accessible from scripts.  Nice to be able to run it from Python.
- Also wanted: adding tables in a more automated fashion.  A shared library would ease this.
- With library, it is easy to add it in to Postgres as FDW.
- Also easy to set up a REST server.
- Probably also makes integration into PGAdmin4 easier.  pgadmin3 had given up on Slony integration because all it could link to were stored functions that aren't enough.
- Several indicated interest in CANCEL SUBSCRIBE
- Various complaints that when working with HA servers, the cost of adding triggers is punitive due to need to request exclusive locks on tables.
- To reduce locking costs, interest was expressed in CREATE TRIGGER CONCURRENTLY or the like.
- Alternatively, to serve many more use cases, request Postgres 9.6 to have LOCK TABLE DEFERRABLE which waits until it can get the lock quickly.
- DDL was mentioned; it was assortedly mentioned that...
- EXECUTE SCRIPT is painful
- Look at UDR (part of BDR?) for a "DDL blocker" trigger
- Desirable to have a "block DDL" that is optional.
3
Add a comment...

Christopher Browne

Shared publicly  - 
 
At a recent #Emacs meetup, it was suggested that I try out helm mode.  It looks interesting, and there is indeed an el-get recipe for it.

Unfortunately, installation led to sessions failing, as helm takes over (erm, what to call it???) token expansion, and any attempts to open things (c-x c-f, c-x b, and such) leads to complaints about...

Symbol's value as variable is void: unread-command-char

I don't actually see any references to that in the code base, so for now, I'll take a step back from this one.

Note that Helm was once known as anything.el, which I have tried with some success, once upon a time.

FYI, I'm on Emacs 24.4.1, in case this rings any bells for anyone.
Author: Tamas Patrovic (original author), from 2007. At this time, Helm was named Anything . rubikitch rubikitch@ruby-lang.org , from 2008-2011. Helm was still named Anything; Thierry Volpiatto (current maintainer). thierry.volpiatto@gmail.com , from 2011-present. Anything was renamed to Helm ...
1
Greg A. Woods's profile photo
 
That thing looks way too scary for me to use.  I tried Ido, but gave up on it after a day or so as it seemed to get in my way more than help me.
Add a comment...

Christopher Browne

Shared publicly  - 
 
Nice piece on the troubles with silly doctrines surrounding primary keys.
 
Primary Keyvil, reprised
Primary Keyvil was one of the most popular posts on my old blog.  Since the old block has become somewhat inaccessible, and I recently did my Keyvil lightning talk again at pgConf NYC, I thought I'd reprint it here, updated and consolidated. Two actual conv...
View original post
3
Add a comment...
Have him in circles
314 people
Andrew Dunstan's profile photo
Harold Browne's profile photo
Sadik C's profile photo
Alejandro PEREZ CUVIT's profile photo
Mike Kallies's profile photo
Dan Ports's profile photo
Josh Berkus's profile photo
George Christakis's profile photo
Ross Ridge's profile photo

Communities

23 communities

Christopher Browne

Shared publicly  - 
 
One very interesting observation fell out in the #slony  development meeting...  There are cases where users have attempted to migrate from Slony to built-in replication, and headed back, and it expresses a significant case where built-in replication has a big hole...

Built-in replication (and the mechanisms being built atop logical decoding http://www.postgresql.org/docs/9.4/static/logicaldecoding.html have the same issue) has a problem where the database is very busy, having a LOT of WAL updates, but the data that needs to be replicated is a small subset.

In that case, you have a LOT of WAL files that need to be both processed and kept (needs to be kept long enough to ensure data has reached other replicas), and perhaps transported.

I know we had a case at work where we wanted to use WAL replication for a data warehouse system, and found that the nightly re-indexing of certain tables led to a lot more gigabytes of WAL files heading downstream than our network links would permit.

But to not digress further, if the database is otherwise-busy, there will be a LOT of WAL data, and if the updates that need to be replicated are minor in volume, WAL-based capture is turning out to be impractical.  Cheaper to pay for some extra triggers and logging of data (as is done by Slony).
2
Add a comment...

Christopher Browne

Shared publicly  - 
 
Good session this morning about #slony.  It was encouraging to see that there are people still using it, that are finding it still has meaningful use cases over built-in replication, that think that there are further features to be added.
2
Add a comment...

Christopher Browne

Shared publicly  - 
 
Pretty awesome for syslog to impose itself into worsening a database performance problem.

I'll bet the invisible binary logging in systemd adds a few more situations like this! :-)

#postgresql #performance #syslog
2
David Collier-Brown's profile photo
 
Ouch!  I tend to log performance data with openlog("perf", LOG_NOWAIT|LOG..) if I have to use syslog
Add a comment...

Christopher Browne

Shared publicly  - 
3
Ross Ridge's profile photoCamille Goudeseune's profile photoChristopher Browne's profile photo
3 comments
 
Raspberry Pi is a more natural comparison, but the limitations on the latest Mac Air (e.g. - only one port altogether) are so nearly ridiculous to make the connection pretty hilarious.
Add a comment...
People
Have him in circles
314 people
Andrew Dunstan's profile photo
Harold Browne's profile photo
Sadik C's profile photo
Alejandro PEREZ CUVIT's profile photo
Mike Kallies's profile photo
Dan Ports's profile photo
Josh Berkus's profile photo
George Christakis's profile photo
Ross Ridge's profile photo
Communities
23 communities
Basic Information
Gender
Male
Relationship
Single
Work
Occupation
Database Architect
Skills
PostgreSQL, Slony-I, Linux, Unix, Data Conversion
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Toronto, Ontario
Previously
Ottawa, Canada - Ottawa, Canada - Toronto, Canada - Irving, Texas
Pupusas are wonderful, steaks are surprisingly good.
Public - 4 weeks ago
reviewed 4 weeks ago
ATM was out of service when I visited.
Public - 2 years ago
reviewed 2 years ago
My neck feels better...
Public - 2 years ago
reviewed 2 years ago
Food: ExcellentDecor: Very GoodService: Excellent
Public - 2 years ago
reviewed 2 years ago
75 reviews
Map
Map
Map
Has long been THE science fiction (and fantasy) bookstore of Toronto. Friendly, knowledgeable staff, and considerable selection. Sadly, SF has shrunk, as a genre, so there's less excellent stuff than there used to be. This is of course not attributable to any one store. (More to policies at American book chains such as Barnes & Noble and Amazon, but that is a rather deeper tale...)
Quality: ExcellentAppeal: ExcellentService: Excellent
Public - 2 years ago
reviewed 2 years ago
Quite happy with my chicken shawarma...
Food: Very GoodDecor: Very GoodService: Very Good
Public - 2 years ago
reviewed 2 years ago
Food: Very GoodDecor: ExcellentService: Excellent
Public - 2 years ago
reviewed 2 years ago