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

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

 



Wow, it's excellent!  :))

probably the next step is:

  ALTER TABLE CACHE ON/OFF;

just to force keeping any table in the cache. What do you think?...

Rgds,
-Dimitri

On 4/5/07, Josh Berkus <josh@xxxxxxxxxxxx> wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate



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

  Powered by Linux