From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | Fernezelyi Marton <marci(at)c3(dot)hu> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] maximum of postgres ? |
Date: | 1998-06-09 14:59:51 |
Message-ID: | 357D4DE7.D823814B@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Fernezelyi Marton wrote:
>
> We would like to reach at least 15-20 query per second, 95 percent
> SELECT id FROM mail WHERE name='name' queries. The rest is SELECT pers or
> UPDATE in one of the two tables.
>
> When the number of concurrent queries is 30 or higher, the postgres
> answers very slowly, and it writes
>
> NOTICE: SIAssignBackendId: discarding tag 2147339305
> FATAL 1: Backend cache invalidation initialization failed
>
> messages to the log.
>
> If the number of concurrencies are 10, then everything goes fine, but the
> number of queries/sec are 8. Is this the maximum loadability of postgres?
I hope that both issues will be addressed in 6.4 by removing
invalidation code and skipping fsync() after each SELECT...
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Jose' Soares Da Silva | 1998-06-09 15:08:48 | Re: [GENERAL] Missing SQL Syntax & Problem with Create Table |
Previous Message | Jose' Soares Da Silva | 1998-06-09 14:42:23 | Re: [INTERFACES] M$-Access'97 and TIMESTAMPs |