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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Andrus 2008-11-28 20:30:53 Re: Increasing GROUP BY CHAR columns speed
Previous Message Scott Carey 2008-11-28 19:51:07 Re: Increasing GROUP BY CHAR columns speed