"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
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 that are categorized into
10K categories. I need to create a partial ind
10 matches
Mail list logo
