On Wed, Apr 15, 2020 at 7:55 PM Robert Haas <robertmh...@gmail.com> wrote: > Yeah. I think we really need to understand the performance > characteristics of pipes better. If they're slow, then anything that > needs to be fast has to work some other way (but we could still > provide a pipe-based slow way for niche uses).
Hmm. Could we learn what we need to know about this by doing something as taking a basebackup of a cluster with some data in it (say, created by pgbench -i -s 400 or something) and then comparing the speed of cat < base.tar | gzip > base.tgz to the speed of gzip < base.tar > base.tgz? It seems like there's no difference between those except that the first one relays through an extra process and an extra pipe. I don't know exactly how to do the equivalent of this on Windows, but I bet somebody does. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
