The index can produce the sorted output. Add a dummy WHERE clause like
articoli > and data_ent > .
--Imad
On Mon, Sep 28, 2009 at 10:18 PM, Sgarbossa Domenico
wrote:
>
> I need to retrieve the most recent prices per products from a price list
> table:
>
> CREATE TAB
To be sure about the performance of index scan, try forcing the
planner to use it instead of seq scan. A way might be to force the
planner to use index scan on your table by using a dummy where clause.
Try using a condition in your where clause which holds true for all
rows.
--Imad
work-mem tells the size of physical memory only, virtual memory is
always there off course in case you run out of available memory.
I recommend you reading PostgreSQL internals for all this stuff:
http://www.postgresql.org/docs/8.0/static/internals.html
--Imad
www.EnterpriseDB.com
On 1/29/07
d.
Performance increment can also be gained by disabling constraints in the
transaction. These disabled constraints are invoked at the end of the
transaction according to the SQL standard, so no worries about data
consistency.
Hmmm... PG currently supports disabling foreign constraints only. But
Yes. This is connection pooling. You can find a lot of examples from
the internet on connection pooling, rather source codes. Also keep in
mind that connection pools can be maintained on the application as
well as the database server side. Check which one suits you.
--Imad
www.EnterpriseDB.com
