pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tim Allen <tim@proximity.com.au>
To: Markus Schaber <schabi@logix-tt.com>
Cc: Mahesh Shinde <mahesh.shinde@hovservices.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Default autovacuum settings too conservative
Date: Thu, 09 Feb 2006 10:31:09 +1100
Message-ID: <43EA7F3D.7050306@proximity.com.au> (raw)
In-Reply-To: <43E9F440.1080001@logix-tt.com>
References: <20060201211633.GM95850@pervasive.com>
	<43E12A03.6070906@zeut.net>
	<20060207050545.GZ1240@pervasive.com>
	<m38xsn4rvm.fsf@mobile.int.cbbrowne.com>
	<20060207072621.GI13592@pervasive.com>
	<43E89506.40903@logix-tt.com>
	<20060208010339.GT38134@pervasive.com>
	<43E94E42.3080605@pws.com.au>
	<m34q3a32w5.fsf@mobile.int.cbbrowne.com>
	<43E9D066.40101@logix-tt.com>
	<002c01c62ca4$3159b860$dd0aa8c0@codecindia.com>
	<43E9F440.1080001@logix-tt.com>

Markus Schaber wrote:
>>Does vacuum improves the performance of the database search.. As if now I
>>have a table who is having a records 70 lac and daily appx 10-15 thousand
>>rows get added. so please let me know which type of vacuum I should prefer.
>>I am accessing a data using  java application which is hosted on the same
>>database server.
> 
> I don't know what "70 lac" means.

One lac (also spelt "lakh") is one hundred thousand. And one crore is 
ten million. Indians count differently from the rest of the world :-).

Tim

-- 
-----------------------------------------------
Tim Allen          tim@proximity.com.au
Proximity Pty Ltd  http://www.proximity.com.au/

view thread (16+ messages)  latest in thread

Message-ID: <43EA7F3D.7050306@proximity.com.au>
Permalink:  ../43EA7F3D.7050306@proximity.com.au/
Also on:    postgresql.org/message-id/43EA7F3D.7050306@proximity.com.au

copy link · copy postgr.es

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tim@proximity.com.au, schabi@logix-tt.com, mahesh.shinde@hovservices.com
  Subject: Re: Default autovacuum settings too conservative
  In-Reply-To: <43EA7F3D.7050306@proximity.com.au>

* 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