Re: Performance issue: index not used on GROUP BY...

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: gmb <gmbouwer(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance issue: index not used on GROUP BY...
Date: 2014-08-28 12:25:56
Message-ID: CAGnEboj=y5uEYoMudYVU9h-ak082C0TDP0RBDEBs+JMWAr58qQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2014-08-28 14:29 GMT+03:00 gmb <gmbouwer(at)gmail(dot)com>:

> Unfortunately , I don't have a lot of memory available ( 65 connections ,
> work_mem = 64MB in pg conf ).
>

You don't have to change cluster-wide settings here.

You can issue `SET` command from your client right before running your
query, only your session will be affected.

--
Victor Y. Yegorov

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Emi Lu 2014-08-28 14:49:08 Re: autocommit (true/false) for more than 1 million records
Previous Message gmb 2014-08-28 11:29:19 Re: Performance issue: index not used on GROUP BY...