Re: temporary tables, indexes, and query plans

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: <jnelson+pgsql@xxxxxxxxxxx>
Subject: Re: temporary tables, indexes, and query plans
From: "Reid Thompson" <Reid.Thompson@xxxxxxxx>
Date: Wed, 27 Oct 2010 14:32:58 -0400
Cc: "Reid Thompson" <Reid.Thompson@xxxxxxxx>, <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <AANLkTikJg7gpP5LOqe5DBFk6iORUefyjx8oJ9aobqr2G@xxxxxxxxxxxxxx>
References: <AANLkTinyFRBAR52m7a43-aUuxpLzwirtp5FWwfOYP2vT@xxxxxxxxxxxxxx> <4CC864F8.3060801@xxxxxxxxxxx> <AANLkTimLX___=XXUMc86tjaxu7ketDpYr2Yd=YJFw0B6@xxxxxxxxxxxxxx> <AANLkTikJg7gpP5LOqe5DBFk6iORUefyjx8oJ9aobqr2G@xxxxxxxxxxxxxx>
Thread-index: Act2BWDida9YmzTARcCvnn4bMkaiUg==
Thread-topic: temporary tables, indexes, and query plans

Title: Re: [PERFORM] temporary tables, indexes, and query plans

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

did you re-analyze?

Follow-Ups:
- Re: temporary tables, indexes, and query plans
  - From: Jon Nelson

References:
- temporary tables, indexes, and query plans
  - From: Jon Nelson
- Re: temporary tables, indexes, and query plans
  - From: Mladen Gogala
- Re: temporary tables, indexes, and query plans
  - From: Jon Nelson
- Re: temporary tables, indexes, and query plans
  - From: Jon Nelson

Prev by Date: Re: Postgres insert performance and storage requirement compared to Oracle
Next by Date: Massive update, memory usage
Previous by thread: Re: temporary tables, indexes, and query plans
Next by thread: Re: temporary tables, indexes, and query plans
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux