Postgres Pro
Downloads
Home   >   mailing lists

Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
Date
Msg-id 200704051105.16516.josh@agliodbs.com
Whole thread Raw
In response to Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"  (Dimitri <dimitrik.fr@gmail.com>)
Responses Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"  (Dimitri <dimitrik.fr@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Michael Dengler"
Date:
Subject: What do the adminpack functions do? (8.2.3)
Next
From: "Joshua D. Drake"
Date:
Subject: Re: What do the adminpack functions do? (8.2.3)