Re: [ADMIN] [SQL] Anti log in PostgreSQL

2003-12-26 Thread Sai Hertz And Control Systems
Dear Martin Marques and other kind people out their , In mathematics I would have written it something like A = antilog (3·3234) = 2144 As I can understand, this is a 10 base log, so that what you want is 10^(3.3234)? Though antilog did not solve my problem the link below helped me to p

Re: [ADMIN] Opinion wanted: Default select rights for users via public

2003-12-26 Thread Bruno Wolff III
On Fri, Dec 26, 2003 at 15:39:00 +0100, Oli Sennhauser <[EMAIL PROTECTED]> wrote: > I see. But sometimes your solution is not possible. E.g. if I have a > critical application (banking?) and several kind of users on it. Some > users should NOT know, what is also around them but they have to use t

Re: [ADMIN] [SQL] Anti log in PostgreSQL

2003-12-26 Thread David F. Skoll
On Sat, 27 Dec 2003, Sai Hertz And Control Systems wrote: > select exp(3.3234) as a2144 > Gives me > 27.754555808589792 Right. That's e^3.3234 Try: select 10^3.3234; or: select dpow(10, 3.3234); or even: select exp(3.3234 * ln(10.0)); -- David. ---

Re: [ADMIN] Database taking up space rapidly

2003-12-26 Thread Tom Lane
"Anjan Dave" <[EMAIL PROTECTED]> writes: > Here's where I find the bulk of the large files: > -rw---1 postgres postgres 1073741824 Dec 23 18:57 17610 > -rw---1 postgres postgres 1073741824 Dec 23 22:41 17610.1 > [ etc ] So, which table or index has relfilenode 17610 (look in pg_cla

Re: [ADMIN] [SQL] Anti log in PostgreSQL

2003-12-26 Thread Sai Hertz And Control Systems
Dear Martin Marques , In mathematics I would have written it something like A = antilog (3·3234) = 2144 As I can understand, this is a 10 base log, so that what you want is 10^(3.3234)? For that you have the exponential operator ^. Nope select exp(3.3234) as a2144 Gives me 27.7545558085

[ADMIN] Database taking up space rapidly

2003-12-26 Thread Anjan Dave
Title: Database taking up space rapidly Hi All, I just moved over a db from 7.2.3 to 7.4.0 on a new RH9 server. The dump, I remember was about 2GB, 350MB compressed, when I restored it only about 3-4 days ago… Now, the slice stands at about 30GB!! /dev/sda2 50830616  300348

[ADMIN] Anti log in PostgreSQL

2003-12-26 Thread Sai Hertz And Control Systems
Dear all , In one of our project I require to calculate antilog of (3.3234) But I could not find any functions in Documentation for the same. In mathematics I would have written it something like A = antilog (3·3234) = 2144 Any suggestions or links are most welcome . Regards, Vishal Kashyap.

Re: [ADMIN] UNIX File buffering disable?

2003-12-26 Thread Tom Lane
Oli Sennhauser <[EMAIL PROTECTED]> writes: > Therefore I heard a recommendation, that dba's should disabled UNIX file > buffering on mountpoints where rdbms are running. Was this from anyone who actually knows what they're talking about? You can't (AFAIK), and you don't need to.

Re: [ADMIN] UNIX File buffering disable?

2003-12-26 Thread Sai Hertz And Control Systems
Hello , Hmmm This concernes me to does anyone has answers for this please . and Oli if you get this answer from some other posts please forward it here also. Regards, Vishal Kashyap Hello I have heard that UNIX I/O buffer sometimes causes problems during system crash because it keeps files

Re: [ADMIN] Opinion wanted: Default select rights for users via public

2003-12-26 Thread Oli Sennhauser
Hello Tom Thank you for answering. I found that all users have access to pg_class etc. by default. In my opinion this causes some security questions or at least can make users curious about things they should not. This isn't going to change, because it would break too many clients (as inde

[ADMIN] UNIX File buffering disable?

2003-12-26 Thread Oli Sennhauser
Hello I have heard that UNIX I/O buffer sometimes causes problems during system crash because it keeps files which, application thinks, are already written to disk. And then this changes go lost during crash. Therefore I heard a recommendation, that dba's should disabled UNIX file buffering on