Re: constantly updated table in Amazon RDS

2022-10-21 Thread Julie Nishimura
Thank you all From: Laurenz Albe Sent: Friday, October 21, 2022 8:56 PM To: Julie Nishimura ; pgsql-gene...@postgresql.org Subject: Re: constantly updated table in Amazon RDS On Fri, 2022-10-21 at 18:51 +, Julie Nishimura wrote: > A table is constan

Re: constantly updated table in Amazon RDS

2022-10-21 Thread Laurenz Albe
On Fri, 2022-10-21 at 18:51 +, Julie Nishimura wrote: > A table is constantly updated by inserting new rows. Will it affect select if > where clause is based on > date? > Does "where clause" to specify > date and < now? Potentially yes, if the rows you query are the most recent rows, for whic

Re: constantly updated table in Amazon RDS

2022-10-21 Thread Michael Nolan
On Fri, Oct 21, 2022 at 1:52 PM Julie Nishimura wrote: > Hello, > A table is constantly updated by inserting new rows. Will it affect select > if where clause is based on > date? > Does "where clause" to specify > date and < now? > You haven't described the table. Is there some kind of a date o

constantly updated table in Amazon RDS

2022-10-21 Thread Julie Nishimura
Hello, A table is constantly updated by inserting new rows. Will it affect select if where clause is based on > date? Does "where clause" to specify > date and < now? Thanks!