On Tue, 3 Feb 2004, Christopher Browne wrote:
[EMAIL PROTECTED] (Anjan Dave) writes:
I would like to know whether there are any significant performance
advantages of compiling (say, 7.4) on your platform (being RH7.3, 8,
and 9.0, and Fedora especially) versus getting the relevant binaries
David Teran wrote:
Hi,
we are trying to speed up a database which has about 3 GB of data. The
server has 8 GB RAM and we wonder how we can ensure that the whole DB is
read into RAM. We hope that this will speed up some queries.
regards David
---(end of
We are suddenly getting slow queries on a particular table.
Explain shows a sequential scan. We have vacuum analyze ed
the table.
Any hints?
Many TIA!
Mark
testdb=# \d bigtable
Table public.bigtable
Column | Type | Modifiers
-+-+---
id | bigint | not null
On Wed, 2004-02-04 at 14:55, Mark Harrison wrote:
testdb=# \d bigtable
Table public.bigtable
Column | Type | Modifiers
-+-+---
id | bigint | not null
typeid | integer | not null
reposid | integer | not null
Indexes: bigtable_id_key unique