Re: File count restriction of directory limits number of relations inside a database. - Mailing list pgsql-hackers

From sudalai
Subject Re: File count restriction of directory limits number of relations inside a database.
Date
Msg-id 1428464961518-5845044.post@n5.nabble.com
Whole thread Raw
In response to Re: File count restriction of directory limits number of relations inside a database.  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: Re: File count restriction of directory limits number of relations inside a database.  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Re: Re: File count restriction of directory limits number of relations inside a database.  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Hi,
     Ya you are right, ext4 allows more directory entries(more than 32000)
but we limited the number of files insides the directory to 32000 to get
better performance. Sorry i'm not mentioned that in my post.
That the reason we plan to use tablespace.  The problem we faced in
tablespace is, the location should be present on both master and slave and
we need to create multiple tablespaces. That why i changed the source, to
create a sub directory on the given location and take that location for
tablespace creation. So i can given one location (that present in both
master & slave) to create multiple tablespaces.





-----
sudalai
--
View this message in context:
http://postgresql.nabble.com/File-count-restriction-of-directory-limits-number-of-relations-inside-a-database-tp5844711p5845044.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Parallel Seq Scan
Next
From: Amit Kapila
Date:
Subject: Re: Parallel Seq Scan