subject:"Re\: \[GENERAL\] pg_dump and cluster"

Re: [GENERAL] pg_dump and cluster

2006-09-11 Thread Angva

Thanks Alvaro! ---(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

Re: [GENERAL] pg_dump and cluster

2006-09-10 Thread Alvaro Herrera

Angva wrote: > Hello, > > I have a question regarding pg_dump and table clustering. Each night a > job runs that basically does the following: > > 1) load large amounts of data from flat files into a schema > 2) cluster the data > 3) pg_dump that schema > 4) copy the resulting dmp to several dest