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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
