binaries for 11 beta compiled with --with-llvm?
Are there any plans to provide a binary download for the Postgres 11 beta with JITting enabled?
Currently I can't find any packages under https://www.postgresql.org/download/ or http://www.enterprisedb.com/products-services-training/pgbindownload
The only one I found was from BigSQL https://www.openscg.com/bigsql/package-manager/
But neither the Linux binaries nor the Windows binaries were compiled with the --with-llvm option
(will JITting be possible with Windows at all?)
Thanks
Thomas
Hi,
On 2018-05-29 07:54:52 +0200, Thomas Kellerer wrote:
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.
Greetings,
Andres Freund
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
## Thomas Kellerer (spam_eater@gmx.net):
But what about Linux binaries with JITting enabled?
The Debian packages do have JIT enabled.
https://www.postgresql.org/download/linux/debian/
Regards,
Christoph
--
Spare Space
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@gmx.net>:
Show quoted text
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 performanceOr do I need to compile Postgres 11 myself to get that?
Thomas
