Re: temporary tables, indexes, and query plans

From: "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com>
To: <jnelson+pgsql(at)jamponi(dot)net>
Cc: "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: temporary tables, indexes, and query plans
Date: 2010-10-27 18:32:58
Message-ID: 7C0800F63CCF4149AC0FC5EE2A041226D52361@sr002-2k3exc.ateb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 2010-10-27 at 13:23 -0500, Jon Nelson wrote:
> set it to 500 and restarted postgres.

did you re-analyze?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Trenta sis 2010-10-27 18:38:20 Massive update, memory usage
Previous Message Merlin Moncure 2010-10-27 18:28:06 Re: Postgres insert performance and storage requirement compared to Oracle