Search Postgresql Archives

Re: PGSQL with high number of database rows?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux