Thank you very much for your reply.

This is not working in Postgresql 8.1.4. Its throwing some error.

BTW, how to fetch the total disk space that is alloted to DB in postgresql
?. Any commands available ?.

Regards, Ravi




-----Original Message-----
From: Kaloyan Iliev [mailto:news1@faith.digsys.bg]
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:

>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. Any views or opinions presented in this email are solely those
of the author and
>
>may not necessarily reflect the opinions of HCL or its affiliates. Any form
of reproduction,
>
>dissemination, copying, disclosure, modification, distribution and / or
publication of this
>
>message without the prior written consent of the author of this e-mail is
strictly
>
>prohibited. If you have received this email in error please delete it and
notify the sender
>
>immediately. Before opening any mail and attachments please check them for
viruses and
>
>defect.
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
>
>
>

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

am Mon, dem 11.12.2006, um 19:41:29 +0530 mailte Ravindran G - TLS, Chennai. folgendes:
> Thank you very much for your reply.
>
> This is not working in Postgresql 8.1.4. Its throwing some error.

Which errors?

test=# show geqo_threshold;
geqo_threshold
----------------
12
(1 row)

test=*# select version();
version
-------------------------------------------------------------------------------------------
PostgreSQL 8.1.4 on i386-pc-linux-gnu, compiled by GCC cc (GCC) 3.3.5 (Debian 1:3.3.5-13)
(1 row)



>
> BTW, how to fetch the total disk space that is alloted to DB in postgresql
> ?. Any commands available ?.

Yes, RTFM.
http://www.postgresql.org/docs/8.1/i...ons-admin.html
-> pg_database_size(name)


>
> Regards, Ravi
>
>
>
>
> -----Original Message-----

Please, no silly fullquote below your text.


Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster