Postgres Pro
Downloads
Home   >   mailing lists

Performance question: Restore + INDEX - Mailing list pgsql-admin

From Aldor
Subject Performance question: Restore + INDEX
Date
Msg-id 4337413D.4040802@mediaroot.de
Whole thread Raw
Responses Re: Performance question: Restore + INDEX  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin
Tree view 
Hi,

I'm curious how other people do it:

What is faster?

1. CREATE TABLE
2. restore data
3. CREATE INDEX

or

1. CREATE TABLE
2. CREATE INDEX
3. restore data

Thanks,

Aldor

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Hi.........
Next
From: Michael Fuhr
Date:
Subject: Re: Performance question: Restore + INDEX