public inbox for [email protected]  

help / color / mirror / Atom feed

Re: Re. Select with where condition times out
2+ messages / 2 participants
[nested] [flat]

* Re: Re. Select with where condition times out
@ 2024-07-20 19:21 Michael Nolan <[email protected]>
  2024-07-22 04:46 ` Re: Re. Select with where condition times out [email protected] <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Michael Nolan @ 2024-07-20 19:21 UTC (permalink / raw)
  To: [email protected] <[email protected]>; +Cc: Postgresql General Group <[email protected]>

On Thu, Jul 18, 2024 at 4:38 AM [email protected]
<[email protected]> wrote:
>
> Hello,
> PG V11
>
> Select count(*) from table1
> Returns 10456432
>
> Select field1, field2 from table1 where field3> '2024-07-18 12:00:00'
> Times out
>
> The above query was working fine for the past 2 years.
>
> Backup was taken a day back.  Need to recover complete data as far as possible.
>
> Any possible way(s) to do this?
>
> BKR Sivaprakash
>

If you do a full backup, does it complete in a normal manner and the usual time?

Have you tried doing a shutdown and restart of the database, or
possibly rebooting the server?

You may need to alter the database server settings to increase the
maximum query time.

Mike Nolan
[email protected]






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Re. Select with where condition times out
  2024-07-20 19:21 Re: Re. Select with where condition times out Michael Nolan <[email protected]>
@ 2024-07-22 04:46 ` [email protected] <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: [email protected] @ 2024-07-22 04:46 UTC (permalink / raw)
  To: Michael Nolan <[email protected]>; +Cc: Postgresql General Group <[email protected]>

 

    On Sunday, 21 July, 2024 at 12:52:22 am IST, Michael Nolan <[email protected]> wrote:  
 
 On Thu, Jul 18, 2024 at 4:38 AM [email protected]
<[email protected]> wrote:
>
> Hello,
> PG V11
>
> Select count(*) from table1
> Returns 10456432
>
> Select field1, field2 from table1 where field3> '2024-07-18 12:00:00'
> Times out
>
> The above query was working fine for the past 2 years.
>
> Backup was taken a day back.  Need to recover complete data as far as possible.
>
> Any possible way(s) to do this?
>
> BKR Sivaprakash
>

If you do a full backup, does it complete in a normal manner and the usual time?

Have you tried doing a shutdown and restart of the database, or
possibly rebooting the server?

You may need to alter the database server settings to increase the
maximum query time.

Mike Nolan
[email protected]

1.  Full backup taken without any issue.  Checked it by restoring as another database in the same server.  No Issues.
2.  PG Service stopped and re-started.    Re-booted the server also.  Same issue.
3.  PG is working with default settings only, that's set during installation time.  
When the query was run in the restored database, in the same server machine, the query executed in a second.  The same query, in original database, takes more than 15 min.  
BKR Sivaprakash
  

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-07-22 04:46 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-07-20 19:21 Re: Re. Select with where condition times out Michael Nolan <[email protected]>
2024-07-22 04:46 ` [email protected] <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox