unlogged tables - Mailing list pgsql-performance

From Anibal David Acosta
Subject unlogged tables
Date
Msg-id 005501cca0ad$b9478440$2bd68cc0$@devshock.com
Whole thread Raw
Responses Re: unlogged tables
Re: unlogged tables
List pgsql-performance

Hello, just for clarification.

 

Unlogged tables are not memory tables don’t?

 

If we stop postgres server (normal stop) and start again, all information in unlogged tables still remain?

 

So, can I expect a data loss just in case of crash, power failure or SO crash don’t?

 

In case of crash, is possible that data corruption happened in a unlogged tables?

 

For performance purpose can I use async commit and unlogged tables?

 

 

Thanks!

 

 

 

 

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: where clause + function, execution order
Next
From: Stephen Frost
Date:
Subject: Re: unlogged tables