"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> On Jan 8, 2007, at 10:32 AM, Erik Jones wrote:
>> One question regarding my previous thread about the 8.2 client
>> tools. We have yet to have time (personal as well as usage pattern
>> constraints) to dump our schema to analyze it for any po
Ah, I'd been looking at the following from Ch. 23.5 Backup and Restore
and was hoping it would go in both directions:
"It is recommended that you use the pg_dump and pg_dumpall programs from
the newer version of PostgreSQL, to take advantage of any enhancements
that may have been made in these
On Jan 8, 2007, at 10:32 AM, Erik Jones wrote:
Erik Jones <[EMAIL PROTECTED]> writes:
One question regarding my previous thread about the 8.2 client
tools. We have yet to have time (personal as well as usage pattern
constraints) to dump our schema to analyze it for any possible
discrepe
Tom Lane wrote:
Erik Jones <[EMAIL PROTECTED]> writes:
Before migrating to 8.2, even during peak times, unless queries were
seriously stacking (not completing in a timely manner), we'd see at most
50 - 100 queries active at any given time (we did have
stats_command_string = on). Since the
Erik Jones <[EMAIL PROTECTED]> writes:
> Before migrating to 8.2, even during peak times, unless queries were
> seriously stacking (not completing in a timely manner), we'd see at most
> 50 - 100 queries active at any given time (we did have
> stats_command_string = on). Since the migration, du
Erik Jones wrote:
> Hi, this question is mostly born of curiosity: when monitoring our
> database I often use the following queries to get a current query count
> and listing of individual queries:
>
> select count(*)
> from pg_stat_activity
> where current_query not ilike '';
>
> select proc
Hi, this question is mostly born of curiosity: when monitoring our
database I often use the following queries to get a current query count
and listing of individual queries:
select count(*)
from pg_stat_activity
where current_query not ilike '';
select procpid, (now() - query_start) as query