pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
> 



Message-ID: <43120713.7000003@mediaroot.de>
Permalink:  ../43120713.7000003@mediaroot.de/
Also on:    postgresql.org/message-id/43120713.7000003@mediaroot.de

 · 

reply

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