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
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
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
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
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
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)---
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
> 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
