> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
