On 11/6/20 8:20 PM, Sri Linux wrote:
Hi All,
Our production database size is about 2TB and we had run into issues and
Postgres log did recommend running the vacuum in single-user mode. We
have successfully completed running a single user mode vacuum without
any options. .. services were onlin
Adding version info
Postgres 9.4.5
Linux - rhel 7.3
Thanks
Sri
On Fri, Nov 6, 2020 at 10:20 PM Sri Linux wrote:
> Hi All,
>
> Our production database size is about 2TB and we had run into issues and
> Postgres log did recommend running the vacuum in single-user mode. We have
> successfully com
Hi All,
Our production database size is about 2TB and we had run into issues and
Postgres log did recommend running the vacuum in single-user mode. We have
successfully completed running a single user mode vacuum without any
options. .. services were online after vacuum. Application load time and
Ok, thank you.
On Fri, Nov 6, 2020 at 10:13 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Friday, November 6, 2020, Sri Linux wrote:
>
>> Thank you very much David,
>> No, vacuum activity wiht single-mode user is completed. I restarted all
>> services and the application is onli
On Friday, November 6, 2020, Sri Linux wrote:
> Thank you very much David,
> No, vacuum activity wiht single-mode user is completed. I restarted all
> services and the application is online but pretty slow.I will open a new
> case but confused about how to do a new post in the Postgres community.
Thank you very much David,
No, vacuum activity wiht single-mode user is completed. I restarted all
services and the application is online but pretty slow.I will open a new
case but confused about how to do a new post in the Postgres community.
is this common for an application to run pretty slow a
On Friday, November 6, 2020, Sri Linux wrote:
> Thank you David
>
> vacuum is done but the application is very slow, is this normal behavior?
> Will it run any background process after vacuum causing this slowness?
>
Please don’t top-post.
Are you still running under single-user?
David J.
Thank you David
vacuum is done but the application is very slow, is this normal behavior?
Will it run any background process after vacuum causing this slowness?
Thanks
Sri
On Fri, Nov 6, 2020 at 9:15 PM David G. Johnston
wrote:
>
> On Friday, November 6, 2020, Sri Linux wrote:
>
>> Added''
>>
On Friday, November 6, 2020, Sri Linux wrote:
> Added''
>
> when I log in to the Linux terminal and grep process, I can only see the
> single-user mode process running but not sure about vacuum status. I can't
> run a pg_stat commands from pgsql as the db is in single-user mode.
>
> ps -ef|grep
Added''
when I log in to the Linux terminal and grep process, I can only see the
single-user mode process running but not sure about vacuum status. I can't
run a pg_stat commands from pgsql as the db is in single-user mode.
ps -ef|grep -i sql
root 25412 15199 0 14:59 pts/100:00:00 su po
Hi All
How can I monitor and make sure that the vacuum is still running if I get
lost with the session to Linux putty? I would need to check if the
vacuum is still running from Linux OS.
Please advise.
Regards
Sri
On Fri, Nov 6, 2020 at 2:34 PM Sri Linux wrote:
> Could you please provide me the link to start new questions?
>
>>
>>>
Assuming you are using Gmail...
https://business.tutsplus.com/tutorials/how-to-compose-and-send-your-first-email-with-gmail--cms-27678
David J.
David
Could you please provide me the link to start new questions?
Thanks and Regards
Sri
On Fri, Nov 6, 2020 at 3:27 PM Sri Linux wrote:
> Thank you very much David
>
>
>
> On Fri, Nov 6, 2020 at 2:11 PM David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> On Friday, November 6, 2020
Thank you very much David
On Fri, Nov 6, 2020 at 2:11 PM David G. Johnston
wrote:
> On Friday, November 6, 2020, Sri Linux wrote:
>
>> Hi All
>>
>> I have to start Postgres 9.4.5 vacuum for our production environment. Got
>> interrupted with the Linux session, is there a way I can monitor if
On Friday, November 6, 2020, Sri Linux wrote:
> Hi All
>
> I have to start Postgres 9.4.5 vacuum for our production environment. Got
> interrupted with the Linux session, is there a way I can monitor if the
> vacuum is progressing while I reconnect to the Linux box?
>
>>
>>>
Please start new emai
Hi All
I have to start Postgres 9.4.5 vacuum for our production environment. Got
interrupted with the Linux session, is there a way I can monitor if the
vacuum is progressing while I reconnect to the Linux box?
Thanks
Sri
On Thu, Jun 25, 2020 at 1:16 PM Sri Linux wrote:
> Thanks for your suppo
On 11/6/20 8:12 AM, Gabi Draghici wrote:
It't not a daemon yet (I started manually) but yes, it's running :
postgres@dbdocs:~> ps aux | grep postgresql
postgres 2093 0.0 0.3 8720088 218280 ? Ss 17:54 0:00
/usr/lib/postgresql12/bin/postgres -D /opt/postgresql/database
postgres 2315
It't not a daemon yet (I started manually) but yes, it's running :
postgres@dbdocs:~> ps aux | grep postgresql
postgres 2093 0.0 0.3 8720088 218280 ? Ss 17:54 0:00
/usr/lib/postgresql12/bin/postgres -D /opt/postgresql/database
postgres 2315 0.0 0.0 64664 5708 pts/2S17:57
On 11/6/20 4:26 AM, Gabi Draghici wrote:
Hi,
1. The job it's a simple call to one stored function like that :
BEGIN
CALL other_user_name.get_function();
END;
Problem is that despite the fact that it's long passed by the scheduled
running time and I tried the "Run now" option (from pgadmin) a
Hi,
1. The job it's a simple call to one stored function like that :
BEGIN
CALL other_user_name.get_function();
END;
Problem is that despite the fact that it's long passed by the scheduled
running time and I tried the "Run now" option (from pgadmin) a couple of
times, there is no evidence that th
On 06-11-2020 10:08, Magnus Hagander wrote:
On Fri, Nov 6, 2020 at 10:00 AM Java Developer wrote:
Hello,
I am trying to query a column from a table I migrated from my MYSQL
into POSTGRESQL but I seem to be having issues with a few column names.
the column name cast is also an operator, I thin
On Fri, Nov 6, 2020 at 10:00 AM Java Developer wrote:
>
> Hello,
>
> I am trying to query a column from a table I migrated from my MYSQL
> into POSTGRESQL but I seem to be having issues with a few column names.
>
> the column name cast is also an operator, I think zone may also be a
> problem.
>
>
Hello,
I am trying to query a column from a table I migrated from my MYSQL
into POSTGRESQL but I seem to be having issues with a few column names.
the column name cast is also an operator, I think zone may also be a
problem.
MYSQL: OK
SELECT id, start_date, local_time, country, city, region, tem
On Thu, 2020-11-05 at 19:03 +, Dmitry O Litvintsev wrote:
> I have a workflow where I recover from PITR backup and run a query on it. The
> program that runs query
> checks that it can connect to database in a loop, until it can, and then runs
> the query.
> This has worked fine far. Recent
24 matches
Mail list logo
