[PERFORM] Estimate the size of the SQL file generated by pg_dump utility

2007-03-05 Thread Ravindran G-TLS,Chennai.
Dear All, I have to take backup of a database as a SQL file using the pg_dump utility and I have to check the disk space before taking the backup. Hence I need to estimate the size of the pg_dump output. The size given by pg_database_size procedure and the size of file generated by pg_dump vary t

Re: [PERFORM] Postgresql - Threshold value.

2006-12-11 Thread Ravindran G - TLS, Chennai.
riginal Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Kretschmer Sent: Monday, December 11, 2006 7:55 PM To: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Postgresql - Threshold value. am Mon, dem 11.12.2006, um 19:41:29 +0530 mailte Ravindran G - TLS, Chenna

Re: [PERFORM] Postgresql - Threshold value.

2006-12-11 Thread Ravindran G - TLS, Chennai.
PROTECTED] Sent: Monday, December 11, 2006 3:04 PM To: Ravindran G - TLS, Chennai.; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Postgresql - Threshold value. Hi, try using: tmp=# show all; and tmp=# show geqo_threshold; Regards, Kaloyan Iliev Ravindran G - TLS, Chennai. wrote

[PERFORM] Postgresql - Threshold value.

2006-12-11 Thread Ravindran G - TLS, Chennai.
Hello, How to get Postgresql Threshold value ?. Any commands available ?. Regards, Ravi DISCLAIMER The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates

[PERFORM] Postgre 8.0 Installation - Issues

2006-10-10 Thread Ravindran G - TLS, Chennai.
All, We are facing few issues while we install Postgres 8.0 in Windows 2000 Japanese OS. Installer kit name : postgresql-8.0-ja Scenario 1: While installing PostGRE 8.0, we got an logon failure at the end of installing the component telling that it failed to produce the process for initdb and als

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Ravindran G - TLS, Chennai.
PROTECTED] Sent: Monday, August 28, 2006 7:02 PM To: Ravindran G - TLS, Chennai. Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue. Ravindran G - TLS, Chennai. wrote: > I would like to talk to one of the org member in postgre about this issue. >

Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-28 Thread Ravindran G - TLS, Chennai.
I would like to talk to one of the org member in postgre about this issue. This is critical for us. Please help. It will be great, if you could provide your contact number to discuss on this. Thank you in advance. Regards, Ravi -Original Message- From: Ravindran G - TLS, Chennai

[PERFORM] Postgre SQL 7.1 cygwin performance issue.

2006-08-22 Thread Ravindran G - TLS, Chennai.
Hi, We are using PostgreSQL 7.1 cygwin installed on Windows 2000 (2 GB Memory, P4). We understand that the maximum connections that can be set is 64 in Postgresql 7.1 version. The performance is very slow and some time the database is not getting connected from our application because of this.