[ADMIN] How to improve Postgres performance

Hi All, I am running an application, which connects to the postgres database at initialization time and perform the database operations like Select/Update. Database queries are very simple. On analyzing my application through Quantifier( Performance analyzing tool), I found the most

Re: [ADMIN] password authentication with external passwd file

Jason Stone <[EMAIL PROTECTED]> writes: > out of curiosity, why was the secondary password file capability removed? You'd have to look into the pghackers archives for details, but my recollection is that it didn't play nicely with other features that we wanted to add. > I really liked the simplic

Re: [ADMIN] password authentication with external passwd file

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I would like to know first, if I'm mistaken, or if external passwd files are now specified in some other way, or must be enabled at compile time or something like that; ie, am I doing something wrong? The 7.3 Release Notes have the following items

[ADMIN] sqlstate 02000 while declaring cursor/freeing statement

I'm new to the PostgreSQL community so please pardon what is probably a silly question ... I'm in the process of porting Informix ESQL to PostgreSQL. I occasionally get sqlcode = 100 and sqlstate = 02000 when declaring cursors or freeing prepared statements. Is this normal? For example:

[ADMIN] Unsubscribe

Unsubscribe ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [ADMIN] Query failed: ERROR: deadlock detected

thanks for the explanation... i found the mistake in a new pl/pgsql function i wrote before this error occured;-) Oliver Elphick wrote: > On Mon, 2005-08-29 at 16:50 +0100, Aldor wrote: > >>PostgreSQL 8.0.3: Any idea what this is? >> >>--- >>Warning: pg_query(): Query failed: ERROR: deadlock det

Re: [ADMIN] Query failed: ERROR: deadlock detected

On Mon, 2005-08-29 at 16:50 +0100, Aldor wrote: > PostgreSQL 8.0.3: Any idea what this is? > > --- > Warning: pg_query(): Query failed: ERROR: deadlock detected > DETAIL: Process 8835 waits for ShareLock on transaction 193588236; > blocked by process 8834. > Process 8834 waits for ShareLock on t

[ADMIN] Query failed: ERROR: deadlock detected

PostgreSQL 8.0.3: Any idea what this is? --- Warning: pg_query(): Query failed: ERROR: deadlock detected DETAIL: Process 8835 waits for ShareLock on transaction 193588236; blocked by process 8834. Process 8834 waits for ShareLock on transaction 193588228; blocked by process 8835 --- I have neve

[ADMIN] Unsubscibe

Unsubscibe

[ADMIN] Unsubscribe

Unsubscribe__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com