Re: [PERFORM] Response time
How do we measure the response time in postgresql? Your response would be very much appreciated. Thanks and Regards, Radha ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [PERFORM] Response time
The \timing psql command gives different time for the same query executed repeatedly. So, how can we know the exact response time for any query? Thanks and Regards, Radha > On Tue, 2003-11-04 at 09:49, [EMAIL PROTECTED] wrote: >> How do we measure the response time in postgresql? > > In addition to EXPLAIN ANALYZE, the log_min_duration_statement > configuration variable and the \timing psql command might also be > useful. > > -Neil > > > > ---(end of broadcast)--- > TIP 8: explain analyze is your friend ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] error while executing a c program with embedded sql
I have a c program called test1.pgc with some sql statements embedded in it. The program was preprocessed, compiled and linked. Now, I have the executable test1. When I run the executable it says, ./test1: error while loading shared libraries: libecpg.so.3: cannot open shared object file: No such file or directory What does it mean by this error message? What should I do to correct this error and run the executable successfully? Your response would be very much appreciated. Thanks and Regards, Radha ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [PERFORM] [NOVICE] error while executing a c program with embedded sql
Thanks a lot. IT WORKED! with your suggestions. Regards, Radha > On Sun, 2003-11-09 at 15:06, [EMAIL PROTECTED] wrote: >> I have a c program called test1.pgc with some sql statements embedded >> in it. The program was preprocessed, compiled and linked. Now, I have >> the executable test1. >> >> When I run the executable it says, >> >> ./test1: error while loading shared libraries: libecpg.so.3: cannot >> open shared object file: No such file or directory >> >> What does it mean by this error message? What should I do to correct >> this error and run the executable successfully? > > Shared libraries are loaded from directories specified to the system by > ldconfig. Your shared library, libecpg.so.3, is in a PostgreSQL > directory, such as /usr/local/pgsql/lib, which has not been added to the > directories known to the loader. > > If you are able to add that directory with ldconfig, that is the best > way to do it, but it requires root privilege. > > Otherwise you can set the environment variable LD_LIBRARY_PATH, thus: > > export LD_LIBRARY_PATH=/usr/local/pgsql/lib > > before you run the program, or you can use LD_PRELOAD: > > LD_PRELOAD=/usr/local/pgsql/lib/libecpg.so.3 ./test1 > > -- > Oliver Elphick[EMAIL PROTECTED] > Isle of Wight, UK > http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 > 5839 932A 614D 4C34 3E1D 0C1C > > "O death, where is thy sting? O grave, where is > thy victory?" 1 Corinthians 15:55 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [PERFORM] Error in transaction processing
When I execute a transaction using embedded sql statements in a c program, I get the error, Error in transaction processing. I could see from the documentation that it means, "Postgres signalled to us that we cannot start, commit or rollback the transaction" I don't find any mistakes in the transaction statements. What can I do to correct this error? Your response would be very much appreciated. Thanks and Regards, Radha ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [PERFORM] Error in transaction processing
When I execute a transaction using embedded sql statements in a c program, I get the error, Error in transaction processing. I could see from the documentation that it means, "Postgres signalled to us that we cannot start, commit or rollback the transaction" I don't find any mistakes in the transaction statements. What can I do to correct this error? Your response would be very much appreciated. Thanks and Regards, Radha ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
