On 17 Jul 2002 at 21:00, Devdas Bhagat wrote: > On 17/07/02 19:45 +0530, Shridhar Daithankar wrote: > > And pgaccess.. haven't used it ever since I abondened RedHat.. Never found that > > on a default mandrake install and once I grew up to psql for everything, didn't > > miss that either..;-) > Hey, I need to allow windows developers access to Pg, remember? > /me uses psql (or more often, Perl).
Since topic has come to pg, I have few doubts to ask, 1)In one of my app. I need non-blocking database connectionfrom libpq++. So that I can fire a query and later check whether query is done. I have found that you can do that for one query. i.e. you can queue at the most one query per connection asynchronously. Any idea how you can do more than one query? so that I can retrieve results in random order.. pqsendquery/pqgetresult are no good. They send/retrieve only one query/result in pair..Not goo enough.. 2)I want to vacuum a table periodically because it improves my app. throughput 3 times. When I run 'vacuum verbose analyze table', it prints the statistics. If I can get that just that statistics, I can better decide/code when to trigger vacuum from client app. Would make my app. much better sulf tuning at runtime.. 3)Not a question but again a request for comparison(RFC?..;-)). I am running a benchmark simulation where a single transaction involves update on a 100 row table and insert in a log table, which grows with transaction count. I am getting 300tps on a P-III/500/256MB RAM machine with 100 row table vacuumed every 10K transactions. Is this good enough on database tuning part of it? I have allocated 15K buffers and database is started with -F option.. Bye Shridhar -- Larkinson's Law: All laws are basically false. ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
