May I ask the proper (fast) way of inserting bulk data and if possible, an
example would be very appreciated.
Please note that the data I would like to insert contains arrays (float8[]).
By the way, my environment is Windows 10, PostgreSQL 11 and compiling with
Visual Studio 2017.
That wo
May I ask the proper (fast) way of inserting bulk data and if possible, an
example would be very appreciated.
Please note that the data I would like to insert contains arrays (float8[]).
By the way, my environment is Windows 10, PostgreSQL 11 and compiling with
Visual Studio 2017.
That would
on a CentOS 7.5 machine with PostgreSQL 10.3 installed from the PGDG yum repo,
I have a strange error when trying to update to 10.6.
A simple "yum update" updated everything except postgresql10-server.x86_64!
That package gives (repeatedly) the error message:
Error unpacking rpm package postgre
We're kind of pulling out our hair here, any ideas?
You might try issuing the command
analyze;
right *before* the command that hangs.
Clarification: I meant to say: "put it into the script at the location right before
the command, that hangs".
Bye,
Chris.
We're kind of pulling out our hair here, any ideas?
You might try issuing the command
analyze;
right *before* the command that hangs.
The rationale behind this idea is that your script changed data
and the "hung" command uses a wrong plan based on outdated statistics.
By the time you run
Hi,
on a CentOS 7.5 machine with PostgreSQL 10.3 installed from the PGDG yum repo,
I have a strange error when trying to update to 10.6.
A simple "yum update" updated everything except postgresql10-server.x86_64!
That package gives (repeatedly) the error message:
Error unpacking rpm package po
centos 7 :
Time: 3.884 ms
centos 6.9
Time: 1.620 ms
Is there anything you can advice to solve or identify the problem?
Can you run this query 10 times on each server and note the timings?
I'd like to see the reproducability of this.
Also: both machines are otherwise idle (check with top o
I need to search for big differences between values.
[...]
Hi,
from an SQL point of view this is not difficult, but you need to
carefully define a criteria for the outliers.
For example, to find values that are more than a standard deviation
away from the mean, do something like this:
chris=#
