Re: [GENERAL] postgresql performace degrading after a while

2006-01-29 Thread Ron Marom
First of all thanks for you quick and efficient response. Indeed I forgot to mention that I AM vacuuming the database using a daemon every few hours; however this seems not to be the issue this time, as when the CPU consumptions went up I tried to vacuum manually and this seemed to take no affect.

Re: [GENERAL] postgresql performace degrading after a while

2006-01-29 Thread Michael Fuhr
On Mon, Jan 30, 2006 at 09:02:24AM +0200, Ron Marom wrote: > I seem to have a problem with postgresql 7.4.2 running on Red Hat > Enterprise Linux ES3. If you can't upgrade to 8.0 or 8.1 then at least consider using the latest version in the 7.4 branch (7.4.11). You're missing almost two years of

[GENERAL] postgresql performace degrading after a while

2006-01-29 Thread Ron Marom
Hi All,   I seem to have a problem with postgresql 7.4.2 running on Red Hat Enterprise Linux ES3. I am running an application server over a database in which tables contains at most a few thousands of records. The problematic table, however, contains 67 records, with an application daemon

[GENERAL] regarding debugging?

2006-01-29 Thread AKHILESH GUPTA
hi all, i have a query regarding debbuging in PGSQL. just like there is  a debugger in C/C++, where we can check the execution of our program or we can dry run our code, is there aby option or feature with PGSQL for the same purpose that we can check our PGSQL statements? thanks in advance.

Re: [GENERAL] Indexes

2006-01-29 Thread Michael Glaesemann
On Jan 30, 2006, at 3:03 , Silas Justiniano wrote: My question is about the indexes in Intermediate table. Is the following index: Was my response[1] to your original message unclear? If you have any further questions, please be more specific. [1] http://archives.postgresql.org/pgsql-gene

Re: [GENERAL] Indexes

2006-01-29 Thread Christopher Browne
> Silas Justiniano > Jan 17, 5:53 pm show options > Newsgroups: pgsql.general > From: "Silas Justiniano" <[EMAIL PROTECTED]> - Find messages by this > author > Date: 17 Jan 2006 11:53:37 -0800 > Local: Tues, Jan 17 2006 5:53 pm > Subject: Indexes > Reply | Reply to Author | Forward | Print

[GENERAL] Indexes

2006-01-29 Thread Silas Justiniano
Silas Justiniano Jan 17, 5:53 pm show options Newsgroups: pgsql.general From: "Silas Justiniano" <[EMAIL PROTECTED]> - Find messages by this author Date: 17 Jan 2006 11:53:37 -0800 Local: Tues, Jan 17 2006 5:53 pm Subject: Indexes Reply | Reply to Author | Forward | Print | Individual Me

Re: [GENERAL] Basic questions about PQprepare()

2006-01-29 Thread Michael Fuhr
On Sun, Jan 29, 2006 at 06:03:41PM +0100, Joachim Wieland wrote: > On Sat, Jan 28, 2006 at 08:26:01PM +0100, Alexander Farber wrote: > > Could you explain a bit more, where to get the OIDs? > > They are in the pg_type table, it is described here: > > http://www.postgresql.org/docs/8.1/static/cata

Re: [GENERAL] creating users per database

2006-01-29 Thread Karsten Hilbert
On Sun, Jan 29, 2006 at 02:01:51PM -0500, Tom Lane wrote: > The 8.1 documentation uses the term "role", which seems unlikely to be > confused with Unix groups: ... > Good enough? Yes :-) Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 --

Re: [GENERAL] creating users per database

2006-01-29 Thread Tom Lane
Karsten Hilbert <[EMAIL PROTECTED]> writes: > Aha ! Indeed, the 7.4 documentation wasn't clear enough on > that (for me): > "... The value samegroup specifies that the requested user > must a member of the group with the same name as the > requested database. ..." > Might this be amended to say

Re: [GENERAL] help

2006-01-29 Thread Raymond O'Donnell
On 28 Jan 2006 at 17:38, Paolo Ditto wrote: > I would want do a php script to access my postgres database from > remote host. I would like to know how I can do. Particularly, I would Are you looking for an administration tool? If so, have a look at phpPgAdmin: http://phppgadmin.sourceforge.net/

Re: [GENERAL] Basic questions about PQprepare()

2006-01-29 Thread Joachim Wieland
Alexander, On Sat, Jan 28, 2006 at 08:26:01PM +0100, Alexander Farber wrote: > Could you explain a bit more, where to get the OIDs? They are in the pg_type table, it is described here: http://www.postgresql.org/docs/8.1/static/catalog-pg-type.html You can select it like any other table: select

Re: [GENERAL] creating users per database

2006-01-29 Thread Karsten Hilbert
On Sat, Jan 28, 2006 at 06:17:16PM -0500, Tom Lane wrote: > > I am using a create_user() SP created by "postgres" with > > "security definer" (gasp). This works just fine, however, it > > transfers createuser rights to *anyone* allowed to connect > > to the database the function is in. > > Not if

Re: [GENERAL] help

2006-01-29 Thread Andreas Kretschmer
Paolo Ditto <[EMAIL PROTECTED]> schrieb: > Hi. > I would want do a php script to access my postgres database from > remote host. I would like to know how I can do. Particularly, I would 1. you database must listen on TCP/IP and 2. the remote host needs privileges to connect to the DB Read h