Re: FPGA optimization ...

2019-11-06 Thread Tomas Vondra
On Wed, Nov 06, 2019 at 03:15:53PM -0800, Andres Freund wrote: Hi, On 2019-11-06 22:54:48 +0100, Tomas Vondra wrote: If we're only talking about FPGA I/O acceleration, essentially FPGA between the database and storage, it's likely possible to get that working without any extensive executor chan

Re: FPGA optimization ...

2019-11-06 Thread Andres Freund
Hi, On 2019-11-06 22:54:48 +0100, Tomas Vondra wrote: > If we're only talking about FPGA I/O acceleration, essentially FPGA > between the database and storage, it's likely possible to get that > working without any extensive executor changes. Essentially create an > FPGA-aware variant of SeqScan a

Re: FPGA optimization ...

2019-11-06 Thread Tomas Vondra
On Wed, Nov 06, 2019 at 11:01:37AM -0700, AJG wrote: From what I have read and benchmarks seen.. FPGA shines for writes (and up to 3x (as opposed to 10x claim) real world for queries from memory) GPU shines/outperforms FPGA for reads. There is a very recent and interesting academic paper[1] on

Re: FPGA optimization ...

2019-11-06 Thread AJG
>From what I have read and benchmarks seen.. FPGA shines for writes (and up to 3x (as opposed to 10x claim) real world for queries from memory) GPU shines/outperforms FPGA for reads. There is a very recent and interesting academic paper[1] on High Performance GPU B-Tree (vs lsm) and the incredibl

Re: FPGA optimization ...

2019-11-04 Thread Gunther
Hi Thomas, you said: For the record, this is not exactly a new thing. Netezza (a PostgreSQL fork started in 1999 IBM) used FPGAs. Now there's swarm64 [1], another PostgreSQL fork, also using FPGAs with newer PostgreSQL releases. yes, I found the swarm thing on Google, and heard about Netezza y

Re: FPGA optimization ...

2019-11-04 Thread Tomas Vondra
On Mon, Nov 04, 2019 at 06:33:15PM -0500, Gunther wrote: The time has come. FPGA optimization is in the palm of our hands (literally a 2 TB 40 GB/s IO PostgreSQL server fits into less than a shoe box), and on Amazon AWS F1 instances. Some demos are beginning to exist: https://github.com

FPGA optimization ...

2019-11-04 Thread Gunther
The time has come. FPGA optimization is in the palm of our hands (literally a 2 TB 40 GB/s IO PostgreSQL server fits into less than a shoe box), and on Amazon AWS F1 instances. Some demos are beginning to exist: https://github.com/Xilinx/data-analytics. <https://github.com/Xilinx/d