Re: PGSQL with high number of database rows? - Mailing list pgsql-general

From Albe Laurenz
Subject Re: PGSQL with high number of database rows?
Date
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB201FF8302@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to PGSQL with high number of database rows?  (Tim Perrett <hello@timperrett.com>)
List pgsql-general
> I am possibly looking to use PSGSQL in a project I am working on for a
very
> large client. The upshot of this is the throughput of data will be
pretty
> massive, around 20,000 new rows in one of the tables per day.
> We also have tokeep this data online for a set period so after 5 or 6
weeks
> it could have nearly a million rows.
>
> Are there any implications with possibly doing this? will PG
> handle it?

What do you mean, massive? A mere 1000000 rows?
I don't think that a small database like this will be a worry.
Try to avoid unnecessary table scans by using indexes!

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: PGSQL with high number of database rows?
Next
From: Thorsten Kraus
Date:
Subject: Re: Webappication and PostgreSQL login roles