From: Akshay Mathur <akshay.mathur@airtightnetworks.net>
To: 'Ron' <rjpeace@earthlink.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Massive performance issues
Date: Fri, 2 Sep 2005 14:53:58 +0530
Message-ID: <002901c5afa0$0dcddab0$8301a8c0@pune.wibhu.com> (raw)
In-Reply-To: <6.2.3.4.0.20050901163955.021b3708@pop.earthlink.net>
Ron,
Can you give me some pointers to make the tables RAM resident. If one
does so, is the program accessing the data need to change. Does pgsql
take care to write the data to disk?
Regards,
akshay
---------------------------------------
Akshay Mathur
SMTS, Product Verification
AirTight Networks, Inc. (www.airtightnetworks.net)
O: +91 20 2588 1555 ext 205
F: +91 20 2588 1445
-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Ron
Sent: Friday, September 02, 2005 2:36 AM
To: Tom Lane; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Massive performance issues
Even better, if the table(s) can be made RAM resident, then searches,
even random ones, can be very fast. He wants a 1000x performance
improvement. Going from disk resident to RAM resident should help
greatly in attaining that goal.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: akshay.mathur@airtightnetworks.net, rjpeace@earthlink.net
Subject: Re: Massive performance issues
In-Reply-To: <002901c5afa0$0dcddab0$8301a8c0@pune.wibhu.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox