Profile

Cover photo
Thom Brown
AboutPostsPhotosReviews

Stream

Thom Brown

Shared publicly  - 
 
 
Heads-up... there will be a new minor version release for all supported versions of PostgreSQL later this week.
1 comment on original post
1
Add a comment...

Thom Brown

Shared publicly  - 
 
 
A Green School in the Heart of Urban Paris ... "A new primary school opened its doors in September 2014, in Boulogne Billancourt, a commune in the western suburbs of Paris. Topped with a large green roof, the building seeks to be much more than a school, intending to promote science, biodiversity and sustainable development through its architecture and the teaching to be given there. The project was designed by Paris-based Chartier-Dalix Architects who won the winning design in a competition in 2011.

The school features eighteen classrooms, and a sports facility that is open for local residents. The public gymnasium rises to a height of 12 meters, while educational spaces are primarily housed on the ground and first floors, before rising progressively to the third storey. Each grade level has its own playground, and each playground will have a mineral soil treatment decorated with furniture and some trees. An inhabited wall forms the outer boundary of the plot. This wall is made of prefabricated concrete blocks which vary in depth, creating a scalable façade made of crevices and interstices of holes of various sizes that can accommodate vegetation and small birds. ..."

MORE: http://www.amusingplanet.com/2015/01/a-green-school-in-heart-of-urban-paris.html
5 comments on original post
2
1
Liam Jaffray's profile photo
Add a comment...

Thom Brown

Shared publicly  - 
 
Ukip’s energy spokesman Roger Helmer has claimed that the link between rising carbon dioxide levels and human activity is still “open to question”, in an outspoken attack on mainstream climate change science.
65 comments on original post
1
Add a comment...
 
 
http://www.phoronix.com/scan.php?page=news_item&px=MTg2NzQ  PostgreSQL 9.4 is out in time for Christmas with numerous changes for users of this open-source database solution.
View original post
2
2
Stefanie Janine Stölting's profile photoDouglas Hunley's profile photo
Add a comment...

Thom Brown

Shared publicly  - 
 
 
Running an older version of PostgreSQL?  Compare the features of your version with a newer version and see just some of the new features and  improvements you're missing out on.
Feature Matrix. This table outlines which features were added in which version. To get more information about a feature, click the link or hover the mouse pointer over the text. Groups. Backend; Performance; Security; Network; Internationalisation; Platforms; Datatypes; Functions and triggers ...
1 comment on original post
1
Add a comment...

Thom Brown

Shared publicly  - 
 
 
#Badger cull cost over £3,000 for each animal killed - http://www.theguardian.com/environment/2014/nov/14/badger-cull-cost-over-3000-for-each-animal-killed cruel, unnecessary, botched & expensive  - well done, UK gov
Controversial government badger cull cost UK taxpayers £6.3m in the first year, when 1,879 badgers were killed
4 comments on original post
1
Marie De Feo's profile photo
 
Poor Badgers, what a nightmare. x
Add a comment...

Thom Brown

Shared publicly  - 
2
Stefanie Janine Stölting's profile photoRobert Treat's profile photo
2 comments
 
:-)
Add a comment...

Thom Brown

Shared publicly  - 
 
 
Parallelism Update
It's been over a year since I last blogged about parallelism , so I think I'm past due for an update, especially because some exciting things are happening. First, Amit Kapila has published a draft patch for parallel sequential scan .  Many things remain to...
View original post
1
Add a comment...

Thom Brown

Shared publicly  - 
 
 
PostgreSQL 9.4 is out!  Happy Christmas.
18 DECEMBER 2014: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.4, the latest version of the world's leading open source database system. This release adds many new features which enhance PostgreSQL's flexibility, scalability and performance for many different ...
View original post
1
Add a comment...

Thom Brown

Shared publicly  - 
 
 
The 9.4 release candidate has just been released.
The PostgreSQL Global Development Group has released 9.4 RC 1, the first release candiate for the next version of PostgreSQL. This release should be identical to the final version of PostgreSQL 9.4, excepting any fixes for bugs found in the next two weeks. Please download, test, and report what ...
View original post
3
Add a comment...

Thom Brown

Shared publicly  - 
 
 
Did you know that typing !postgresql into duckduckgo.com followed by some text searches the PostgreSQL documentation?
2 comments on original post
2
1
John Graber's profile photo
Add a comment...

Thom Brown

Discussion  - 
 
 
Just tried out PostgreSQL's brand new BRIN indexes:

Table test contains 100 million rows.

Query: SELECT * FROM test WHERE id BETWEEN 10000000 and 10000100;

Indexes on "id" column.

Without any index: 13907.471 ms cold, 11866.753 ms warm
With BTREE index (2166MB): 0.127 ms cold, 0.052 ms warm
With BRIN index (176kB): 7.921 ms cold, 7.368 ms warm

An awesome win for such a tiny index.  Obviously the btree index is faster, but the brin index is over 12,000 times smaller.
2 comments on original post
16
2
Thom Brown's profile photoGreg S's profile photoDavid Radkowski's profile photoTrygve Laugstøl's profile photo
3 comments
Greg S
 
Yeah, sorry, I read a bit more on BRIN and it looks like vacuum is a noop for it. I think you're expected to reindex if it becomes too inefficient currently.
Add a comment...
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 - a year ago
reviewed a year ago
1 review
Map
Map
Map