Re: Postgres Database Design Issues in Tablespace

Hi,

Thank you for the response. before the posting goes to further discussion. I
realize this for cygwin discussion. You are right when running Postgresql
need to be in native Windows or Linux. So that's why I am choosing
Postgresql 8.0. I already post this issues in diffrent group. that's in
pgsql performances. (just for clarification, I am not running it in cygwin
environment. It just happens I do not not which group to post. And thought
cygwin is for postgresql in windows environment).

Thank you,
Rosny

>From: Reini Urban <rurban(at)x-ray(dot)at>
>To: SehatRosny <SehatRosny(at)hotmail(dot)com>
>CC: pgsql-cygwin(at)postgresql(dot)org
>Subject: Re: [CYGWIN] Postgres Database Design Issues in Tablespace
>Date: Mon, 06 Dec 2004 17:34:30 +0100
>
>SehatRosny schrieb:
>>Refering to 20 tables which can be partition A. All departments tables
>>is put into 20 tables.
>> some querying of 20 millions records.
>> B. For each department create tablespace. (Which means, if there
>> are 7000 departments, there will be 7000 tablespace each contains
>> 20 tables). A1. Use A option,
>> As tables become huge. partition the tables which hits often
>> and has large size file(usually when it bigger than 2-3 GB size)
>> into separate tablespace.
>>B1. Use B option,
>> Creating 7000 TableSpace for Departments
>> - One Department has one tablespace
>> - Each Department has 20 tables
>
>>Question :
>> 1. Is it B1 the right approach?
>> 2. Is progresql will have problems if I have 7000 tablespace?
>
>why tablespace at all? do some caclulation, buy a large disc and forget
>about tablespace. (i.e. symlinks)
>
>postgresql-cygwin certainly will have problems which such a configuration.
>Please use a decent operating system and filesystem for such a crazy idea.
>
>cygwin is certainly not suited well for such a production database.
>consider native windows or any unix instead.
>
>NTFS is certainly not suited well for > 500 files per dir.
>consider a unix filesystem instead.
>--
>Reini Urban
>http://xarch.tu-graz.ac.at/home/rurban/