Re: hashjoins, index loops to retrieve pk/ux constrains in pg12

2021-09-29 Thread Arturas Mazeika
Hi Tom, I agree that the query needs to be first correct, and second fast. I also agree that this query works only if there are no duplicates among schemas (if one chooses to create a table with the same names and index names and constraint names in a different schema, this would not work). Provid

How to improve cockroach performance with pgbench?

2021-09-29 Thread Fabien COELHO
Hello, I've been playing with CockroachDB, a distributed database system which is more or less compatible with Postgres because it implements the same network protocol. Because if this compatibility, I have used pgbench to setup and run some tests on various AWS VMs (5 identical VMs, going u