My guess would be:  As big as your hard drive can handle.

Why do you ask?

Babu N wrote:

 

Want to know how much data it can able to store.

Why?  What is your reason?  Do you think you will have a deployment that will have hundreds of thousands of Projects?  Millions of Users?  Hundreds of Sites?  What is the reason behind your question.

I also am curious as to why.  I've never seen a limit besides the size of your hard drive.  And, I've run across instances of 20,000 workbooks.

wow ..that sounds a lot ....

Hi there

The repository is the term Tableau use to refer to the postgres database which gets installed with the server and stores all the info you mention. While the repository will store information about your data sources - what they're called, the connection info etc, it doesn't store your actual data.  If the data source is a 'live connection' then the data is stored wherever that data resides eg a SQL Server, an excel file, an Oracle database etc.  If the data source is extracted, then the data is pulled from wherever the data is located and stored in Tableau's columnar data store on the server.  This is separate from the repository.  So if you have incredibly large data sources (lots of rows & columns) you want to extract, then your main concerns are ensuring you have enough space on the server itself to store these extracts and you've got enough resources to process the extracts which will take some time if they are very wide as well as very deep.

Donna

Hi Babu

There isn't a specific location.  Can I suggest you have a read of this article which will hopefully explain things a bit better - it was written with v8 but I believe the principals still hold

Understanding Tableau Data Extracts | Tableau Software

Thanks

Donna

Hi Donna.  Generally, I find the data extracts are buried deep in sub-folders of the data engine parent within the Tableau installation directory (i.e. G:\Tableau\Tableau Server\data\tabsvc\dataengine).  I hope this clarifies some....

Thanks Jeff.... never had to look for them personally :-)

To know your postgres DB Size

select pg_database_size('workgroup')

Then convert to 'GB'.

Thanks for this suggestion Satish!

Also to save the extra step of converting you can use a modified version of this command to see the size in MB/GB:

select pg_size_pretty(pg_database_size('workgroup'))