I am not sure if this is what the original poster was refering to, but I
have used an application called mtop that shows how many queries per second
mysql is doing.
In my case this is helpfull because we have a number of machines running
postfix and each incoming mail generates about 7 queries
Jonathan Blitz writes:
So, I have tried to run the following command. The command never finishes
(I gave up after about and hour and a half!).
Did you ever find what was the problem?
Perhaps you needed to run a vacuum full on the table?
---(end of broadcast)--
> I have 2 tables - one with calls numbers and another with calls codes.
> The structure almost like this:
...
How long does this query take?
SELECT code FROM a_voip_codes c, a_voip v where v.called_station_id
like c.code ||
'%' order by code desc limit 1
billing=# explain analyze SELECT code F
(Resending because my other send didn't get a CC to the list)
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Cstdenis" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 22, 2006 8:20 AM
Subject: Re: [PERFORM] How can I make this query faster (resend)
> On Fri, May 19, 2006 at 03:56:49PM -0700, Cstdenis
(re-sending because my first one forgot the CC to the list. Sorry)
I moved my database to a more powerful server. Mirrored ultra 320 SCSI HDs
and 2GB of ram. It performs much faster.
I also changed some conf settings accordingly
work_mem = 10240
shared_buffers = 25600
max_connections = 450 (Also
Hi, Daniel,
Daniel J. Luke wrote:
> One big transaction every 5 minutes using 'COPY FROM' (instead of
> inserts).
Are you using "COPY table FROM '/path/to/file'", having the file sitting
on the server, or "COPY table FROM STDIN" or psql "/copy", having the
file sitting on the client?
>From our
On 5/29/06, Anton Maksimenkov <[EMAIL PROTECTED]> wrote:
Hi.
I have 2 tables - one with calls numbers and another with calls codes.
The structure almost like this:
...
How long does this query take?
SELECT code FROM a_voip_codes c, a_voip v where v.called_station_id
like c.code ||
'%' order b
Hi.
I have 2 tables - one with calls numbers and another with calls codes.
The structure almost like this:
billing=# \d a_voip
Table "public.a_voip"
Column |Type |
Modifiers
+
