On 03/20/2013 07:14 AM, Vick Khera wrote:
On Wed, Mar 20, 2013 at 9:53 AM, jg <jg@xxxxxxxx <mailto:jg@xxxxxxxx>>
wrote:
The rotated script, as explained, just drops tables and creates
empty ones.
That doesn't make sense then, to have fragmentation if you are creating
new tables with fresh data copied into them. The files should be pretty
much sequentially written.
I think the problem is here:
"Every minute, sequentially, a batch load 10.000 rows of 250 bytes with
a COPY.
After a day, i got a database with 50 tables with 1.440 set of 10.000 rows."
So if I am reading it right the table starts with 10,000 rows then
10,000 rows are added each minute during the day.
Ohhhh.... I see. You're using Windows. Maybe you need some OS with a
better file system that doesn't fragment like that?
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
