SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-24-2008, 06:16 PM
| |||
| |||
 Re: SELECT 'DBD::Pg ping test' sathiya psql wrote: > Hi All, > > This query is being executed nearly a million times.... > SELECT 'DBD::Pg ping test' > > Why this is being executed ? What is the use ? A client is sending a query to the server solely to see if the server responds. DBD::Pg is the Perl database driver for PostgreSQL. Presumably the application using that driver has some sort of keepalive or database connectivity check enabled, so it's periodically issuing these queries. -- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance      |
|
04-24-2008, 06:16 PM
| ||||
| ||||
| Re: SELECT 'DBD::Pg ping test' On Wed, Apr 23, 2008 at 12:19 AM, sathiya psql <sathiya.psql@gmail.com> wrote: > Hi All, > > This query is being executed nearly a million times.... > SELECT 'DBD::Pg ping test' Something in your Perl application is use $dbh->ping(). See perldoc DBI. It's possible that this is happening under the hood, because your application is using connect_cached() instead of connect(). -jwb -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance |
Linear Mode
