Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Why is my (empty) partial index query slow?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Richard Frith-Macdonald <richard(at)tiptree(dot)demon(dot)co(dot)uk>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Why is my (empty) partial index query slow?
- Date: Thu, 22 Jun 2006 20:43:52 -0400
Richard Frith-Macdonald <richard(at)tiptree(dot)demon(dot)co(dot)uk> writes: > What has confused me is why a query using an empty index should be > slow, irrespective of the state of the table that the index applies to. Is it actually empty, or have you just deleted-and-not-yet-vacuumed all the rows in the index? I had hoped to see comparative EXPLAIN ANALYZE output for the fast and slow cases. Maybe when it gets slow again you could redo the explain. regards, tom lane
- References:
- Why is my (empty) partial index query slow?
- From: Richard Frith-Macdonald
- Re: Why is my (empty) partial index query slow?
- From: Tom Lane
- Why is my (empty) partial index query slow?
- Prev by Date: Re: Query hanging/not finishing inconsistently
- Next by Date: Occupation bloc in pages of table
- Previous by thread: Re: Why is my (empty) partial index query slow?
- Next by thread: Sun Donated a Sun Fire T2000 to the PostgreSQL community
- Indexes: