As stated in the previous email if I use partitioning then queries will
be executed sequentially - i.e., instead of log(n) it would be (#
partitions) * log(n). Right?
depends.. since indexes would be hit for each child table, the time for
query is dependent on the amount of data that is
Benjamin,
In order to avoid the re-indexing I was thinking of instead creating a
new
table each month (building its indexes and etc) and accessing them all
through a view. This way I only have to index the new data each month.
Take a look at bizgres.org (based on postgres).
They have a
Hello all,
My hard disk is filling up in the /base directory to where it has consumed
all 200gig of that drive.
All the posts that i see keep saying move to a bigger drive, but at some
point a bigger drive would just get consumed.
How can i keep the disk from filling up other than get lik