Re: [BUGS] memory does not return back

[Richard Huxton]

On Tuesday 17 February 2004 12:03, hessam wrote:
> I'm using freeradius 0.9.3 with postgresql 7.3.2.
> All I do is just inserting some h323 accounting data into my tables.
> After a couple of hours the memory reaches to about 1G and then Linux
> starts using swap file.I lose some of my records and PC becomes very
> slow.
> Even if I restart postgresql , the memory does not return back.

Which would suggest perhaps that postgresql might not be the problem here. Can 
you provide output from ps/top showing memory usage for the key processes 
involved here?

-- 
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [BUGS] zlib directory in configure.

[Tom Lane]

=?iso-8859-1?q?Laurent=20FAILLIE?= <[EMAIL PROTECTED]> writes:
> Is it possible to improve "configure" script of
> postgresql to allow to specify in which directory a
> 3rd tool is installed ?

See --with-includes and --with-libraries.

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [BUGS] Select (str)::FLOAT8 BUG

[Tarhon-Onu Victor]

On Wed, 18 Feb 2004, Rafael Villalobos Prats wrote:

> I think i have found a bug.
> 
> I´ve tried it in PgSQL 7.3.5 & 7.4.1
> 
> When I do:
> 
> atisae_oct_1=# SELECT (1000/500/7)::FLOAT8 as v_numero;
>  v_numero
> --
> 0
> (1 row)

This is not a bug and it also has nothing to do with postgresql.
Try the same in C and you will have the same result.
The expression 1000/500/7 contains operations between variables
of an integer type: 1000/500 = 2, 2/7=0. 0::float=0.
Probably a more accurate result will be obtained if you modify 
this to:
1000::float/500/7.
In this case 1000/500/7::float or 1000::float/500/7 will return 
the same result, but 1000::float/501/7 and 1000/501/7::float will not 
because the first operation will be between variables of an integer 
type.

-- 
Tarhon-Onu Victor
Area Technical Coordinator
RDS Iasi - Network Operations Center
www.rdsnet.ro, www.rdstel.ro, www.rdslink.ro
Phone: +40-232-218385; Fax: +40-232-260099
..
Privileged/Confidential Information may be contained in this message. If
you are not the addressee indicated in this message (or responsible for
delivery of the message to such person), you may not copy or deliver this
message to anyone. In such a case, you should destroy this message and
kindly notify the sender by reply e-mail.

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org