Tom Lane wrote:
This was just covered in excruciating detail yesterday ...
You need to write
order by symbol desc, time desc limit 1
to get the planner to recognize the connection to the sort order
of this index. Since you're only selecting one value of symbol,
the actual output doesn
Hi, I have a small table that has only 23 rows, but I do frequent updates(
every second ) on it.
After running the updates for a while, the performance of SELECT from that
table has deteriated into something like 30 seconds.
So, natually, I did a VACUUM ANALYZE first. Here is the VERBOSE output
On Sat, 11 Oct 2003, Christopher Kings-Lynne wrote:
>
> > I have two very similar queries which I need to execute. They both have
> > exactly the same from / where conditions. When I execute the first, it takes
> > about 16 seconds. The second is executed almost immediately after, it takes
> > 13
