Technically you can then use pgbench on that set of statements, but I
usually just use perl's "Benchmark" module (i'm sure ruby or java
or whatever has a similar tool)
(First, I log statements by loading the application or web server with
statement logging turned on so I'm not "guessing" w
Matthew Wakeling writes:
> The gistnext total doesn't seem to correspond to the amount I get by
> adding up all the individual lines in gistnest.
Hmm, hadn't you determined that some other stuff was being inlined into
gistnext? I'm not really sure how opannotate displays such cases, but
this mi
Okay, I don't know quite what's happening here. Tom, perhaps you could
advise. Running opannotate --source, I get this sort of stuff:
/*
* Total samples for file :
".../postgresql-8.4beta2/src/backend/access/gist/gistget.c"
*
* 6880 0.2680
*/
and then:
:static int64
On Thu, 11 Jun 2009, Matthew Wakeling wrote:
A quick grep in the postgres source for mcount reveals no hits. No idea what
it does - there is no man page for it.
Ah - that's part of gprof. I'll recompile without --enable-profiling and
try again. Duh.
Matthew
--
What goes up must come down. A
On Thu, 11 Jun 2009, Tom Lane wrote:
So it'd be worth converting your functions to V1 style.
Does that produce a significant reduction in overhead? (You'll probably
say "yes, that's the whole point").
hmm ... memcpy or qsort maybe?
Surprise:
CPU: Core 2, speed 1998 MHz (estimated)
Counte
On Thu, 2009-06-11 at 16:30 +, Greg Sabino Mullane wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
> >> Then there are Slony-I, Buchardo, Mamoth Replicator from CMO, simple
> >> replication in Postgres 8.4 and other projects...
>
> > CMO? :)
>
> Buchardo? :)
A new desert, Bu
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> Then there are Slony-I, Buchardo, Mamoth Replicator from CMO, simple
>> replication in Postgres 8.4 and other projects...
> CMO? :)
Buchardo? :)
- --
Greg Sabino Mullane g...@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200906111
>
> Then there are Slony-I, Buchardo, Mamoth Replicator from CMO, simple
> replication in Postgres 8.4 and other projects...
CMO? :)
Joshua D. Drake
>
> Suggestions?
> Thanks,
>
> -- Shaul
>
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
Matthew Wakeling writes:
> So it seems that btree_gist and bioseg are not using that much CPU at all,
> compared to core postgres code. In fact, the majority of time seems to be
> spent in libc. Unfortunately my libc doesn't have any debugging symbols.
hmm ... memcpy or qsort maybe?
> Anyway,
On Thu, 11 Jun 2009, Tom Lane wrote:
Oprofile scares me with the sheer number of options.
You can ignore practically all of them; the defaults are pretty sane.
Thanks, that was helpful. Here is the top of opreport --long-filenames:
CPU: Core 2, speed 1998 MHz (estimated)
Counted CPU_CLK_UNHA
Hi,
Shaul Dar writes:
> 1. A staging server, which receives new data and updates the DB
> 2. Two web servers that have copies of the DB (essentially read-only)
> and answer user queries (with load balancer)
[...]
> Suggestions?
I'd consider WAL Shipping for the staging server and some trigger
Matthew Wakeling writes:
> That sucks. However, as another observation, no calls to "gistfindnext"
> are recorded in the profile either, and that's in the same source file as
> "gistnext" which is recorded. Could it have been inlined?
Probably.
> Shouldn't inlining be switched off on a profili
Hi,
Our configuration is as follows:
1. A staging server, which receives new data and updates the DB
2. Two web servers that have copies of the DB (essentially read-only) and
answer user queries (with load balancer)
Currently we use dump (to SQL file, i.e. pg_dump with no args) + file copy
to re
On Wed, 10 Jun 2009, Tom Lane wrote:
Also, no calls to anything including "bioseg"
in the name are recorded, although they are definitely called as the GiST
support functions for that data type.
I have never had any success in getting gprof to profile functions that
are in loadable libraries, w
"Markus Wanner" writes:
> If anybody has ever tried their systems, I'd like to hear back. I wish such
> an offering would exist for Europe (guess that's just a matter of time).
http://www.niftyname.org/
http://lost-oasis.fr/
It seems to be coming very soon, in France :)
--
dim
--
Sent v
15 matches
Mail list logo
