From: Pablo Alcaraz <pabloa@laotraesquina.com.ar>
To: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: TB-sized databases
Date: Wed, 28 Nov 2007 09:15:11 -0500
Message-ID: <474D77EF.8090605@laotraesquina.com.ar> (raw)
In-Reply-To: <Pine.LNX.4.58.0711281248290.3731@aragorn.flymine.org>
References: <4544e0330711260904g45d893a8ub1731e245aa8fc84@mail.gmail.com>
<474B1407.3090607@laotraesquina.com.ar>
<474B1B8C.1030505@gmail.com>
<4544e0330711271218h56ce4cc3p280a9fefff24583d@mail.gmail.com>
<1196197045.4246.1154.camel@ebony.site>
<474CA2FA.2020201@laotraesquina.com.ar>
<Pine.LNX.4.58.0711281248290.3731@aragorn.flymine.org>
Matthew wrote:
> On Tue, 27 Nov 2007, Pablo Alcaraz wrote:
>
>> it would be nice to do something with selects so we can recover a rowset
>> on huge tables using a criteria with indexes without fall running a full
>> scan.
>>
>
> You mean: Be able to tell Postgres "Don't ever do a sequential scan of
> this table. It's silly. I would rather the query failed than have to wait
> for a sequential scan of the entire table."
>
> Yes, that would be really useful, if you have huge tables in your
> database.
>
Thanks. That would be nice too. I want that Postgres does not fall so
easy to do sequential scan if a field are indexed. if it concludes that
the index is *huge* and it does not fit in ram I want that Postgresql
uses the index anyway because the table is *more than huge* and a
sequential scan will take hours.
I ll put some examples in a next mail.
Regards
Pablo
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: pabloa@laotraesquina.com.ar
Subject: Re: TB-sized databases
In-Reply-To: <474D77EF.8090605@laotraesquina.com.ar>
* 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