From: Aldor <an@mediaroot.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: VACUUM - How long should it take?! - Here are some test
Date: Sun, 28 Aug 2005 19:48:51 +0100
Message-ID: <43120713.7000003@mediaroot.de> (raw)
In-Reply-To: <25202.1125247612@sss.pgh.pa.us>
References: <4311DFD5.6000104@mediaroot.de>
<25202.1125247612@sss.pgh.pa.us>
>>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@mediaroot.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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: an@mediaroot.de, tgl@sss.pgh.pa.us
Subject: Re: VACUUM - How long should it take?! - Here are some test
In-Reply-To: <43120713.7000003@mediaroot.de>
References: <4311DFD5.6000104@mediaroot.de> <25202.1125247612@sss.pgh.pa.us> <43120713.7000003@mediaroot.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox