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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Performance issue: index not used on GROUP BY...
From: Victor Yegorov <vyegorov@xxxxxxxxx>
Date: Thu, 28 Aug 2014 15:25:56 +0300
Cc: "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <1409225359977-5816715.post@n5.nabble.com>

2014-08-28 14:29 GMT+03:00 gmb <gmbouwer@xxxxxxxxx>:

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

References:
- Performance issue: index not used on GROUP BY...
  - From: gmb
- Re: Performance issue: index not used on GROUP BY...
  - From: Victor Yegorov
- Re: Performance issue: index not used on GROUP BY...
  - From: gmb
- Re: Performance issue: index not used on GROUP BY...
  - From: Victor Yegorov
- Re: Performance issue: index not used on GROUP BY...
  - From: gmb

Prev by Date: Re: Performance issue: index not used on GROUP BY...
Next by Date: Re: autocommit (true/false) for more than 1 million records
Previous by thread: Re: Performance issue: index not used on GROUP BY...
Next by thread: Re: Performance issue: index not used on GROUP BY...
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux