Re: [PERFORM] Building multiple indexes on one table.

2014-07-23 Thread Marc Mamin
Von: pgsql-performance-ow...@postgresql.org [pgsql-performance-ow...@postgresql.org]quot; im Auftrag von quot;Claudio Freire [klaussfre...@gmail.com] Gesendet: Freitag, 18. Juli 2014 01:21 An: Chris Ruprecht Cc: pgsql-performance@postgresql.org Betreff: Re: [PERFORM] Building multiple indexes

Re: [PERFORM] Building multiple indexes on one table.

2014-07-23 Thread Claudio Freire
On Wed, Jul 23, 2014 at 4:40 PM, Marc Mamin m.ma...@intershop.de wrote: On Thu, Jul 17, 2014 at 7:47 PM, Chris Ruprecht ch...@cdrbill.com 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

[PERFORM] Building multiple indexes on one table.

2014-07-17 Thread Chris Ruprecht
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

Re: [PERFORM] Building multiple indexes on one table.

2014-07-17 Thread Claudio Freire
On Thu, Jul 17, 2014 at 7:47 PM, Chris Ruprecht ch...@cdrbill.com 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