On 3 Sep 2003 at 6:08, Azlin Ghazali wrote:
> Hi,
>
> I'm working on a project to make an application run on MySQL and PostgreSQL.
> I find that PostgreSQL runs up to 10 times slower than MySQL. For small records
> it is not much problems. But as the records grew (up to 12,000 records) the
> di
Azlin Ghazali <[EMAIL PROTECTED]> writes:
> Below is the exact statement I used:
That's not very informative. Could we see the results of EXPLAIN ANALYZE
on that SELECT? Also, what PG version are you running?
regards, tom lane
---(end of broadcas
> For small records
> it is not much problems. But as the records grew (up to 12,000
> records) the
> difference is quite significant.
Although there are many tuning options, I'd suggest starting by making sure
you have an index (unique in cases where appropriate) on accposd.date
accposd.item, i
On Wed, Sep 03, 2003 at 06:08:57AM -0700, Azlin Ghazali wrote:
> I find that PostgreSQL runs up to 10 times slower than MySQL. For small records
Have you done any tuning on PostgreSQL? Have you vacuumed, &c.? All
the usual questions.
A
--
Andrew Sullivan 204-414
Hi,
I'm working on a project to make an application run on MySQL and PostgreSQL.
I find that PostgreSQL runs up to 10 times slower than MySQL. For small records
it is not much problems. But as the records grew (up to 12,000 records) the
difference is quite significant. We are talking about 15s