On Fri, Oct 21, 2005 at 12:25:36PM +0200, Nicolas Barbier wrote:
> On 10/21/05, Richard Huxton wrote:
> > jeff sacksteder wrote:
> > > Are there known limits to how many rows can be inserted by one
> > > transaction,
>
> > Well, the system will need to be able to roll back the transaction, ...
>
On Wed, Oct 19, 2005 at 09:55:18AM -0700, William Yu wrote:
> Mark Rae wrote:
> >With the newer kernels you should find that a dual core will
> >be giving you about 80% increase over a single core.
>
> I'm not experiencing this problem right now because I have NU
On Wed, Oct 19, 2005 at 12:32:36AM -0700, William Yu wrote:
> Expect to need to upgrade to later Linux cores though. Previous kernel
> on this server was 2.6.9+ (FC3 64-bit) -- promptly kernel panic'd upon
> install of the DCs. FC3 installer did the same thing. Went to FC4
> (2.6.11+) and it has
Hi,
Using COMMENT ON DATABASE only allows you to create a comment
for your current database which is then only visible from that database.
However, if I manually insert appropriate values into pg_description
in other databases I can make comments appear for another database.
e.g. If some users ha
On Tue, Jul 12, 2005 at 03:11:35PM -0500, Scott Marlowe wrote:
> On Tue, 2005-07-12 at 15:06, Mark Rae wrote:
> > I think its more a case of AMD now having solid evidence to back
> > up the claims.
>
> Wow! That's pretty fascinating. So, is the evidence pretty
> o
On Tue, Jul 12, 2005 at 01:41:14PM -0500, Scott Marlowe wrote:
> On Tue, 2005-07-12 at 13:24, Mohan, Ross wrote:
> > From AMD's suit against Intel. Perhaps relevant to some PG/AMD issues.
> Well, this is, right now, just AMD's supposition about Intel's
> behaviour, I'm not sure one way or the othe
On Fri, Mar 18, 2005 at 01:31:51PM -0500, Tom Lane wrote:
> BTW, although I know next to nothing about NUMA, I do know that it is
> configurable to some extent (eg, via numactl). What was the
> configuration here exactly, and did you try alternatives? Also,
> what was the OS exactly? (I've heard
On Fri, Mar 18, 2005 at 10:38:24AM -0500, Tom Lane wrote:
> Hey, that looks pretty sweet. One thing this obscures though is whether
> there is any change in the single-client throughput rate --- ie, is "1.00"
> better or worse for CVS tip vs 8.0.1?
Here are the figures in queries per second.
Cli
On Tue, Mar 15, 2005 at 07:00:25PM -0500, Bruce Momjian wrote:
> Oh, you have to try CVS HEAD or a nightly snapshot. Tom made a major
> change that allows scaling in SMP environments.
Ok, I've done the tests comparing 8.0.1 against a snapshot from the 16th
and the results are impressive.
As well
On Tue, Mar 15, 2005 at 07:00:25PM -0500, Bruce Momjian wrote:
> Oh, you have to try CVS HEAD or a nightly snapshot. Tom made a major
> change that allows scaling in SMP environments.
Ok, I'll give it a try in the next couple of days when there is
some free time available on the machine.
-Ma
On Tue, Mar 15, 2005 at 06:46:50PM -0500, Bruce Momjian wrote:
> Mark Rae wrote:
> > Also, while on the subject of scaling. I had the opportunity
> > to try postgres on a 16CPU Altix and couldn't get it to scale
> > more than about 4x, whereas Oracle got up to about 12x
On Tue, Mar 15, 2005 at 12:51:03PM -0800, Jeff Davis wrote:
> Be careful assuming that. DB benchmarks are hard to do in a general
> sense. His results probably indicate a general trend, but you should
> test your application yourself to get a real result. His pattern of SQL
> queries might be very
On Mon, Mar 14, 2005 at 06:04:01PM -0500, Chris Browne wrote:
> [EMAIL PROTECTED] (Mark Rae) writes:
>> Clients 1 2 3 4 6 812163264
>> 128
>> --
>&g
On Mon, Mar 14, 2005 at 06:52:58AM -0500, Rick Schumeyer wrote:
> Below are some PRELIMINARY results in comparing the performance of pgsql and
> mysql.
> ...
> I have not yet done any testing of transactions, multiple concurrent
> processes, etc.
>
I would say that doing the concurrency tests is
On Fri, Jan 07, 2005 at 12:04:00PM -0400, Marc G. Fournier wrote:
> A current list of *known* supported platforms can be found at:
> http://developer.postgresql.org/supported-platforms.html
> We're always looking to improve that list, so we encourage anyone that is
> running a platform not l
15 matches
Mail list logo
