[dscng-dev] DSCng became very slow in processing data.
regnauld at nsrc.org
Mon Jul 21 11:14:46 CEST 2014
Jan Čermák (jan.cermak) writes:
> Hello Valentin,
> we've already received some reports about this behavior earlier and we
> have a machine where we can reproduce this issue. It's probably caused
> by the fragmentation of the data in the database and we think it could
> be solved by partitioning of the table and/or by optimizing PostgreSQL
> Sorry for the problem, we'll try to look at it as soon as possible and
> we'll suggest some solution for this.
Table partitioning has many benefits, including speedy deletion
of data (say you have 1 day or week / partition, then it's just
a matter of dropping the children tables), so +1 from here :)
More information about the dscng-dev