PostgreSQL

02 March 2025 19:20

You saw this message, and it got you curious. Guess what? Your target audience will see your project too. Let’s pump up your shilling and throw in some sweet extras.

PostgreSQL

01 March 2025 16:51

Ok, thanx for answer, will look further

PostgreSQL

01 March 2025 16:37

Do not want self hosted one too :(

PostgreSQL

01 March 2025 16:36

Are their paid tiers good too? Saw neon, it easy to set

PostgreSQL

01 March 2025 16:20

I would not buy general purpose computing on Amazon. Makes no sense compared to providers like Hetzner where you can get much better performance for a better and more predictable price

PostgreSQL

01 March 2025 14:53

Can someone recomend good cloud service hosting postgres? For personal project.

PostgreSQL

01 March 2025 14:34

There was a python extension for that in postgresql but couldnt remembered the name.

PostgreSQL

28 February 2025 11:01

Hai everyone am new to this group and learning sql via postgresql...

Some one please share any datasets, questions and answer for handson experience

PostgreSQL

28 February 2025 07:32

hello, why BETWEEN operator is incredibly slow when using current date, when using between ‘2025-02-28’ and ‘2025-02-28’, db is dying, buffer mapping, buffer io waiting etc issues
but when change query to =‘2025-02-28’ its starts using index and everything is perfectly ok, any explanation about that?

PostgreSQL

26 February 2025 19:39

You may want to post some of your "doubts" first, and in what area you are looking for expertise. It's a broad field ...

PostgreSQL

26 February 2025 17:02

Anyone from Sybase background?

PostgreSQL

26 February 2025 14:09

I have a few doubts about PostgreSQL.
Could anyone who is an expert in (Telugu person ) please help me?
I am understand in easy way and comfortable to him to ask my doubts
I am willing to pay for your efforts.
Please ping me in a separate chat.

PostgreSQL

25 February 2025 14:48

Long answer: it depends on the kind of data, the difference might be negligible or a lot depending on various conditions. I assume DISTINCT will try to use indexes as much as possible, while row_number being a window function will work on a "rendered" result set

PostgreSQL

24 February 2025 11:28

Ok thanks @NickBluth

PostgreSQL

24 February 2025 10:24

Does anyone know about this? I also want to know please reply

PostgreSQL

01 March 2025 17:47

Any possibility if we can get postgres books for less cost from packetpub.com

PostgreSQL

01 March 2025 16:50

No idea, I don't use managed services at work but played around free tier to see how easy it is to get started.

PostgreSQL

01 March 2025 16:37

Yeah, we work with aws at work, do not realy prefer it

PostgreSQL

01 March 2025 16:35

Supabase or Neon, both are with free tiers and managed postgres.

PostgreSQL

01 March 2025 15:42

AWS cloud services like Rds, Aurora and Ec2 are good for hosting postgres as compared to Azure and Google and it gives "freetier" for 750* hrs valid for 12 months

PostgreSQL

01 March 2025 14:42

Tq for your response. Found One extension system_stats

PostgreSQL

28 February 2025 18:31

Is there any extension to check or track the memory usage for postgres

PostgreSQL

28 February 2025 08:14

Obviously, the DB uses a full table scan in your case. As using BETWEEN is generally discouraged, I assume there's not a lot of micro optimizations going into it 🤷

PostgreSQL

27 February 2025 13:18

Which is the best hosting provider with postgres sql support, any guidance in this regards will really be helpful ?
I already have hostinger web space but now it has started giving problems. Like down time and slow access

PostgreSQL

26 February 2025 18:57

I have a few doubts about PostgreSQL.
Could anyone who is an expert ,please help me?

I am willing to pay for your efforts.
Please ping me in a separate chat.

PostgreSQL

26 February 2025 16:32

Ping me personally I am a telugu guy and I can help you

PostgreSQL

25 February 2025 14:56

I've tried just now using DISTINCT and ROW_NUMBER on my database, to select a number of unique IDs from a random table (Table size 816MB, Number of rows 16407327)

DISTINCT -> 0.176s
ROW_NUMBER -> 8.345s

PostgreSQL

25 February 2025 14:42

Distinct on vs row_number

PostgreSQL

24 February 2025 10:50

The question is a bit odd, tbh. The security is the same as for any other connection. It is configured in pg_hba.conf (special database replication) and on role level (REPLICATION property). You *could* make your replication terribly insecure (no TLS, trust authentication, shared role, ...), but you wouldn't.

PostgreSQL

24 February 2025 09:12

It's really just that.. of course you can do it in "postgres", but then you have to make sure you "closed all other doors". Having a dedicated DB means there *are* no other doors to worry about. 🤷