[PERFORM] Select with qualified join condition / Batch inserts

significant performance improvement in Oracle. In postgres, I did not observe any performance improvement using batch execution. Are there any special caveats when using batch execution with postgres? Thanks and regards Bernd ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[PERFORM] Best hardware

ic, just send me a link where I can read up on this Thanks a lot for your kind replies. Bernd Bernd Jagla, PhD Associate Research Scientist Columbia University ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PERFORM] Partitioning

ther their syntax is cleaner, more powerful or easier or ;) Bernd [1] http://dev.mysql.com/doc/refman/5.1/en/partitioning-subpartitions.html ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [PERFORM] Partitioning

hat (i just wondered why i need a subpartition to change the location of a partition). Thanks for your clarification... Bernd ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail com

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

ing is too high: i've found rate settings counterproductive when set too high (try a value slightly above your max bandwidth of your connection). But i second Heikki, you should take care on your disk setup as well. -- Thanks Bernd ---(end of broadcast)-

Re: [PERFORM] DRBD and Postgres: how to improve the perfomance?

nging to B as long as I'm aware that it changed semantics and I can deal with them. -- Thanks Bernd ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[PERFORM] column without pg_stats entry?!

I change it somehow? If not, is there a better way to accomplish what I'm trying? I'm not to keen on disabling seqscan for that query explicitly. It's a simple enough query and the planner should be able to find the right plan without help - and I'm sure it would i

Re: [PERFORM] column without pg_stats entry?!

mporary palloc's */ On 21.01.2005, at 7:02 Uhr, Tom Lane wrote: Bruno Wolff III <[EMAIL PROTECTED]> writes: Bernd Heller <[EMAIL PROTECTED]> wrote: there is no entry in pg_stats for that column at all!! I can only suspect that this has to do with the column being all null. Someone e

Re: [PERFORM] Check Pointer

ess  On Linux i often find the pmap utility a far better tool to get an idea what a process actually consumes of memory. The output can be large sometimes, but it's more "fine grained". -- Thanks Bernd -- Sent via pgsql-performance mailing list