Sounds more like a school project than a proper performance question.
On 11/28/09, Reydan Cankur reydan.can...@gmail.com wrote:
Hi,
I am trying to run postgresql functions with threads by using OpenMP.
I tried to parallelize slot_deform_tuple function(src/backend/access/
common/heaptuple.c)
I'm a BSD license fan, but, I don't know much about *BSD otherwise (except
that many advocates say it runs PG very nicely).
On the Linux side, unless your a dweeb, go with a newer, popular well
supported release for Production. IMHO, that's RHEL 5.x or CentOS 5.x. Of
course the latest SLES
Hi all,
As the author of BenchmarkSQL and the founder of EnterpriseDB I
can assure you that BenchmarkSQL was NOT written specifically for
PostgreSQL.It is intended to be a completely database agnostic
tpc-c like java based benchmark.
However; as Jonah correctly points out in painstaking
they are not occosaionally extrenmely useful. All hints are
effectively harmless/helpful suggestions, the planner is free to
ignore them if they are not feasible.
--Denis Lussier
Founder
http://www.enterprisedb.com
On 10/7/06, Tom Lane [EMAIL PROTECTED] wrote:
Craig A. James [EMAIL PROTECTED] writes
If the real world applications you'll be running on the box are Java
(or use lots of prepared statements and no stored procedures)... try
BenchmarkSQL from pgFoundry. Its extremely easy to setup and use.
Like the DBT2, it's an oltp benchmark that is similar to the tpc-c.
--Denis Lussier
http
I agree that OCFS 2.0 is NOT a general purpose PG (or any other) solution. My recollection is that OCFS gave about 15% performance improvements (same as setting some aggressive switches on ext3). I assume OCFS has excellent crash safety with its default settings but we did not test this as of yet.
My theory, based entirely on what I have read in this thread, is that a low end server (really a small workstation) with an Intel Dual Core CPU is likely an excellent PG choice for the lowest end.I'll try to snag an Intel Dual Core workstation in the near future and report back DBT2 scores
If your server is heavily I/O bound AND you care about your data AND your are throwing out your WAL files in the middle of the day... You are headed for a cliff. I'm sure this doesn't apply to anyone on this thread, just a general reminder to all you DBA's out there who sometimes are too busy to
I was kinda thinking that making the Block Size configurable at InitDB time would be a nice simple enhancement for PG 8.3. My own personal rule of thumb for sizing is 8k for OLTP, 16k for mixed use, 32k for DWH.
I have no personal experience with XFS, but, I've seen numerous internal
at
http://www.powerpostgresql.com/PerfList/.
The moral of this unreasonably verbose email is that you shouldn't abuse BenchmarkSQL andmeasure runswithout making sure that, at least, quick/simple best practices have been applied to tuning the db's you are choosing to test.
--Denis Lussier
CTO
http
% average slowdown for the handful of PLpgSQL functions we tested when this feature is turned on.
Would the community be potentially interested in this feature if we created a BSD Postgres patch of this feature for PLpgSQL (likely for 8.3)??
--Luss
Denis Lussier
CTO
http://www.enterprisedb.com
procs allows for explicit
transaction control inside of a stored procedure?
--Luss
On 7/27/06, Tom Lane [EMAIL PROTECTED] wrote:
Denis Lussier [EMAIL PROTECTED] writes:
Would the community be potentially interested in this feature if we created
a BSD Postgres patch of this feature for PLpgSQL
with pg_bench, which is a simpler OLTP benchmark that I believe is similar to a TPC-B.
--Denis Lussier
CTO
http://www.enterprisedb.com
On 7/21/06, Petronenko D.S. [EMAIL PROTECTED] wrote:
Hello,does anybody use OSDB benchmarks for postgres?if not, which kind of bechmarks are used for postgres
13 matches
Mail list logo
