Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Maximum size in Postgresql?

By
Remya
on 1/15/14, 12:34 AM 1,619 views

We are using Postgresql for Openerp. What is the total size of postgresql for openerp?

I meant, i have lots of files. I want to attach these files in my knowledge module in openerp, the size of the files more than 1gb.

So i want to know the maximum size in Postgresql database.

I have too many files with each having size less than 250MB. I am going to upload this as attachment (binary) format. But I have two worries now. 1. Is this going create any performance issue? Can I do some thing to scale up the database to perform seamless? 2. Is this going to create any issue regarding space availability? Is harddisk size the limit of postgre sql?

You can use those attachments, it will not be a problem.

Gopakumar N G
on 1/15/14, 4:34 AM

Hi Thanks for the comment. But I want to reframe my question. Please check it

Remya
on 1/16/14, 12:40 AM

@Remya: as the database size increases it will create performance issues, if your db is in a remote server. But if you are using it in a local machine it will not be a problem.

Gopakumar N G
on 1/16/14, 12:46 AM

@Gopakumar : Can you suggest any Solution?

Remya
on 1/16/14, 1:56 AM

@Remya: I don't know remya.

Gopakumar N G
on 1/16/14, 5:52 AM

Ok. Thanks Gopakumar for your support

Remya
on 1/16/14, 6:56 AM
0
Karthik
On 3/10/14, 7:15 PM

Maybe this helps - Limit Value Maximum Database Size - Unlimited Maximum Table Size 32 TB Maximum Row Size 1.6 TB Maximum Field Size 1 GB Maximum Rows per Table Unlimited Maximum Columns per Table 250 - 1600 depending on column types Maximum Indexes per Table Unlimited

0

Thierry Godin

--Thierry Godin--
1516
| 8 7 8
Collegien, France
--Thierry Godin--

..

Thierry Godin
On 1/15/14, 5:09 AM

Hello,

I suggest you to store files into a folder instead of DB if you have a lot .

See here : https://accounts.openerp.com/forum/Help-1/question/529

Regards

If i prefer to store files in database, then will it be any problem?

Remya
on 1/16/14, 12:25 AM

Hi Thanks for the answer. But I want to reframe my question. Please check it

Remya
on 1/16/14, 12:40 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 1/15/14, 12:34 AM
Seen: 1619 times
Last updated: 3/16/15, 8:10 AM