Postgres Pro
Downloads
Home   >   mailing lists

Re: sort_mem param of postgresql.conf - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: sort_mem param of postgresql.conf
Date
Msg-id 2f4958ff0811120651y2ce2ca82v7b6a88776f004b80@mail.gmail.com
Whole thread Raw
In response to Re: sort_mem param of postgresql.conf  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: sort_mem param of postgresql.conf
Re: sort_mem param of postgresql.conf
List pgsql-general
Tree view

that's on 8.3, by default there was no sort_mem , I hadded it , changed it to 512MB and all of the sudent everything started to fly - wherever it required hudge ammounts of memory for queries. The queries are reports, so they basicaly join few tables, and dump all ofthat content - so it takes a bit of a memory to do it ;)

thanks anyway.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: still gin index creation takes forever
Next
From: Alvaro Herrera
Date:
Subject: Re: sort_mem param of postgresql.conf