"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 comp
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, vmsta
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
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
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
On Mon, 2005-31-10 at 17:16 -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, our I/
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,
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, our I/O wait time was about 60% and cpu utilization rarely got very
