Dear All,
As I solution, I wanted to start to build Postgres from source by myself, in
order to better managed what it is finally included.
So I wanted to compile on Windows with Visual Studio.
However, in the page
https://www.postgresql.org/docs/current/install-windows.html, I can see:
" I
On Thu, Apr 29, 2021 at 10:35 AM DAVID Nicolas
wrote:
>
> Dear All,
>
> As I solution, I wanted to start to build Postgres from source by myself, in
> order to better managed what it is finally included.
> So I wanted to compile on Windows with Visual Studio.
>
> However, in the page
> https://w
Hi Ludovico,
> Sorry for this reply, but I feel it is necessary to make it clear what is
> reality and what is FUD against Oracle from Paul's e-mails in this thread...
nothing of it was a FUD. It was a comparison done on a single machine. Then, I
drew my conclusions from that and added my perso
I may be off-topic as I've only worked occasionally with ORA but still know
it good enough.
What I miss most of the Oracle DB in PostgreSQL is the elaborate system of
object security and granting permissions which exists in Oracle DB.
What I like most about the Postgres DB is that lots of plugins/e
Without knowledge of the structure of your data, or even real table/field
names to be able to read the query with some sense of what the tables might
be like, offering advice is rather difficult. I didn't notice any nodes
with huge estimation problems at least.
I will suggest that DISTINCT is ofte
On Thu, 29 Apr 2021 at 21:02, Ayub M wrote:
>
> In the below execution plan, the index scan on five_lima (table has 900m
> records) is where it's spending most of its time. I want to bring down the
> runtime to a few seconds, how do I optimize it? Tried forcing seq scan and
> ran vacuum/analyze
