On 06/10/2017 07:32 PM, Alvaro Herrera wrote:
> Frits Jalvingh wrote:
>
>> So, I am still very interested in getting normal inserts faster, because
>> that will gain speed for all work.. If Oracle can do it, and Postgres is
>> able to insert fast with copy- where lies the bottleneck with the inser
Frits Jalvingh wrote:
> So, I am still very interested in getting normal inserts faster, because
> that will gain speed for all work.. If Oracle can do it, and Postgres is
> able to insert fast with copy- where lies the bottleneck with the insert
> command? There seems to be quite a performance hi
I think binary is worse.. according to the postgres documentation:
The binary format option causes all data to be stored/read as binary format
rather than as text. It is somewhat faster than the text and CSV formats,
but a binary-format file is less portable across machine architectures and
Postgr
> I tried the copy command, and that indeed works quite brilliantly:
> Inserted 2400 rows in 22004 milliseconds, 1090710.7798582076 rows per
> second
>
> That's faster than Oracle. But with a very bad interface I have to say for
> normal database work.. I will try to make this work in the tool
On Sat, Jun 10, 2017 at 12:08 AM Vladimir Sitnikov <
sitnikov.vladi...@gmail.com> wrote:
> Would you mind sharing the source code of your benchmark?
>
The source code for the several tests, plus the numbers collected so far,
can be found at:
https://etc.to/confluence/display/~admjal/PostgreSQL+p
Hi Dinesh,
Le 07/06/2017 à 14:48, Andreas Kretschmer a écrit :
Am 07.06.2017 um 13:33 schrieb Dinesh Chandra 12108:
Dear Expert,
Is there any way to rollback table data in PostgreSQL?
if you are looking for somewhat similar to flashback in oracle the
answer is no.
Well, if this is what
