Your question: Is there any way that I can build multiple indexes on one
table without having to scan the table multiple times?
My answer: I don't think so. Since each index has a different indexing
rule, it will analyze the same table in a different way. I've built indexes
on a 100GB table recent
On Wed, Jul 23, 2014 at 4:40 PM, Marc Mamin wrote:
>>On Thu, Jul 17, 2014 at 7:47 PM, Chris Ruprecht wrote:
>>> Is there any way that I can build multiple indexes on one table without
>>> having to scan the table multiple times? For small tables, that's probably
>>> not an issue, but if I have
>Von: pgsql-performance-ow...@postgresql.org
>[pgsql-performance-ow...@postgresql.org]" im Auftrag von "Claudio
>Freire [klaussfre...@gmail.com]
>Gesendet: Freitag, 18. Juli 2014 01:21
>An: Chris Ruprecht
>Cc: pgsql-performance@postgresql.org
>Betreff: Re: [PERFOR
On Thu, Jul 17, 2014 at 7:47 PM, Chris Ruprecht wrote:
> Is there any way that I can build multiple indexes on one table without
> having to scan the table multiple times? For small tables, that's probably
> not an issue, but if I have a 500 GB table that I need to create 6 indexes
> on, I don'
Is there any way that I can build multiple indexes on one table without having
to scan the table multiple times? For small tables, that's probably not an
issue, but if I have a 500 GB table that I need to create 6 indexes on, I don't
want to read that table 6 times.
Nothing I could find in the m
