pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql - Threshold value.
8+ messages / 5 participants
[nested] [flat]
* Postgresql - Threshold value.
@ 2006-12-11 07:37 Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
2006-12-11 09:19 ` Re: Postgresql - Threshold value. Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2006-12-11 09:34 ` Re: Postgresql - Threshold value. Kaloyan Iliev <news1@faith.digsys.bg>
0 siblings, 2 replies; 8+ messages in thread
From: Ravindran G - TLS, Chennai. @ 2006-12-11 07:37 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgresql - Threshold value.
2006-12-11 07:37 Postgresql - Threshold value. Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
@ 2006-12-11 09:19 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
1 sibling, 0 replies; 8+ messages in thread
From: Rajesh Kumar Mallah @ 2006-12-11 09:19 UTC (permalink / raw)
To: Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>; +Cc: pgsql-performance
On 12/11/06, Ravindran G - TLS, Chennai. <ravindran_g@hcl.in> wrote:
> Hello,
>
> How to get Postgresql Threshold value ?. Any commands available ?.
What is meant my threshold value ?
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgresql - Threshold value.
2006-12-11 07:37 Postgresql - Threshold value. Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
@ 2006-12-11 09:34 ` Kaloyan Iliev <news1@faith.digsys.bg>
1 sibling, 0 replies; 8+ messages in thread
From: Kaloyan Iliev @ 2006-12-11 09:34 UTC (permalink / raw)
To: Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>; pgsql-performance
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
>
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgresql - Threshold value.
@ 2006-12-11 14:11 Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
2006-12-11 14:24 ` Re: Postgresql - Threshold value. A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 1 reply; 8+ messages in thread
From: Ravindran G - TLS, Chennai. @ 2006-12-11 14:11 UTC (permalink / raw)
To: Kaloyan Iliev <news1@faith.digsys.bg>; pgsql-performance; +Cc: Vandhana Radhakrishnan - TLS , Chennai <vandhanar@hcl.in>; Sasikala V - TLS , Chennai <sasikalav@hcl.in>
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
>
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgresql - Threshold value.
2006-12-11 14:11 Re: Postgresql - Threshold value. Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
@ 2006-12-11 14:24 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 0 replies; 8+ messages in thread
From: A. Kretschmer @ 2006-12-11 14:24 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgresql - Threshold value.
@ 2006-12-11 14:43 Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
2006-12-11 15:42 ` Re: Postgresql - Threshold value. Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Ravindran G - TLS, Chennai. @ 2006-12-11 14:43 UTC (permalink / raw)
To: A. Kretschmer <andreas.kretschmer@schollglas.com>; pgsql-performance
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgresql - Threshold value.
2006-12-11 14:43 Re: Postgresql - Threshold value. Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
@ 2006-12-11 15:42 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2006-12-11 16:09 ` Re: Postgresql - Threshold value. Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Rajesh Kumar Mallah @ 2006-12-11 15:42 UTC (permalink / raw)
To: Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>; +Cc: A. Kretschmer <andreas.kretschmer@schollglas.com>; pgsql-performance
On 12/11/06, Ravindran G - TLS, Chennai. <ravindran_g@hcl.in> wrote:
> Thanks.
>
> I am using Postgres 8.1.4 in windows 2000 and i don't get the proper
> response for threshold.
what is the response you get ? please be specific about the issues.
also the footer that comes with your emails are
not appreciated by many people. if possible pls avoid it.
Regds
mallah.
>
> ---------
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Postgresql - Threshold value.
2006-12-11 14:43 Re: Postgresql - Threshold value. Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
2006-12-11 15:42 ` Re: Postgresql - Threshold value. Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
@ 2006-12-11 16:09 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 8+ messages in thread
From: Tom Lane @ 2006-12-11 16:09 UTC (permalink / raw)
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>; +Cc: Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>; A. Kretschmer <andreas.kretschmer@schollglas.com>; pgsql-performance
"Rajesh Kumar Mallah" <mallah.rajesh@gmail.com> writes:
> On 12/11/06, Ravindran G - TLS, Chennai. <ravindran_g@hcl.in> wrote:
>> I am using Postgres 8.1.4 in windows 2000 and i don't get the proper
>> response for threshold.
> what is the response you get ? please be specific about the issues.
Even more to the point, what sort of response do you think you should
get? What kind of threshold are you talking about, and why do you think
it even exists in Postgres?
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2006-12-11 16:09 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-11 07:37 Postgresql - Threshold value. Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
2006-12-11 09:19 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2006-12-11 09:34 ` Kaloyan Iliev <news1@faith.digsys.bg>
2006-12-11 14:11 Re: Postgresql - Threshold value. Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
2006-12-11 14:24 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-12-11 14:43 Re: Postgresql - Threshold value. Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
2006-12-11 15:42 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2006-12-11 16:09 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox