| From: | Tim Allen <tim(at)proximity(dot)com(dot)au> |
|---|---|
| To: | Markus Schaber <schabi(at)logix-tt(dot)com> |
| Cc: | Mahesh Shinde <mahesh(dot)shinde(at)hovservices(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Default autovacuum settings too conservative |
| Date: | 2006-02-08 23:31:09 |
| Message-ID: | 43EA7F3D.7050306@proximity.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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(at)proximity(dot)com(dot)au
Proximity Pty Ltd http://www.proximity.com.au/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Atul Shah | 2006-02-09 00:18:54 | db user named 'root' |
| Previous Message | Vinicius Ferreira | 2006-02-08 22:32:46 | Could not start the PostgreSQL Database Server [version # inserted here] service on local computer |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schaber | 2006-02-09 00:21:01 | Re: Default autovacuum settings too conservative |
| Previous Message | Ron | 2006-02-08 22:05:02 | Sane configuration options for a WinXP laptop 8.1 install? |