[GENERAL] Benchmarks?

2005-09-07 Thread Martin Ehmsen
Hi, This is my first mail to this list, so please bear with me. I'm a computer science student doing a thesis on paging algorithms, both from a theoretical and practical viewpoint. I'm currently looking for some standard way of testing the performance of paging alogrithms. But I haven't been

[GENERAL] Benchmarks

2005-01-14 Thread Bruno Tenorio Avila
Is there any benchmark of Postgres 8.00 comparing with previous versions and others DBMS? Bruno

Re: [GENERAL] Benchmarks

2005-01-14 Thread Dann Corbit
: [GENERAL] Benchmarks Is there any benchmark of Postgres 8.00 comparing with previous versions and others DBMS? Bruno

[GENERAL] Benchmarks?

2000-07-11 Thread Bruce Guenter
Greetings. Has anybody produced any benchmarks comparing PostgreSQL to MS SQL Server? If not, can anybody point me to any sources for standardized benchmarks that I could run myself on both? The only benchmarks I've seen so far have been the outdated runs on the MySQL web page, and the recent

[GENERAL] Benchmarks for pgsql?

2000-01-19 Thread Ing. Roberto Andrade Fonseca
Hi: I'm looking for some benchmarks for pgsql, better if they use DBI/DBI, so we could compare psqql versus others DBMS. Is thete any on the net or someone working on it? Saludos, Roberto Andrade Fonseca [EMAIL PROTECTED]

Re: [GENERAL] Benchmarks

2000-01-06 Thread Differentiated Software Solutions Pvt. Ltd.
: Michael Cornelison [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: 05 January 2000 13:18 Subject: [GENERAL] Benchmarks I don't know if this is an already talked about issue. If it is I apologize in advance. I getting ready to gear up for a major database project. I am considering

Re: [GENERAL] Benchmarks

2000-01-06 Thread The Hermit Hacker
On Thu, 6 Jan 2000, Differentiated Software Solutions Pvt. Ltd. wrote: b) There are quite a few things which you'd take for granted in other DBs which postgres does not have. Quite late in the day I was shocked to find that postgres does not have roll-forward transaction logging. They have

Re: [GENERAL] Benchmarks

2000-01-06 Thread Dustin Sallings
On Thu, 6 Jan 2000, The Hermit Hacker wrote: # d) Postgres manual recommends a nightly vacuum. I read this also a bit # late. This is equivalent of rebuild database. While this is in # progress all other clients wait for vacuum release locks. This is # really a handicap for a 24x7 app. # #

Re: [GENERAL] Benchmarks

2000-01-06 Thread The Hermit Hacker
On Thu, 6 Jan 2000, Dustin Sallings wrote: Untrue, vacuum is *extremely* important for updating statistics. If you have a lot of data in a table, and you have never vacuumed, you might as well not have any indices. It'd be nice if you could seperate the stat update from the storage

Re: [GENERAL] Benchmarks

2000-01-06 Thread Dustin Sallings
On Thu, 6 Jan 2000, The Hermit Hacker wrote: # Okay, my understanding is that a vacuum does a 'cleanup', while a vacuum # analyze does a cleanup *and* stats... That may be correct, but the stats without a cleanup would be a nice option. :) That would give me the ability to update my

Re: [GENERAL] Benchmarks

2000-01-06 Thread Bruce Momjian
Untrue, vacuum is *extremely* important for updating statistics. If you have a lot of data in a table, and you have never vacuumed, you might as well not have any indices. It'd be nice if you could seperate the stat update from the storage reclaim. Actually, it'd be nice if you could

RE: [GENERAL] Benchmarks

2000-01-06 Thread Culberson, Philip
ke damn near forever for any number of updates or deletes greater than, say, 30,000 rows. [Snip] -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 06, 2000 10:14 AM To: Dustin Sallings Cc: The Hermit Hacker; [EMAIL PROTECTED] Subject: Re:

RE: [GENERAL] Benchmarks

2000-01-06 Thread Dustin Sallings
000 rows. # # [Snip] # # -Original Message- # From: Bruce Momjian [mailto:[EMAIL PROTECTED]] # Sent: Thursday, January 06, 2000 10:14 AM # To: Dustin Sallings # Cc: The Hermit Hacker; [EMAIL PROTECTED] # Subject: Re: [GENERAL] Benchmarks # # # Untrue, vacuum is *extremely* important for updating s

Re: [GENERAL] Benchmarks (Vacuum)

2000-01-06 Thread Rudy Gireyev
While on the subject of vacuum. I wonder if Tom's time will be better utilized at figuring out how to get rid of vacuum all together rather than trying to fix it. Simply have that functionality replaced with a more modern way of data management and query optimization. That command was nothing but

Re: [GENERAL] Benchmarks (Vacuum)

2000-01-06 Thread Bruce Momjian
While on the subject of vacuum. I wonder if Tom's time will be better utilized at figuring out how to get rid of vacuum all together rather than trying to fix it. Simply have that functionality replaced with a more modern way of data management and query optimization. That command was

Re: [GENERAL] Benchmarks

2000-01-06 Thread Differentiated Software Solutions Pvt. Ltd.
PROTECTED] [EMAIL PROTECTED]; Kimi [EMAIL PROTECTED] Date: 06 January 2000 19:05 Subject: Re: [GENERAL] Benchmarks On Thu, 6 Jan 2000, Differentiated Software Solutions Pvt. Ltd. wrote: b) There are quite a few things which you'd take for granted in other DBs which postgres does not have. Quite

[GENERAL] Benchmarks

2000-01-04 Thread Michael Cornelison
I don't know if this is an already talked about issue. If it is I apologize in advance. I getting ready to gear up for a major database project. I am considering pgsql and oracle on a Intel/Linux platform. I did see the comparison of the different feature of all the databases, but that is not