Re: Slow while inserting and retrieval (compared to SQL Server) - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Slow while inserting and retrieval (compared to SQL Server)
Date
Msg-id 20210219141118.GC10464@hjp.at
Whole thread Raw
In response to Re: Slow while inserting and retrieval (compared to SQL Server)  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
List pgsql-general
On 2021-02-17 12:54:18 +0000, sivapostgres@yahoo.com wrote:
> Yes, that's what I feel.  With no records in any tables, working from the same
> machine where PG has been installed, with only one user working, inserting few
> records (10 records in total, in all 6 tables)  should not take this much
> time.

How much time is "this much time"? Are we talking a few milliseconds
here? Less? More? Much more?

It's hard to give advice if you don't tell us more than "slower than SQL
server". Please be specific. Use actual numbers.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Slow index creation
Next
From: luis.roberto@siscobra.com.br
Date:
Subject: Re: Slow while inserting and retrieval (compared to SQL Server)