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	August 23, 2012 06:39:46
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? Re: At what point does a big table start becoming too big? Re: At what point does a big table start becoming too big? Re: At what point does a big table start becoming too big? Re: At what point does a big table start becoming too big?
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:

From: Thomas Kellerer
Date: 23 August 2012, 06:23:07
Subject: Re: What text format is this and can I import it into Postgres?

From: Martijn van Oosterhout
Date: 23 August 2012, 07:09:58
Subject: Re: Alternatives to very large tables with many performance-killing indicies?

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

Previous

Next