From: mark durrant <markd89@yahoo.com>
To: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-performance@postgresql.org
Subject: Re: Select performance vs. mssql
Date: Tue, 24 May 2005 12:13:27 -0700 (PDT)
Message-ID: <20050524191328.58243.qmail@web53110.mail.yahoo.com> (raw)
I'm far from an expert, so this may be off-base... but
perhaps a suggestion would be to allow a hint to be
sent to the optimizer if the user doesn't care that
the result is "approximate" maybe then this wouldn't
require adding more overhead to the indexes.
MSSQL has something like this with (nolock)
i.e. select count(*) from customers (nolock) where
name like 'Mark%'
Regardless, I'm very impressed with PostgreSQL and I
think we're moving ahead with it.
Mark
--- Bruno Wolff III <bruno@wolff.to> wrote:
> On Tue, May 24, 2005 at 08:36:36 -0700,
> mark durrant <markd89@yahoo.com> wrote:
> >
> > --MSSQL's ability to hit the index only and not
> having
> > to go to the table itself results in a _big_
> > performance/efficiency gain. If someone who's in
> > development wants to pass this along, it would be
> a
> > nice addition to PostgreSQL sometime in the
> future.
> > I'd suspect that as well as making one query
> faster,
> > it would make everything else faster/more scalable
> as
> > the server load is so much less.
>
> This gets brought up a lot. The problem is that the
> index doesn't include
> information about whether the current transaction
> can see the referenced
> row. Putting this information in the index will add
> significant overhead
> to every update and the opinion of the developers is
> that this would be
> a net loss overall.
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/
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: markd89@yahoo.com, bruno@wolff.to
Subject: Re: Select performance vs. mssql
In-Reply-To: <20050524191328.58243.qmail@web53110.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