Postgres Pro
Downloads
Home   >   mailing lists

Re: Increasing GROUP BY CHAR columns speed - Mailing list pgsql-performance

From Andrus
Subject Re: Increasing GROUP BY CHAR columns speed
Date
Msg-id 8553B7AAE7294B4BAB18B759978ECD24@andrusnotebook
Whole thread Raw
In response to Re: Increasing GROUP BY CHAR columns speed  (Scott Carey <scott@richrelevance.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: Increasing GROUP BY CHAR columns speed
Next
From: "Andrus"
Date:
Subject: Re: Increasing GROUP BY CHAR columns speed