Postgres Pro
Downloads
Home   >   mailing lists

At what point does a big table start becoming too big? - Mailing list pgsql-general

From Nick
Subject At what point does a big table start becoming too big?
Date
Msg-id 9d6e16a5-7ff5-4873-9afe-60ec330dfdb3@googlegroups.com
Whole thread Raw
Responses Re: At what point does a big table start becoming too big?  ("Martin French" <Martin.French@romaxtech.com>)
Re: At what point does a big table start becoming too big?  (Chris Travers <chris.travers@gmail.com>)
Re: At what point does a big table start becoming too big?  (Merlin Moncure <mmoncure@gmail.com>)
Re: At what point does a big table start becoming too big?  (Jeff Janes <jeff.janes@gmail.com>)
Re: At what point does a big table start becoming too big?  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-general
Tree view 
I have a table with 40 million rows and haven't had any performance issues yet.

Are there any rules of thumb as to when a table starts getting too big?

For example, maybe if the index size is 6x the amount of ram, if the table is 10% of total disk space, etc?

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: What text format is this and can I import it into Postgres?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Alternatives to very large tables with many performance-killing indicies?