Thanks for the suggestion. This seems to work pretty well on 8.3, but not so
well on 8.2. We were planning on upgrading to 8.3 soon anyway, we just have
to move up our schedule a bit.
I think that this type of algorithm would make sense in core. I suspect that
being in there some further optimi
Alvaro wrote:
> Move the old clog files back where they were, and run VACUUM FREEZE in
> all your databases. That should clean up all the old pg_clog files, if
> you're really that desperate. This is not something that I'd recommend
> doing on a periodic basis ...
Thank you for your suggestions.
Rex Mabry wrote:
> Try this query for looking at queries.
Thanks so much for your reply.
> SELECT procpid, usename , (now() - query_start) as age, query_start, l.mode,
> l.granted
> FROM pg_stat_activity a LEFT OUTER JOIN pg_locks l ON (a.procpid = l.pid)
> LEFT OUTER JOIN pg_class c ON (l
Hi everyone,
some erp software requires a change of my pgsql cluster from
locale Cencoding UTF-8
to
locale de_DE.UTF-8 encoding UTF-8
Most of my databases have only ASCII text data (8 bit UTF8 code range)
in the text columns.
Does the above change influenc
