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