Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"

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

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
From: Josh Berkus <josh@xxxxxxxxxxxx>
Date: Thu, 5 Apr 2007 11:05:16 -0700
In-reply-to: <5482c80a0704040546q7a27e2cdk8ed8307f0ebb39f8@xxxxxxxxxxxxxx>
Organization: PostgreSQL @ Sun
References: <4612A421.4060808@xxxxxxxxxxxxxxxxxx> <5482c80a0704040134q760dc58fp6eda892ab70eb738@xxxxxxxxxxxxxx> <5482c80a0704040546q7a27e2cdk8ed8307f0ebb39f8@xxxxxxxxxxxxxx>
User-agent: KMail/1.8.2

Dimitri,

> Probably another helpful solution may be to implement:
>
>    ALTER TABLE LOGGING OFF/ON;
>
> just to disable/enable WAL?

Actually, a patch similar to this is currently in the queue for 8.3.  

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco

Follow-Ups:
- Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
  - From: Dimitri

References:
- Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
  - From: Arnau
- Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
  - From: Dimitri

Prev by Date: What do the adminpack functions do? (8.2.3)
Next by Date: Re: What do the adminpack functions do? (8.2.3)
Previous by thread: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
Next by thread: Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
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