amitlan

6 ms·

1.
by amitlan 4y ago
If I’m not wrong, I think this situation has changed with the latest Postgres release: https://www.postgresql.org/docs/current/libpq-pipeline-mode....
2.
by amitlan 6y ago
Postgres core hackers are working to ease the limit on max allowable concurrent connections, for example: https://www.postgresql.org/message-id/flat/20200301083601.ew... Maybe the proposal above by itself isn&#x27
3.
by amitlan 7y ago
Today's news is about PostgreSQL 12 GA release. The news you may have seen recently was about few Beta releases in last few months and an RC release last week.
4.
PostgreSQL 12 Released(postgresql.org)
42 points by amitlan 7y ago|1 comments
5.
by amitlan 8y ago
The documentation of creating partitions [1] says this: "When creating a hash partition, a modulus and remainder must be specified. The modulus must be a positive integer, and the remainder must be a non-negative integer less than the
6.
by amitlan 8y ago
There is: PostgreSQL 10 New Features With Examples https://h50146.www5.hpe.com/products/software/oe/linux/mains...
7.
by amitlan 9y ago
BTW, you can also create partitions as foreign tables: https://www.postgresql.org/docs/10.0/static/sql-createforeig...
8.
by amitlan 9y ago
Unfortunately, foreign keys won't be supported right away. Read about the new feature and its limitations here: https://www.postgresql.org/docs/devel/static/ddl-partitionin...
9.
by amitlan 10y ago
Postgres is going in this direction starting with the next release: http://www.databasesoup.com/2016/05/changing-postgresql-vers...
10.
by amitlan 10y ago
Note that there is no shorthand syntax (yet), where you define a partitioned schema in just one line of DDL. As of now, you still need to create the root partitioned table as one command specifying the partitioning method (list or range), p
11.
by amitlan 10y ago
...this is the beginning, not the end... https://www.postgresql.org/message-id/CA%2BTgmobTxn2%2B0x96h...
12.
by amitlan 10y ago
Yes, it is not possible to optimize (ie, prune useless partitions for quicker access) the query select * from tab where key = x. You'd need actual hash partitioning for that. The mechanism Postgres uses to perform partition-pruning (
13.
by amitlan 10y ago
Not natively, as in there is no PARTITION BY HASH (<list-of-columns>). What limitations do you face when trying to roll-your-own hash partitioning using check constraints (in 9.6)?
14.
by amitlan 10y ago
or read this chapter (the wiki page's content made into the official documentation): https://www.postgresql.org/docs/devel/static/parallel-query....
15.
Parallel Query (PostgreSQL 9.6)(wiki.postgresql.org)
3 points by amitlan 10y ago|1 comments
16.
by amitlan 10y ago
Greenplum is a fork of Postgres codebase, Citus is not; it's an extension that leverages community Postgres's extensibilty APIs. This point seems to be highlighted in their post.
17.
by amitlan 11y ago
> What's worse is there's 0 indication of how long a vacuum is going to take, nor progress updates while it's going. Upcoming 9.6 will help with this to a certain degree: http://www.postgresql.org/docs&#x2F
18.
Pgsql: Support parallel joins, and make related improvements(postgresql.org)
1 points by amitlan 11y ago|0 comments
19.
PostgreSQL Past, Present, and Future: Moving the Goalposts(rhaas.blogspot.com)
3 points by amitlan 11y ago|0 comments
20.
PostgreSQL goes parallel(postgresql.org)
5 points by amitlan 11y ago|0 comments
21.
Planning Parallel and Distributed Queries (Postgres)(docs.google.com)
3 points by amitlan 11y ago|0 comments
22.
by amitlan 11y ago
Not quite sure whether something like multixact data corruption is symptomatic of the kind of underlying issues in database system implementations that Jepsen is after. I may be wrong though.
23.
by amitlan 11y ago
'Clippings' looks really handy. Thanks!
24.
PostgreSQL 9.5 Alpha 1 Released(postgresql.org)
6 points by amitlan 11y ago|1 comments
25.
Goodbye jsonb_replace, hello jsonb_set (Postgres)(adpgtech.blogspot.com)
2 points by amitlan 11y ago|0 comments
26.
by amitlan 11y ago
I love Ippudo's spiciest on the menu, here in Tokyo. Supposed to be Hakata-style. Like to top it with gyoza.
27.
What's new in PostgreSQL 9.5(wiki.postgresql.org)
9 points by amitlan 11y ago|1 comments
28.
by amitlan 11y ago
Just added a line to that page saying it's in, :)
29.
Pgsql: Support Grouping Sets, Cube, and Rollup(postgresql.org)
69 points by amitlan 11y ago|20 comments
30.
by amitlan 11y ago
SQLSTATE does serve the role somewhat

More ›