On Mon, Nov 27, 2017 at 11:23 AM, Don Seiler wrote:
> Good afternoon.
>
> We run Postgres (currently 9.2, upgrading to 9.6 shortly) in VMWare ESX
> machines. We currently have effective_io_concurrency set to the default of
> 1. I'm told that the data volume is a RAID 6 with 14 data drives and 2
>
On Mon, Jan 8, 2018 at 11:53 PM, Rambabu V wrote:
> Hi Team,
>
> Daily 4000 Archive files are generating and these are occupying more space,
> we are trying to compress wall files with using wal_compression parameter,
> but we are not seeing any change in wal files count, could you please help
> u
On Tue, Jan 9, 2018 at 2:18 PM, Kumar, Virendra
wrote:
> Hello Gurus,
>
> I am struggling to tune a query which is doing join on top of aggregate for
> around 3 million rows. The plan and SQL is attached to the email.
>
> Below is system Details:
>
> PGSQL version – 10.1
>
> OS – RHEL 3.10.0-693.5
On Tue, Jan 9, 2018 at 3:25 PM, Kumar, Virendra
wrote:
> Thank you Scott!
> I have current work_mem set as 4MB, shared_buffers to 8GB, hugepages on.
> I gradually increased the work_mem to 1GB but it did not help a bit. Am I
> missing something obvious.
> From: Scott Marlowe [ma
On Tue, Jan 9, 2018 at 4:09 PM, Kumar, Virendra
wrote:
> It did not seem to help.
> See attachment.
Yeah while it's still writing, it's about half as much but most of the
time seems to be in merging etc multiple data sets. I'm wondering
what non-default values you might have set otherwise. Are y