Re: Asking advice on speeding up a big table - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Asking advice on speeding up a big table
Date
Msg-id cone.1145118123.188398.47312.1000@zoraida.natserv.net
Whole thread Raw
In response to Asking advice on speeding up a big table  (felix@crowfix.com)
List pgsql-general
felix-accts-pgsql@crowfix.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. :)


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 21 bit number for sequence
Next
From: "Claudio Alejandro Ulloa Heinsohn"
Date:
Subject: Update from diferents conditions