Re: VACUUM - How long should it take?! - Here are some test

>>bgwriter_percent = 0
>>bgwriter_maxpages = 0

> Why did you do that? There's certainly nothing in the docs recommending
> disabling the bgwriter.

I'm remembering that putting big data into the database ran faster with
this settings.

>>The duration of the VACUUM of tbl1 and tbl2 is okay - so how to speed up
>>now the VACUUM of tbl3?
>
>
> You have not showed us anything that would explain any speed differences
> between these tables. Maybe there was some difference in the data you
> loaded them with?

The strings in the tbl3 are longer - I took the average length from the
original table which is about 94 characters.

I will make some tests with increasing the data in tbl3 with 100k,
1 Million and 100 Million rows.

I'll also try activating the bgwriter.

The other settings in postgresql.conf look for you ok?

Some other information
----------------------

Distribution: Debian
Encoding of Database: LATIN10
Locale: C

Regards, Aldor

Tom Lane wrote:
> Aldor <an(at)mediaroot(dot)de> writes:
>
>>bgwriter_percent = 0
>>bgwriter_maxpages = 0
>
>
> Why did you do that? There's certainly nothing in the docs recommending
> disabling the bgwriter.
>
>
>>The duration of the VACUUM of tbl1 and tbl2 is okay - so how to speed up
>>now the VACUUM of tbl3?
>
>
> You have not showed us anything that would explain any speed differences
> between these tables. Maybe there was some difference in the data you
> loaded them with?
>
> regards, tom lane
>