vinita bansal wrote:
Hi,
I have a 40GB database with a few tables containing approx 10 million rows. Most of the data in these tables is inactive and there is only a few rows which get used for our benchmark run each day. We cannot delete the inactive data since it might be required for a particular run some day while it is active data that is used mostly.
Is there some pattern to which data is being accessed. For example, in an accounts system it might be rows with paid=false.
If the above is the case you could create an expression index specifically for your clause.
You could also archive out the old information into another schema and access it when required using UNIONS.
Sincerely,
Joshua D. Drake Command Prompt, Inc.
-- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedication Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
