[dscng-dev] DSCng became very slow in processing data.

Phil Regnauld 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
> settings.
> 
> 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 :)

	Cheers,
	Phil


More information about the dscng-dev mailing list