From: Bill Chandler <billybobc1210@yahoo.com>
To: Kris Jurka <books@ejurka.com>
Cc: pgsql-jdbc@postgresql.org
Cc: pgsql-perform@postgresql.org
Subject: Re: [PERFORM] Cursors performance
Date: Tue, 13 Jul 2004 09:13:46 -0700 (PDT)
Message-ID: <20040713161346.62000.qmail@web51404.mail.yahoo.com> (raw)
In-Reply-To: <Pine.BSO.4.56.0407121610180.24837@leary.csoft.net>
All,
Looks like I may have beaten this one to death. May
have to chalk it up to a limitation for now due to
deadlines and revisit it later.
One final clue before I go: if I change my wildcard to
'NEPOOL%' from 'NEPOOL%REAL%' my query completes much
faster. Of course this makes sense since it's much
easier to search a string for a prefix than it is to
do a complex regular expression match. I just didn't
expect it to be orders of magnitude difference.
The table containing the string being searched is only
7500 rows but I am joining it with a table with
2.5 million rows. So maybe there's something I can do
to do the wildcard search on the smaller table first
then do the join.
Ok, thanks again to all who responded. Really
appreciate the tips on logging statements and
duration, etc.
regards,
Bill
--- Kris Jurka <books@ejurka.com> wrote:
>
>
> On Mon, 12 Jul 2004, Barry Lind wrote:
>
> > Bill,
> >
> > I suspect that this is an artifact of using server
> side prepared
> > statements. When testing this via psql you will
> be forming sql like:
>
> I don't think so. The 7.4 driver can use either
> cursors or server
> prepared statements, not both. He's definitely
> using cursors, so I server
> prepared statements don't come into the mix here.
>
> Kris Jurka
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: billybobc1210@yahoo.com, books@ejurka.com, pgsql-jdbc@postgresql.org, pgsql-perform@postgresql.org
Subject: Re: [PERFORM] Cursors performance
In-Reply-To: <20040713161346.62000.qmail@web51404.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox