python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - postgresql-14

SparkSQL query using "PARTITION by" giving wrong output

I have a bunch of csv files for which I am using Pyspark for faster processing. However, am a total noob with Spark (Pyspark). So far I have been able to create a RDD, a subsequent data frame and a te...
test-img

Pankaj

apache-spark

pyspark

apache-spark-sql

postgresql-14

Votes: 0

Answers: 0

Error: Consult the last few lines of "pg_upgrade_dump_1.log"

I wanted to ugrade my postgresql database from v10 to v14 I have run these commands in windows command prompt: C:\Users\mahajan>CD C:\Program Files\PostgreSQL\14\bin C:\Program Files\PostgreSQL\14\...
test-img

mahajan

windows

postgresql

postgresql-14

postgres-10

pg-upgrade

Votes: 0

Answers: 1

Latest Answer

Omit the cd in the beginning and stay in a directory where you have write permissions. Then pg_upgrade can write the log files that contain the actual problem. The error message that you then get is c...
test-img

Laurenz Albe

Unused index in PostgreSQL

I'm learning indexing in PostgreSQL now. I started trying to create my index and analyzing how it will affect execution time. I created some tables with such columns: also, I filled them with data. ...
test-img

Dark_Phoenix

sql

postgresql

postgresql-14

Votes: 0

Answers: 2

Latest Answer

From "Rows removed by filter: 125" I see there are too few rows in the events table. Just add couple of thousands rows and give it another go from the docs Use real data for experimentation...
test-img

ekochergin

I have an error in Postgresql building a trigger and cannot seem to find a solution

I am working in PGAdmin4, learning postgresql (yes, I am still green to this), and trying to build a trigger for a project. Everything seems to be working well until I get to the create trigger: CREAT...
test-img

Samuel Wright

postgresql-14

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs