Skip site navigation (1) Skip section navigation (2)

Re: Performance question: Restore + INDEX

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Aldor <an(at)mediaroot(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Performance question: Restore + INDEX
Date: 2005-09-26 01:19:01
Message-ID: 20050926011901.GA11448@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, Sep 26, 2005 at 01:30:53AM +0100, Aldor wrote:
> What is faster?
> 
> 1. CREATE TABLE
> 2. restore data
> 3. CREATE INDEX
> 
> or
> 
> 1. CREATE TABLE
> 2. CREATE INDEX
> 3. restore data

See "Populating a Database" in the "Performance Tips" chapter of
the documentation:

http://www.postgresql.org/docs/8.0/interactive/populate.html

But instead of taking somebody's word for it, you could simply try
it both ways and see which is faster for yourself.

-- 
Michael Fuhr

In response to

pgsql-admin by date

Next:From: Chris BrowneDate: 2005-09-26 03:43:54
Subject: Re: Performance question: Restore + INDEX
Previous:From: AldorDate: 2005-09-26 00:30:53
Subject: Performance question: Restore + INDEX

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group