Re: Slow while inserting and retrieval (compared to SQL Server)

Поиск
Список
Период
Сортировка
От Peter J. Holzer
Тема Re: Slow while inserting and retrieval (compared to SQL Server)
Дата
Msg-id 20210219141118.GC10464@hjp.at
обсуждение исходный текст
Ответ на Re: Slow while inserting and retrieval (compared to SQL Server)  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
Список 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!"

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Slow index creation
Следующее
От: luis.roberto@siscobra.com.br
Дата:
Сообщение: Re: Slow while inserting and retrieval (compared to SQL Server)