Hi all,
tl;dr - How can I speed up my count-distinct query?
I apologize in advance if this question has been asked already. I'm
finding the mailing list hard to navigate. I'm trying to speed up a query
that will find a count of distinct emails with in a table using Postgres
9.3.3. The na
going with the Standard Tengu tier as a start. This will
give us 1.7GB of RAM, so hopefully bumping up the work_mem setting
shouldn't be a problem. Does that make sense?
Thanks for the help,
Chris
On Mon, Mar 31, 2014 at 9:15 AM, Tom Lane wrote:
> Christopher Jackson writes:
>
g PG 9.3.3. If this is true, I'm
curious what clever ways people have come up with to mitigate any issues
with the lock.
Thanks again,
Chris
On Tue, Apr 1, 2014 at 7:34 PM, bricklen wrote:
>
> On Sun, Mar 30, 2014 at 12:45 PM, Christopher Jackson
> wrote:
>
>&g
Paquier
wrote:
> 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
&
