Re: [PERFORM] Compile Vs RPMs

2004-02-04 Thread scott.marlowe
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

Re: [PERFORM] cache whole data in RAM

2004-02-04 Thread William Yu
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

[PERFORM] select is not using index?

2004-02-04 Thread Mark Harrison
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

Re: [PERFORM] select is not using index?

2004-02-04 Thread Corey Edwards
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