Hi Bricklen,
Thanks again for the feedback. The concurrent refresh sounds cool. I
just saw the 9.4 release is tentatively scheduled for later this year. Do
you know what people have been doing for view refreshes in the meantime?
Thanks
On Tue, Apr 1, 2014 at 11:48 PM, Michael Paqui
On Wed, Apr 2, 2014 at 1:22 PM, Christopher Jackson wrote:
>
> Hi Bricklen,
>
> Thanks for the feedback. I'll play around with materialized views. My
> understanding is they have to be manually triggered for refresh
Yep.
> and there's an exclusive lock on the view while the refresh is t
Hi Bricklen,
Thanks for the feedback. I'll play around with materialized views. My
understanding is they have to be manually triggered for refresh and there's
an exclusive lock on the view while the refresh is taking place. Is this
your understanding as well? I'm using PG 9.3.3. If th
On Sun, Mar 30, 2014 at 12:45 PM, Christopher Jackson wrote:
> Hi all,
>
> tl;dr - How can I speed up my count-distinct query?
>
Depending on how often you need to run that query and how important it is
to you, if you are willing to accept a performance hit on
INSERT/UPDATE/DELETE of the "par
On 2014-03-31 19:16:58 +0200, Niels Kristian Schjødt wrote:
> Yes, I could install “perf”, though I’m not familiar with it. What would i
> do? :-)
As root:
perf record -a sleep 5
perf report > my-nice-perf-report.txt
And then send the my-nice-perf-report.txt file.
Locally it's much nicer to see
Sorry, but nothing unusual here either, I have compared the time just before
with the same time the days before and the throughput pattern is exactly the
same. No differences.
Den 31/03/2014 kl. 22.01 skrev Will Platnick :
>
> In New Relic, go back a half hour before the problem started so yo
