Thread: initlocation question

initlocation question

From
Chris Hoover
Date:
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.

Thanks,

Chris

Re: initlocation question

From
Scott Marlowe
Date:
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.