| From: | Michael Nolan <htfoot(at)gmail(dot)com> |
|---|---|
| To: | Julie Nishimura <juliezain(at)hotmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: constantly updated table in Amazon RDS |
| Date: | 2022-10-21 19:08:46 |
| Message-ID: | CAOzAquJ8DdQP-CeTJ_gM6wLeCzu9CYVNEFvpHoDq8CVgTk+etA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Oct 21, 2022 at 1:52 PM Julie Nishimura <juliezain(at)hotmail(dot)com>
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 or timestamp
field that is included in new records? Otherwise, how do you know when
they were inserted?
A query has a temporarily stable (or consistent) database, inserts, deletes
or updates that occur during the processing of that query (or its
transaction block, if applicable) are ignored. I'm not sure if that
answers your question.
--
Mike Nolan
htfoot(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Les | 2022-10-21 19:11:09 | Re: possible bug |
| Previous Message | Tom Lane | 2022-10-21 19:05:31 | Re: possible bug |