Re: Asking advice on speeding up a big table

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: felix-accts-pgsql(at)crowfix(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Asking advice on speeding up a big table
Date: 2006-04-15 16:22:03
Message-ID: cone.1145118123.188398.47312.1000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

felix-accts-pgsql(at)crowfix(dot)com writes:

> I have made some minor changes and speeded things up to around 15-20
> lookups/sec, good enough, but not exciting :-)

hmm let me understand this.
You went from 1 query 3 to 4 seconds to 45 to 60 queries in the same amount
of time... 45 to 60 times faster.. and that is not something to be excited
about. :)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Claudio Alejandro Ulloa Heinsohn 2006-04-15 16:45:32 Update from diferents conditions
Previous Message Tom Lane 2006-04-15 16:04:55 Re: 21 bit number for sequence