Viewing profile — amitlan

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....

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 …

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.

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 …

There is: PostgreSQL 10 New Features With Examples https://h50146.www5.hpe.com/products/software/oe/linux/mains...

BTW, you can also create partitions as foreign tables: https://www.postgresql.org/docs/10.0/static/sql-createforeig...

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...

Postgres is going in this direction starting with the next release: http://www.databasesoup.com/2016/05/changing-postgresql-vers...

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 c…

...this is the beginning, not the end... https://www.postgresql.org/message-id/CA%2BTgmobTxn2%2B0x96h...

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 m…

Not natively, as in there is no PARTITION BY HASH ( ). What limitations do you face when trying to roll-your-own hash partitioning using check constraints (in 9.6)?

or read this chapter (the wiki page's content made into the official documentation): https://www.postgresql.org/docs/devel/static/parallel-query....

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.

> 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://ww…

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 wr…

'Clippings' looks really handy. Thanks!