On Thu, 2005-10-06 at 14:05, Chris Hoover wrote: > Question, is there a limit to the number of directories you can use > with initlocation in a single PostgreSQL cluster? If so, what is the > limit (theoretical and/or practical)? > > We are in 7.3 right now, but I'm also concerned about 8.x. As of 8.x, you'd probably be better served with table spaces. locations were the old school way of working around a lack of table spaces. There's no limit I know of, certainly not one you're likely to hit for any rational installation. ---------------------------(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