Unanswered

Postgres SQL return

(0) Share

Report

Posted on by Yahooosilver

Hello Everyone,

I wanted to ask if there is a limitation on the POSTGRES SQL Connector, I have a flow that should be getting around 2000-3000 results via the Get ROWS but i am only getting 500-515 items in return. Is there a work around on how to overcome this limit?

I have tried to enable pagination but still I am getting 500 records in return.

Thanks,

Categories:

Process Advisor

All responses (7)

Answers (0)

stampcoin 2,002 on at

Like (0)

Report
Postgres SQL return

@Yahooosilver Hi,

Just wondering if your ID is the primary key ?

As default, it return 512 records, enable pagination, it will give your ceiling(threshold/512)*512.

it is called minimumItemCount(threshold). see below screen shot .

My environment:

PostgreSQL 17.

Npgsql-4.0.17.

Latest gateway.

Combination key.

see below for Get rows. I used 515, it returns 1024, I didn't specify Order By.

{ "type": "OpenApiConnection", "inputs": { "parameters": { "table": "[public].[order_lines]" }, "host": { "apiId": "/providers/Microsoft.PowerApps/apis/shared_postgresql", "connection": "shared_postgresql", "operationId": "GetItems" } }, "runAfter": { "Get_tables": [ "Succeeded" ] }, "runtimeConfiguration": { "paginationPolicy": { "minimumItemCount": 515 } } }
Yahooosilver 6 on at

Like (0)

Report

Postgres SQL return

@stampcoin Hi,

I have put in 1000 for pagination.
stampcoin 2,002 on at

Like (0)

Report

Postgres SQL return

@Yahooosilver Hi,

What is the value you specified for Pagination threshold?
Yahooosilver 6 on at

Like (0)

Report

Postgres SQL return

Hi Stampcoin,

I have added order by ID asc but still returns 513 items.
stampcoin 2,002 on at

Like (0)

Report

Postgres SQL return

@CU28051624-2 Hi,

Please try to specify value for Order by, choose one of the index column, for example ID.
Yahooosilver 6 on at

Like (0)

Report

Postgres SQL return

hello @stampcoin

I didnt use any filter. Should i use any filter to bypass the 500 limit?
stampcoin 2,002 on at

Like (0)

Report

Postgres SQL return

@CU28051624-2 Hi,

Did you use order by (on a index column )? what other options did you use ?