Check out https://www.omnisci.com/learn/resources/gpu-database
In summary, you get snappy, interactive query speeds on large data sets. I've ran that locally and the results are pretty amazing compared to Postgres or even Tableau in-memory.
I'm personally more excited about GPUs in stream processing; its just quite a natural fit: https://github.com/rapidsai/cudf