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 <[email protected]>
>To: SehatRosny <[email protected]>
>CC: [email protected]
>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/



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org