SELECT Query taking time WITH Sequence

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: SELECT Query taking time WITH Sequence
From: Daulat <daulat.dba@xxxxxxxxx>
Date: Wed, 12 Mar 2025 22:35:35 +0530

Hi Team,

The SELECT query takes around 4 minutes to complete when fetching data from the tables using a sequence, but without the sequence, the same query takes only a few seconds."

Anyone please help me with what I need to take care of.

Thanks,

Follow-Ups:
- Re: SELECT Query taking time WITH Sequence
  - From: David G. Johnston
- Re: SELECT Query taking time WITH Sequence
  - From: Laurenz Albe

Prev by Date: Re: People obsessed with docker - how can I help?
Next by Date: Re: SELECT Query taking time WITH Sequence
Previous by thread: On-disk postgres database size too large
Next by thread: Re: SELECT Query taking time WITH Sequence
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux