Search Postgresql Archives

Re: precautions/prerequisites to take for specific table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> On Nov 5, 2020, at 8:49 AM, Vasu Madhineni <vasumdba1515@xxxxxxxxx> wrote:
> 
> Hi All,
> 
> In my organisation a newly built project application team requirement on tables like have a column (text type), with size can reach around 3 MB, and 45 million records annually. 
> 
> Are there any specific precautions/prerequisites we have to take from DBA end to handle this type of table.


Hi Vasu,
Postgres can handle that just fine. We have a table with two text columns that’s 18Gb and almost 400 million rows, and that’s not a big table by some people’s standards.

If you have specific concerns, you’ll need to tell us more about your situation and why you think you won’t be satisfied.

Cheers
Philip





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux