Profile

Cover photo
Thom Brown
AboutPostsPhotosReviews

Stream

Thom Brown

Shared publicly  - 
 
Just to creep you out forever...
1
Add a comment...

Thom Brown

Bloggers  - 
 
An update for my blog entry on horizontal scalability. DML pushdowns!
In my previous blog post about horizontal scalability changes in PostrgreSQL 9.6, I covered pushing sorts and joins to the remote server, but Robert Haas (EnterpriseDB) has just committed a change that allows DML (that's UPDATEs and DELETEs) to be pushed to the remote server too.
10
1
Add a comment...

Thom Brown

Bloggers  - 
 
 
No More Full-Table Vacuums
I just committed a very important patch to PostgreSQL.  The short summary for the patch is " Don't vacuum all-frozen pages. " and it follows up on a patch I committed last week, whose short summary was " Change the format of the VM fork to add a second bit ...
View original post
1
Add a comment...

Thom Brown

Discussion  - 
 
Looking at Peter Eisentraut's slides about the most wanted PostgreSQL features from 5 years ago, I can see that a lot of progress has been made:

1. Materialized views - done

2. Synchronous replication - done

3. Parallel query - committed and coming in 9.6

4. Index-only scans - done

5. MERGE/UPSERT/REPLACE - coming in 9.5

6. Administration and monitoring tools - well, there's pgBadger and pgCluu which are new since then, but there's room for improvement

7. In-place upgrades - done, and online upgrade should also become available once BDR makes it in, probably 9.7.

8. Partitioning - a work in progress with working patches submitted to the community
5
Add a comment...

Thom Brown

Advocacy  - 
 
If you've got a Slashdot account, please upvote the PostgreSQL parallel query post: http://slashdot.org/submission/5221127/postgresql-getting-parallel-query
A major feature PostgreSQL users have requested for some time now is to have the query planner "parallelize" a query. Now, thanks to Robert Haas and Amit Kapila, this has now materialized in the 9.6 branch. Robert Haas writes in his blog entry that so far it only supports splitting up a sequential...
7
Add a comment...

Thom Brown

Bloggers  - 
 
PostgreSQL now has parallel query!  More work to be done, but the basics are there now.
I previously suggested that we might be able to get parallel sequential scan committed to PostgreSQL 9.5. That did not happen. However, I'm pleased to report that I've just committed the first version of parallel sequential...
25
5
Add a comment...

Thom Brown

Bloggers  - 
 
 
Parallel Query Is Getting Better And Better
Back in early November, I reported that the first version of parallel sequential scan had been committed to PostgreSQL 9.6.  I'm pleased to report that a number of significant enhancements have been made since then.  Of those, the two that are by the far th...
View original post
1
Add a comment...

Thom Brown

Bloggers  - 
 
Part 2 of my 4 part series on PostgreSQL 9.6 improvements.
This is part 2 in a 4 part blog series on improvements coming in PostgreSQL 9.6. Part 1 - Horizontal Scalability. Join Pushdown; Sort Pushdown; "Walk and chew gum at the same time". Part 2 - Monitoring. VACUUM progress monitoring; Wait monitoring. Part 3 - Parallelism; Part 4 - Vertical ...
10
Add a comment...

Thom Brown

Bloggers  - 
 
PostgreSQL 9.6 is shaping up to be an impressive release, so I thought I'd try to summarise some of the big features and improvements that it will bring. This certainly won't be exhaustive, but it will touch upon areas I've looked at closely. I'm looking at breaking this down into the following ...
23
10
Add a comment...

Thom Brown

Shared publicly  - 
 
 
PostgreSQL 9.5 is finally here!
7 JANUARY 2016: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.5. This release adds UPSERT capability, Row Level Security, and multiple Big Data features, which will broaden the user base for the world's most advanced database. With these new capabilities, ...
8 comments on original post
1
Add a comment...

Thom Brown

Shared publicly  - 
 
 
PostgreSQL 9.5 beta 2 is now out.  Please help test it to make sure we get everything fixed ready for final release.
The PostgreSQL Global Development Group announces today that the second beta release of PostgreSQL 9.5 is available for download. This release should contain all features and APIs which will be in the final release with few, if any, changes. Users should begin testing their applications against ...
View original post
1
Add a comment...

Thom Brown

Shared publicly  - 
 
Went to the Cornish Seal Sanctuary a couple days ago.  My phone appears to have made a video out of the photos and videos I took there, so here it is. +Seal Sanctuary 
1
Add a comment...
The food here was the best we've ever had. The wellington with roasted vegetables and red wine jus was just wonderful. Also had a delicious almond slice with vanilla soya ice-cream. The staff and very attentive and friendly too. Definitely can't go wrong with this place.
Public - in the last week
reviewed in the last week
Our experience started well, and ended on a very sour note. The first negative incident was when it was stressed to us that we are not to forget to get our food weighed, despite having just confirmed that we knew how it worked there. The food was mostly very nice, and the place spacious and clean. We also had a very courteous and friendly French server. When our meal was finished and we'd settled the bill, we were faced with the same manager at the door who originally greeted us, who then confronted us to confirm that we had actually paid for our meal. I was even still holding my payment card and receipt in my hand, and he had not asked the same of anyone else. He had just wished them a good evening. He showed no interest to ask if we enjoyed our meal, or whether we had a good evening. So I can assume this is because we were dressed more casual than he would have liked. We have never experienced this sort of questioning and suspicion before at any other restaurant, and we found it insulting and offensive. We certainly won't be returning there again, or recommending it to anyone
• • •
Public - a month ago
reviewed a month ago
Good price for great falafels in pitta. Great the you can add your own salad to it too.
Public - 9 months ago
reviewed 9 months ago
5 reviews
Map
Map
Map
Upon walking in, it wasn't clear what we were supposed to do. There were menus on the till desk, and we didn't know whether to take them and sit down, or whether to look at them and order, or order food, sit then pay. The food wasn't great. I had a hot dog which came with soggy sweet potato chips which seemed more like butternut squash chunks. And it came with a tasteless salad. My boyfriend had a burger, which consisted of a tiny tasteless mushy burger in a massive bap. The surroundings inside were over the top. Garish paintings preaching veganism, which I imagine puts any non-vegans off being in there, and vegans don't need preaching to. And the place was adjacent to a gay sex shop and a seedy Thai massage parlour. Overall one of the most uncomfortable, unsatisfactory and disappointing places I've ever been to.
• • •
Public - 9 months ago
reviewed 9 months ago
A welcoming, clean, tidy and comfortable B&B, a short walk from Great Malvern railway station. My room was more than sufficient, had everything I needed, and I was shown where I could find everything upon arrival. The owners were accommodating with regards to my dietary requirements, friendly, and very helpful in directing me to the location of the business I was to work with. Internet access was included, a TV with Freeview was available in the bedroom, and plenty of hot drink options available. The en suite facilities were very clean. It was a very pleasant surprise to find such a place. No doubt, if I need to stay in the area again in future, I'll definitely be returning to Cannara B&B. Couldn't recommend more highly.
• • •
Public - 2 years ago
reviewed 2 years ago