| From: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
|---|---|
| To: | "Tim Perrett *EXTERN*" <hello(at)timperrett(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PGSQL with high number of database rows? |
| Date: | 2007-04-03 09:29:24 |
| Message-ID: | AFCCBB403D7E7A4581E48F20AF3E5DB201FF8302@EXADV1.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thorsten Kraus | 2007-04-03 11:25:36 | Re: Webappication and PostgreSQL login roles |
| Previous Message | Dave Page | 2007-04-03 09:10:26 | Re: PGSQL with high number of database rows? |