> Seriously, I am tired of this kind of question. You gotta get bold
> enough to stand up in a "meeting" like that, say "guy's, you can ask me
> how this compares to Oracle ... but if you're seriously asking me how
> this compares to MySQL, call me again when you've done your homework".
Can the
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 b
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 broadcast)---
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 n
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
I've done some testing of 7.3.4 vs 7.4.1 and found 7.4.1 to be 20%-30%
slower than 7.3.4. Is this common knowledge or am I just unlucky with
my query/data selection?
Things of note that might matter: the machine is a dual Opteron 1.4GHz
running Fedora Core 1 Test 1 for X86_64. The 7.3.4 was from
Orion,
> I've done some testing of 7.3.4 vs 7.4.1 and found 7.4.1 to be 20%-30%
> slower than 7.3.4. Is this common knowledge or am I just unlucky with
> my query/data selection?
No, it's not common knowledge. It should be the other way around. Perhaps
it's the queries you picked? Even so
Oops! [EMAIL PROTECTED] (Orion Henry) was seen spray-painting on a wall:
> I've done some testing of 7.3.4 vs 7.4.1 and found 7.4.1 to be 20%-30%
> slower than 7.3.4. Is this common knowledge or am I just unlucky with
> my query/data selection?
That seems unusual; the opposite seems more typical
