Re: SELECT Query taking time WITH Sequence

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

 



On Wed, 2025-03-12 at 22:35 +0530, Daulat wrote:
> 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.

Start with a useful problem report.

You cannot access a table using a sequence.  Perhaps you are talking about a sequential scan.
What is the table definition, the query and its EXPLAIN (ANALYZE, BUFFERS) output?

Yours,
Laurenz Albe






[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