.
Do you know why cannot make the best of the 'LIMIT' criteria in the
first query?
These tables are big, so in my opinion the planner could optimize better.
If this is a deficiency of the planner, I'd like to suggest this feature
into the planner.
Regards,
Antal Attila
--
ould like to suggest this.
I built this case theoretically, but I have more stored procedure which
works with bad performance therefore.
Regards,
Antal Attila
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
the
stored function.
How can I eliminate the function scan while I want to keep the advantages?
In my opinion the optimizer cannot replace the function scan with a more
optimal plan, but this feature may be implemented in the next versions
of PostgreSQL. I would like to suggest this.
I built t
Jim C. Nasby wrote:
How much space does that equate to?
Have you optimized the queries?
Items that generally have the biggest impact on performance in
decreasing order:
1. System architecture
2. Database design
3. (for long-running/problem queries) Query plans
4. Disk I/O
5. Memory
6. CPU
Hi!
What do you suggest for the next problem?
We have complex databases with some 100million rows (2-3million new
records per month). Our current servers are working on low resposibility
in these days, so we have to buy new hardver for database server. Some
weeks ago we started to work with Po
