Re: [GENERAL] Performance while loading data and indexing

From: Florian Weimer <Weimer(at)CERT(dot)Uni-Stuttgart(dot)DE>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Performance while loading data and indexing
Date: 2002-09-27 19:01:38
Message-ID: 87hegbjlyl.fsf@Login.CERT.Uni-Stuttgart.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> We'd be happiest with a filesystem that journals its own metadata and
> not the user data in the file(s). I dunno if there are any.

Most journalling file systems work this way. Data journalling is not
very widespread, AFAIK.

--
Florian Weimer Weimer(at)CERT(dot)Uni-Stuttgart(dot)DE
University of Stuttgart http://CERT.Uni-Stuttgart.DE/people/fw/
RUS-CERT fax +49-711-685-5898

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Barry Lind 2002-09-27 19:02:02 Re: [JDBC] Prepared statement performance...
Previous Message Barry Lind 2002-09-27 18:57:54 Re: [JDBC] Prepared statement performance...

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-09-27 22:40:30 Cause of missing pg_clog files
Previous Message Roland Roberts 2002-09-27 17:29:03 Re: [SQL] CURRENT_TIMESTAMP

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2002-09-28 01:38:52 Re: Performance while loading data and indexing
Previous Message scott.marlowe 2002-09-27 15:16:03 Re: Performance while loading data and indexing