Hi,
> On 15. Dec, 2020, at 18:37, Ron wrote:
>
> On 12/15/20 11:26 AM, Laurenz Albe wrote:
>> On Tue, 2020-12-15 at 10:00 -0600, Ron wrote:
After abrupt shutdown of Windows, we are seeing the pg_ctl.exe file
getting deleted automatically.
>>> Only pg_ctl.exe gets deleted? Anyway,
On 12/15/20 11:26 AM, Laurenz Albe wrote:
On Tue, 2020-12-15 at 10:00 -0600, Ron wrote:
After abrupt shutdown of Windows, we are seeing the pg_ctl.exe file getting
deleted automatically.
Only pg_ctl.exe gets deleted? Anyway, there's nothing in Postgres that says "delete pg_ctl.exe on
On Tue, 2020-12-15 at 10:00 -0600, Ron wrote:
> > After abrupt shutdown of Windows, we are seeing the pg_ctl.exe file getting
> > deleted automatically.
>
> Only pg_ctl.exe gets deleted? Anyway, there's nothing in Postgres that says
> "delete pg_ctl.exe on startup".
> This smells strongly of
for an RDS Aurora PostgreSQL v11.7 database I want to setup DDL and
truncate and delete auditing.
I am setting log_statement to DDL, to log all DDLs (this excludes truncate
statements). I also want to setup auditing only for deletes and truncates
on tables. I don't want to set log_statement to
On 12/15/20 4:44 AM, Joel Mariadasan (jomariad) wrote:
Team,
After abrupt shutdown of Windows, we are seeing the pg_ctl.exe file
getting deleted automatically.
Maybe English is your second language, but "we are seeing" means that
Windows regularly shuts down, and deletes pg_ctl.exe every
On 12/15/20 2:44 AM, Joel Mariadasan (jomariad) wrote:
Team,
After abrupt shutdown of Windows, we are seeing the pg_ctl.exe file
getting deleted automatically.
Due to this Postgres service cannot be started and need to be re-installed.
We have checked the antivirus and confirmed that it
On 12/15/20 8:17 AM, Yambu wrote:
Hi
How would you optimize a query with greater than in where clause eg
select * from table1 where id > 1000
and there is an index on id column
The question as written is unanswerable.
- Why do you think it needs to be optimized?
- What is the table
Hi Yambu, the btree index type is optimized for this kind of operators (>,
>=, <, <=, =).
For deep understanding on how to plan an query optimization I would
recommend https://classroom.google.com/c/MTQ4MzczNDExMjM4 and
https://use-the-index-luke.com.
Another tip is use in the select clause only
Hi
How would you optimize a query with greater than in where clause eg
select * from table1 where id > 1000
and there is an index on id column
regards
Team,
After abrupt shutdown of Windows, we are seeing the pg_ctl.exe file getting
deleted automatically.
Due to this Postgres service cannot be started and need to be re-installed.
We have checked the antivirus and confirmed that it didn't delete the file.
Can you let us know if anyone has
10 matches
Mail list logo
