ioltas

8 ms·

31.
Support parallel btree index builds in PostgreSQL 11(git.postgresql.org)
2 points by ioltas 9y ago|0 comments
32.
by ioltas 9y ago
There has been in the community for a couple of years now a set of patches to support REINDEX CONCURRENTLY, and there have been discussions for having a CLUSTER CONCURRENTLY, but nothing has materialized. Pushing forward into having such pa
33.
by ioltas 9y ago
It would be interesting to have some data like that per country. For example in Japan, I would suspect that the first places are in April and May. The fiscal year beginning on the 2nd of April, couples prefer to be able to put a kid to the
34.
by ioltas 9y ago
A patch implementing channel binding has been presented for integration into Postgres 11: https://commitfest.postgresql.org/14/1153/ . Two channel types are presented: tls-finish and endpoint. Per the RFC 5802, it
35.
by ioltas 9y ago
Equality operations are also cheaper with hash indexes than btree because less data pages need to be fetched, so this can be a gain for certain columns with a high cardinality. You should really look at if those could be used or not, you ma
36.
OpenSSL Security Advisory [28 Aug 2017](openssl.org)
2 points by ioltas 9y ago|0 comments
37.
by ioltas 9y ago
You can enforce a portion of that directly in your .gitconfig: [alias] # Show top level repository root = rev-parse --show-toplevel I have found that useful over time.
38.
Who Contributes to PostgreSQL Development?(rhaas.blogspot.com)
3 points by ioltas 9y ago|0 comments
39.
New Features Coming in PostgreSQL 10(rhaas.blogspot.com)
517 points by ioltas 10y ago|135 comments
40.
by ioltas 10y ago
> Mac is not supported this patch, but is in progress This bit is good to know. As usual Linux support will unlikely happen. You can guess from that as well that SC:R would lack macos support if they are not able to address the existing
41.
by ioltas 10y ago
Long term player here (haven't played in years though), and still having my original key and CD just one meter away from this laptop. Should we consider this version as an upgrade or a sole new game? The protocol remains the same so bo
42.
Faster expression evaluation and targetlist projection in PostgreSQL 10(git.postgresql.org)
2 points by ioltas 10y ago|0 comments
43.
by ioltas 10y ago
Something that the article does not mention: equality operations are cheaper with hash indexes than btree because less data pages need to be fetched. This is good particularly on columns with a high cardinality.
44.
PostgreSQL 10 to support SCRAM-SHA-256 authentication (RFC 5802 and 7677)(git.postgresql.org)
2 points by ioltas 10y ago|0 comments
45.
by ioltas 10y ago
The query VACUUM is being tested via SQL. Now if you are referring to autovacuum, there are no tests directly designed with this purpose in mind. autovacuum is running in any instance running the regression tests as it is always enabled by
46.
by ioltas 10y ago
There are three basic suites of tests: - pg_regress, which is as you say a set of SQL scripts run on a running server with generated output compared to the expected output. There could be multiple expected outputs, see for example float tes
47.
by ioltas 10y ago
Or in short, calling fsync() twice is a tweak under-known: the file itself needs to be flushed, as well as its parent directory.
48.
Native table partitioning for PostgreSQL 10(git.postgresql.org)
7 points by ioltas 10y ago|0 comments
49.
by ioltas 10y ago
The discussion is moving on lately with a refactoring to create an access method handler for tables: https://www.postgresql.org/message-id/d7e41e76-e565-8bc0-4e9... Here is as well some documentation on the matter: ht
50.
Yandex Mail Success Story [video](youtube.com)
110 points by ioltas 10y ago|11 comments
51.
Major features of PostgreSQL 9.6 [pdf](momjian.us)
126 points by ioltas 10y ago|35 comments
52.
by ioltas 10y ago
It is amazing to see the number of projects based on Postgres mentioning that they are trying to achieve multi-master with their own restrictions: * Postgres-R is not multi-master, got discontinued in 2010, and lots most of its meaning afte
53.
by ioltas 10y ago
Thanks for the link. Seeing such companies makes me confident that there will be always alternatives whatever the limitations put by so-said-brand manufacturers are.
54.
by ioltas 10y ago
Japan is getting to that as well these days. A couple of companies are popping up, outlining that they get the price down with such offers while maintaining the connection speed... Up to a certain limit.
55.
by ioltas 10y ago
True. Note as well that 9.4 has introduced recovery_min_apply_delay to somewhat leverage such errors by delaying replication (well actually it delays the moment when WAL records doing transaction commit are applied at recovery, and does so
56.
Uber's Move Away from PostgreSQL(rhaas.blogspot.com)
119 points by ioltas 10y ago|15 comments
57.
PostgreSQL has officially 20 years since the release of Postgres95(git.postgresql.org)
4 points by ioltas 10y ago|0 comments
58.
PostgreSQL 9.6 with Parallel Query vs. TPC-H(rhaas.blogspot.com)
12 points by ioltas 10y ago|2 comments
59.
by ioltas 11y ago
Since the move to open source, more recent upstream changes have been slowly merged in the code base, though they seem to be still on a 8.3 base, still a couple of years worth of code to go through.
60.
by ioltas 11y ago
Congrats to all for the release. That's a lot of work accomplished.

More ›