Skip site navigation (1) Skip section navigation (2)

Re: Increasing GROUP BY CHAR columns speed

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Scott Carey" <scott(at)richrelevance(dot)com>,"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Increasing GROUP BY CHAR columns speed
Date: 2008-11-28 19:57:43
Message-ID: 8553B7AAE7294B4BAB18B759978ECD24@andrusnotebook (view raw or flat)
Thread:
Lists: pgsql-performance
Application should work with any server starting at 8.1 with any RAM size 
(probably starting at 1 GB).

How to find safe value which does not cause error in SET work_mem command ?

If I use 2 GB maybe this can cause excaption when running in server with 1 
GB RAM where this setting may be not allowed.

Andrus. 


In response to

pgsql-performance by date

Next:From: AndrusDate: 2008-11-28 20:30:53
Subject: Re: Increasing GROUP BY CHAR columns speed
Previous:From: Scott CareyDate: 2008-11-28 19:51:07
Subject: Re: Increasing GROUP BY CHAR columns speed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group