Ivan Voras wrote:
> Hi,
>
> Assuming two or more clients issue INSERTs and COPYs on the same table
> in the database at the same time, does PostgreSQL execute them in
> parallel (i.e. no table-level locks, etc.) assuming there are no indexes
> and constrains on the table? What about when there
Hi,
Assuming two or more clients issue INSERTs and COPYs on the same table
in the database at the same time, does PostgreSQL execute them in
parallel (i.e. no table-level locks, etc.) assuming there are no indexes
and constrains on the table? What about when there are indexes and/or
constrain
On Mon, 4 Feb 2008 15:09:58 -0500 (EST)
Greg Smith <[EMAIL PROTECTED]> wrote:
> On Mon, 4 Feb 2008, Simon Riggs wrote:
>
> > Would anybody like to repeat these tests with the latest production
> > versions of these databases (i.e. with PGSQL 8.3)
>
> Do you have any suggestions on how people sho
On Mon, 04 Feb 2008 17:33:34 -0500
"Jignesh K. Shah" <[EMAIL PROTECTED]> wrote:
> Hi Simon,
>
> I have some insight into TPC-H on how it works.
>
> First of all I think it is a violation of TPC rules to publish numbers
> without auditing them first. So even if I do the test to show the
> bett
Hi all,
When I'm doing an explain analyze to a query of mine I notice that the
number of estimated rows by the planner is a lot smaller then the actual
number of rows, I'm afraid that this make my queries slower.
A query for example is:
EXPLAIN ANALYZE
SELECT product_id,product_name
FROM product
