X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 19A6A9FB277 for ; Tue, 8 Aug 2006 12:29:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 41012-04 for ; Tue, 8 Aug 2006 15:29:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from newgen.co.in (mx.newgen.co.in [202.131.146.227]) by postgresql.org (Postfix) with SMTP id B260F9FB271 for ; Tue, 8 Aug 2006 12:29:08 -0300 (ADT) Received: (qmail 2382 invoked by uid 507); 8 Aug 2006 15:29:06 -0000 Received: from 202.140.41.205 by mx.newgen.co.in (envelope-from , uid 501) with qmail-scanner-1.25 (fireav: ???. spamassassin: 3.1.3. Clear:RC:0(202.140.41.205):SA:0(-100.0/5.0):. Processed in 1.497703 secs); 08 Aug 2006 15:29:06 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 8 Aug 2006 15:29:04 -0000 Received: (qmail 11178 invoked by uid 504); 8 Aug 2006 15:28:38 -0000 Received: from ghanshyam@newgen.co.in by ngmail.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:1(192.168.5.190):. Processed in 2.293468 secs); 08 Aug 2006 15:28:38 -0000 Received: from unknown (HELO ng3024) (192.168.5.190) by 192.168.5.243 with SMTP; 8 Aug 2006 15:28:35 -0000 Message-ID: <020301c6baff$504f02e0$be05a8c0@ng3024> From: "Sharma;G.S." To: Subject: Temporary database Size & Transaction Logs Date: Tue, 8 Aug 2006 20:58:35 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0200_01C6BB2D.69F1E220" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.69 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, HTML_TEXT_AFTER_BODY X-Spam-Level: X-Archive-Number: 200608/92 X-Sequence-Number: 22636 This is a multi-part message in MIME format. ------=_NextPart_000_0200_01C6BB2D.69F1E220 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am using Postgres 7.3 can any body tell me is there any Tempdb in postgres, like it is in = Oracle or SQL Server ? If it is there in postgres pls tell me how i can see the space used by = tempdb while my application is running ? I have a database of 53 GB ., = also can i configure the size of Tempdb..? if yes how to go about it .? Also tell me where are the trancation logs are stored in postgres and = how i can see their size ? What are the recommended size and disk = management for Transaction Logs . Thanks in advance ------=_NextPart_000_0200_01C6BB2D.69F1E220 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
I am using Postgres 7.3
can any body tell me is there any = Tempdb in=20 postgres, like it is in Oracle or SQL Server ?
If it is there in postgres pls tell me = how i can=20 see the space used by tempdb while my application is running ? I = have a=20 database of 53 GB ., also can i = configure the=20 size of Tempdb..? if yes how to go about it .?
 
Also tell me where are the trancation = logs are=20 stored in postgres and how i can see their size ? What are the = recommended size=20 and disk management for Transaction Logs .
 
 
Thanks in = advance
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable. ------=_NextPart_000_0200_01C6BB2D.69F1E220--