Thanks.
I am using Postgres 8.1.4 in windows 2000 and i don't get the proper
response for threshold.
---------
pg_database_size(name) - is giving the current space used by DB. But I want
like "Total space utilized by DB" and "Free space".
Regards, Ravi
-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org]On 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,
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/interactive/functions-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
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.