Re: [PERFORM] Select with qualified join condition / Batch inserts

> 2/ Batch-inserts using jdbc (maybe this should go to the jdbc-mailing list - > but it is also performance related ...): > Performing many inserts using a PreparedStatement and batch execution makes a > significant performance improvement in Oracle. In postgres, I did not observe > any performa

Re: [PERFORM] postgres performance: comparing 2 data centers

ge- From: Rod Taylor [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 5:27 PM To: Michael Nonemacher Cc: Postgresql Performance Subject: Re: [PERFORM] postgres performance: comparing 2 data centers > The members table contains about 500k rows. It has an index on > (group_id, mem

Re: [PERFORM] postgres performance: comparing 2 data centers

ence isn't a big stretch here.) What can I do to stop or change this behavior? Apologies if this is a known problem... mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Nonemacher Sent: Friday, June 04, 2004 10:43 AM To: [EMAIL PR

[PERFORM] postgres performance: comparing 2 data centers

I have two instances of a production application that uses Postgres 7.2, deployed in two different data centers for about the last 6 months. The sizes, schemas, configurations, hardware, and access patterns of the two databases are nearly identical, but one consistently takes at least 5x longer th