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
