Re: Understanding partial index selection

2023-12-01 Thread Owen Nelson
it sounds like the only other odd thing is "Aurora not being Postgres," which I'm not sure there's much I can do about right now :( On Tue, Nov 28, 2023 at 9:23 PM Adrian Klaver wrote: > On 11/28/23 18:13, Owen Nelson wrote: > > > Aurora is not really Postgres &

Re: Understanding partial index selection

2023-11-28 Thread Owen Nelson
> Aurora is not really Postgres Oh geez, I didn't realize there was such a divide. This is my first look at Aurora and I thought it was just a hosted postgres offering. Still, I'll take what I can get. Hopefully, some of this will carry over.

Re: Understanding partial index selection

2023-11-28 Thread Owen Nelson
tly able to `SET seqscan_enabled TO off`. The access I have right now only permits single statements, executed separately. Comparing the cost is an interesting idea though, so I'll see what I can do. On Tue, Nov 28, 2023 at 2:23 PM Owen Nelson wrote: > Hi! > > I've got a query running

Understanding partial index selection

2023-11-28 Thread Owen Nelson
Hi! I've got a query running periodically which has been degrading in performance as time goes on. I'm hoping to better understand what the contributing factors are. Given a table with: ``` postgres=# \d message Table "public.message" Column |