Any rules of thumb for work_mem, maintenance_work_mem, shared_buffer, etc.
for a database that DOESN'T anticipate concurrent connections and that is
doing lots of aggregate functions on large tables? All the advice I can
find online on tuning
Thanks Gavin -- would LOVE to. Sadly I'm in a weird situation
where my hardware is not under my control, so I'm stuck making the best of
what I have. Next time though! :)
On Monday, April 14, 2014, Gavin Flower gavinflo...@archidevsys.co.nz
wrote:
On 15/04/14 09:46, Nick Eubank wrote:
Any
Terrific -- thanks Gavin and Jeff! That's incredibly helpful for a n00b
like me!
On Mon, Apr 14, 2014 at 5:29 PM, Gavin Flower gavinflo...@archidevsys.co.nz
wrote:
In this list, please bottom post!
I've added potentially useful advice below.
On 15/04/14 11:39, Nick Eubank wrote
On Mon, Apr 14, 2014 at 5:19 PM, Jeff Janes jeff.ja...@gmail.com wrote:
On Mon, Apr 14, 2014 at 2:46 PM, Nick Eubank nickeub...@gmail.com wrote:
Any rules of thumb for work_mem, maintenance_work_mem, shared_buffer,
etc. for a database that DOESN'T anticipate concurrent connections
On Tuesday, April 15, 2014, Tom Lane t...@sss.pgh.pa.us wrote:
Jeff Janes jeff.ja...@gmail.com writes:
On Tue, Apr 15, 2014 at 9:12 AM, Nick Eubank nickeub...@gmail.com
wrote:
Quick followup Jeff: it seems that I can't set work_mem above about 1gb
(can't get to 2gb. When I update
Hi all,
A few years ago someone said postgres windows can't set working_mem above
about 2 GB (www.postgresql.org/message-id/17895.1315869...@sss.pgh.pa.us --
seems to be same for maintenance_working_mem ). Im finding limit still
present.
I'm doing single user, single connection data intensive
On Wed, Apr 16, 2014 at 1:29 AM, amulsul sul_a...@yahoo.co.in wrote:
Anyone found a work around?
Wouldn't it helpful, setting it in your session?
set work_mem='2000MB';
set maintenance_work_mem='2000MB';
do rest of sql after .
Regards,
Amul Sul
--
View this message in context:
On Wednesday, April 16, 2014, Jeff Janes jeff.ja...@gmail.com wrote:
On Tue, Apr 15, 2014 at 6:36 PM, Nick Eubank
nickeub...@gmail.comjavascript:_e(%7B%7D,'cvml','nickeub...@gmail.com');
wrote:
Hi all,
A few years ago someone said postgres windows can't set working_mem above
about 2 GB