On 01/-10/-28163 11:59 AM, afancy wrote:
> Hi,
>
> My PostgreSQL server has two CPUs (OS: Fedora 11), each with 4 cores.
> Total is 8cores. Now I have several clients running at the same time
> to do insert and update on the same table, each client having its own
> connection. I have made two te
Hi,
I am using the PostgreSQL 8.4. What is the code path? After a row is
inserted to the table, it will update the fields of "validfrom", and
"validto". Followings are the table structure, data, and the performance
data:
xiliu=# \d page
Table "pyetlexa.page"
Column |
afancy writes:
> My PostgreSQL server has two CPUs (OS: Fedora 11), each with 4 cores. Total
> is 8cores. Now I have several clients running at the same time to do insert
> and update on the same table, each client having its own connection. I have
> made two testing with clients running in pa
Hi,
My PostgreSQL server has two CPUs (OS: Fedora 11), each with 4 cores. Total
is 8cores. Now I have several clients running at the same time to do insert
and update on the same table, each client having its own connection. I have
made two testing with clients running in parallel to load 20M