"Mike Sofen" writes:
>> From: Tom LaneSent: Sunday, February 16, 2020 7:30 AM
>>> I've seen people try to do this before. I wonder if the manual page about
>>> partial indexes should explicitly say "don't do that".
> Yes please (seriously). The utter beauty of Postgres is the flexibility a
On Sun, Feb 16, 2020 at 04:43:10PM -0800, Mike Sofen wrote:
> >From: Tom LaneSent: Sunday, February 16, 2020 7:30
> AM
> >I've seen people try to do this before. I wonder if the manual page about
> partial indexes should explicitly say "don't do that".
> > regards, tom lane
>
> Yes pleas
>From: Tom LaneSent: Sunday, February 16, 2020 7:30
AM
>I've seen people try to do this before. I wonder if the manual page about
partial indexes should explicitly say "don't do that".
> regards, tom lane
Yes please (seriously). The utter beauty of Postgres is the flexibility and
powe
Justin Pryzby writes:
> I was reminded of reading this, but I think it's a pretty different case.
> https://heap.io/blog/engineering/running-10-million-postgresql-indexes-in-production
Yeah, the critical paragraph in that is
This isn’t as scary as it sounds for a two main reasons. First, we
On Sat, Feb 15, 2020 at 10:15:53PM +0100, Laurenz Albe wrote:
> > My scenario is that I have a table with 50M rows that are categorized into
> > 10K categories.
> > I need to create a partial index for each category. I have created a index
> > on the category
> > column, hoping that postgres can
Laurenz Albe writes:
> On Sat, 2020-02-15 at 19:04 +0800, MingJu Wu wrote:
>> My scenario is that I have a table with 50M rows that are categorized into
>> 10K categories.
>> I need to create a partial index for each category.
> You don't need a partial index per category, you need a single inde
On Sat, 2020-02-15 at 19:04 +0800, MingJu Wu wrote:
> When creating partial indexes, can postgres utilize another index for
> figuring which rows
> should be included in the partial index, without performing a full table scan?
No; it has to be a full sequential scan.
> My scenario is that I have
On Sat, Feb 15, 2020 at 07:04:48PM +0800, MingJu Wu wrote:
> Hello,
>
> When creating partial indexes, can postgres utilize another index for
> figuring which rows should be included in the partial index, without
> performing a full table scan?
>
> My scenario is that I have a table with 50M rows
Hello
> When creating partial indexes, can postgres utilize another index for
> figuring which rows should be included in the partial index, without
> performing a full table scan?
No.
create index always perform a seqscan on table. And two full table scan for
create index concurrently.
regar
