Hi all, I have a problem that I just can't seem to solve: I want to divide the count of one table by the count of another - seems simple enough! I created simple VIEWs with counts of the tables, but I just can't grasp the logic! DDL and DML (simplified) at the bottom of post. I tried various combinations of things like basic SELECTs. SELECT avg FROM ((SELECT cnt1 FROM v1)/(SELECT cnt2 FROM v2)); and I also tried to use CTEs as follows: WITH num AS ( SELECT cnt1 FROM v1 ), div AS ( SELECT cnt2 FROM v2 ) SELECT (num.cnt1/div.cnt2); Should you require any further information or if this should be on another list, please don't hesitate to contact me and/or let me know. I would appreciate a short explanation of where I'm going wrong also. TIA and rgs, ================== DDL and DML CREATE TABLE t1 (x INT); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (4); CREATE VIEW v1 AS (SELECT COUNT(*) AS cnt1 FROM t1); CREATE TABLE t2 (y INT); INSERT INTO t2 VALUES (5); INSERT INTO t2 VALUES (5); INSERT INTO t2 VALUES (5); INSERT INTO t2 VALUES (5); INSERT INTO t2 VALUES (5); INSERT INTO t2 VALUES (5); INSERT INTO t2 VALUES (5); INSERT INTO t2 VALUES (5); INSERT INTO t2 VALUES (5); INSERT INTO t2 VALUES (5); INSERT INTO t2 VALUES (5); CREATE VIEW v2 AS (SELECT COUNT(*) AS cnt1 FROM t2); 2018-05-29 7:47 GMT+01:00 Thomas Kellerer <spam_eater@xxxxxxx>: > Andres Freund schrieb am 29.05.2018 um 08:28: >>> But neither the Linux binaries nor the Windows binaries were compiled with the --with-llvm option >>> (will JITting be possible with Windows at all?) >> >> Not in 11. > > I assumed that ;) > Not a real problem. > > But what about Linux binaries with JITting enabled? > I would like to test some of our DWH queries to see if that improves performance > > Or do I need to compile Postgres 11 myself to get that? > > Thomas > > >
