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
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
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 destination databases
5) pg_restore
