I have a table, and I want to efficiently to get total count of tuples in the table, and total count of tuples with a filter.

I am using postgreSQL

I am using postgreSQL

I am using postgreSQL

Here is what I need :
I have 4 values – ‘India’,’JapaN,’UsA’ and ‘Russia’. These values are in 2 different columns ‘Country’ and ‘Geography’. I need a report of count of rows in table that has above values in any of the columns.
Example : country name No.of rows
India 5
Japan 4

Closed 26 mins ago.

I have an application that writes to a PostgreSQL database. I would like to do batch upserts of the data with INSERT ON CONFLICT DO UPDATE. The application needs to be optimized for writes for high traffic. Doing upserts would allow me to simply insert or update all data in one go.

I have an application that writes to a PostgreSQL database. I would like to do batch upserts of the data with INSERT ON CONFLICT DO UPDATE. The application needs to be optimized for writes for high traffic. Doing upserts would allow me to simply insert or update all data in one go.

Apologies for the bad wording of the question, I couldn’t think of a way to phrase it better. For instance, let’s say my schema is something like this, in pseudocode:

In PostgreSQL 16.1 I have a very large table mytable with a column _modified with type Timestamp with time zone. When I run below query on the whole table, it returns a lower timestamp value compared to when I run the query on as subset of the table.