I'm seeing some other little oddities in the beta as well. I'm watching an
ALTER TABLE ADD COLUMN right now that has been running almost two hours. I
stopped it the first time at 1 hour; I suppose I'll let it go this time and
see if it ever completes. The table is about 150K rows. Top,
PostgreSQL [EMAIL PROTECTED] writes:
I'm seeing some other little oddities in the beta as well. I'm watching an
ALTER TABLE ADD COLUMN right now that has been running almost two hours. I
stopped it the first time at 1 hour; I suppose I'll let it go this time and
see if it ever completes.
On Mon, 31 Oct 2005 17:16:46 -0600
PostgreSQL [EMAIL PROTECTED] wrote:
We're running 8.1beta3 on one server and are having ridiculous
performance issues. This is a 2 cpu Opteron box and both processors
are staying at 98 or 99% utilization processing not-that-complex
queries. Prior to the
On 1/11/05 2:50 pm, Jon Brisbin [EMAIL PROTECTED] wrote:
On Mon, 31 Oct 2005 17:16:46 -0600
PostgreSQL [EMAIL PROTECTED] wrote:
We're running 8.1beta3 on one server and are having ridiculous
performance issues. This is a 2 cpu Opteron box and both processors
are staying at 98 or 99%
Jon Brisbin [EMAIL PROTECTED] writes:
I have a stock FreeBSD 5.4 box that I put 8.1 on last night. I ran
pgbench against it and my tps dropped from ~300tps in 8.0.3 to 20tps
in 8.1. That's right. 20. No changes in any system configuration.
You sure about that last? These numbers are kind of
On Mon, Oct 31, 2005 at 05:16:46PM -0600, PostgreSQL wrote:
We're running 8.1beta3 on one server and are having ridiculous performance
issues. This is a 2 cpu Opteron box and both processors are staying at 98
or 99% utilization processing not-that-complex queries. Prior to the
upgrade,