Re: Pg10 : Client Configuration for Parallelism ?

2019-04-18 Thread Thomas Kellerer
laurent.decha...@orange.com schrieb am 17.04.2019 um 16:33: Hello Justin and thank you for your clues. Finally I found that putting blank to the option that limits the number of rows to retrieve (which is normal for this kind of tool) allows PostgreSQL to parallelize the query. On jdbc it seems

Re: Best Filesystem for PostgreSQL

2019-04-18 Thread Robert Blayzor
On 4/17/19 6:38 PM, Gunther Schadow wrote: > So looks like XFS won. I like XFS for its ease of use especially when > growing. > > Any ideas on how ZFS might do? ZFS is of course so much more flexible. That would totally depend on your data sets and expectations. If you're doing a LOT of random i

Re: Best Filesystem for PostgreSQL

2019-04-18 Thread Tomas Vondra
On Thu, Apr 18, 2019 at 02:19:28AM +, Stephan Schmidt wrote: my Question was meant for a Debian 9 environment with heavy read/wright load and very high requirements towards Performance and data Consistency Well, that's like asking "which car is the best" unfortunately. There's no good answ

Re: Out of Memory errors are frustrating as heck!

2019-04-18 Thread Tomas Vondra
On Wed, Apr 17, 2019 at 11:52:44PM -0400, Gunther wrote: Hi guys. I don't want to be pushy, but I found it strange that after so much lively back and forth getting to the bottom of this, suddenly my last nights follow-up remained completely without reply. I wonder if it even got received. For t