Home > mailing lists

Re: Performance issue: index not used on GROUP BY... - Mailing list pgsql-performance

From	Victor Yegorov
Subject	Re: Performance issue: index not used on GROUP BY...
Date	August 28, 2014 15:26:05
Msg-id	CAGnEboj=y5uEYoMudYVU9h-ak082C0TDP0RBDEBs+JMWAr58qQ@mail.gmail.com Whole thread Raw
In response to	Re: Performance issue: index not used on GROUP BY... (gmb <gmbouwer@gmail.com>)
List	pgsql-performance

2014-08-28 14:29 GMT+03:00 gmb <gmbouwer@gmail.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

From: gmb
Date: 28 August 2014, 14:29:25
Subject: Re: Performance issue: index not used on GROUP BY...

From: Emi Lu
Date: 28 August 2014, 17:49:18
Subject: Re: autocommit (true/false) for more than 1 million records