How to set partial index with npgsql?

Asked Feb 18 '20 at 16:13

Active Feb 18 '20 at 16:16

Viewed 844 times

I have very big table Pushes that contains Sent field (boolean). I saw this question. Now I know that I need partial index. Because I'm going to select all rows that have Sent as true (~ 30% from whole table). After this, I'm going to find special row that I need by some conditions. I hope to have a growth of performance after setting the index. I saw this issue. But I don't understand how to set partial index for current npgsql version. I use .Net Core 3.1, all packages have the last version. Current npgsql version is 3.1.1.2. I can't find .HasIndexPartial method. Was it removed?

I can call only

// indexes
modelBuilder.Entity<Push>()
    .HasIndex(x => x.Sent);

But how I can say here that it's partial index?

edited Feb 18 '20 at 16:16

asked Feb 18 '20 at 16:13

Aleksej_Shherbak

2,757
5
34
71

7

Looking at [this issue](https://github.com/npgsql/efcore.pg/issues/286), it looks like you use syntax like `b.HasIndex(x => x.Sent).HasFilter(/* filter here */);` – stuartd Feb 18 '20 at 16:32
It seems you are right. I didn't pay attention( Thank you! – Aleksej_Shherbak Feb 18 '20 at 17:36
2

@stuartd If you posted that as an answer, I'd upvote. It works! – Nate Barbettini Apr 25 '22 at 19:14

How to set partial index with npgsql?

0 Answers0