Hello,
Is there a view in database to find sessions PID of dropped user in
database?
Thanks,
Vishal
I dropped a connected user in database, cannot find pid in
pg_stat_activity. I can query from dropped user session but how to find
session in database without going into OS.
On Fri, 30 Nov 2018 at 5:08 PM, Vishal Kohli
wrote:
> Hello,
>
> Is there a view in database to find sessions PID of dropp
On 28/11/2018 22:49, Stephen Frost wrote:
* Chris Withers (ch...@withers.org) wrote:
We have an app that deals with a lot of queries, and we've been slowly
seeing performance issues emerge. We take a lot of free form queries from
users and stumbled upon a very surprising optimisation.
So, we ha
Greetings,
On Fri, Nov 30, 2018 at 07:52 Chris Withers wrote:
> On 28/11/2018 22:49, Stephen Frost wrote:
> > * Chris Withers (ch...@withers.org) wrote:
> >> We have an app that deals with a lot of queries, and we've been slowly
> >> seeing performance issues emerge. We take a lot of free form q
On 30/11/2018 12:55, Stephen Frost wrote:
> I'd suggest you check out the wiki article written about this kind of
> question:
>
> https://wiki.postgresql.org/wiki/Slow_Query_Questions
Have you tried a partial index on state!=‘RSV’?
The solution I originally posted, that we
Greetings,
On Fri, Nov 30, 2018 at 08:00 Chris Withers wrote:
> On 30/11/2018 12:55, Stephen Frost wrote:
> > > I'd suggest you check out the wiki article written about this
> kind of
> > > question:
> > >
> > > https://wiki.postgresql.org/wiki/Slow_Query_Questions
> >
> >
>
Hi All,
With reference to an old thread
(https://www.postgresql.org/message-id/8307.1419439826%40sss.pgh.pa.us), our
application polls the database instance periodically to check if there are new
transaction in the WAL waiting to be processed. As a consequence of this, our
log file is full of
Greetings,
* Chris Withers (ch...@withers.org) wrote:
> On 28/11/2018 22:49, Stephen Frost wrote:
> >* Chris Withers (ch...@withers.org) wrote:
> >>We have an app that deals with a lot of queries, and we've been slowly
> >>seeing performance issues emerge. We take a lot of free form queries from
>
We have a long script of sql that we run, several thousand lines of sql. If
I execute the script from start to finish, somewhere in the middle of it,
one sql command will hang and take 2 to 3 hours. During this time, "htop"
shows 100% cpu usage with a postgresql process, so it appears to be doing
s
On 11/30/18 7:53 AM, John Smith wrote:
We have a long script of sql that we run, several thousand lines of sql.
If I execute the script from start to finish, somewhere in the middle of
it, one sql command will hang and take 2 to 3 hours. During this time,
"htop" shows 100% cpu usage with a post
We're kind of pulling out our hair here, any ideas?
You might try issuing the command
analyze;
right *before* the command that hangs.
The rationale behind this idea is that your script changed data
and the "hung" command uses a wrong plan based on outdated statistics.
By the time you run
We're kind of pulling out our hair here, any ideas?
You might try issuing the command
analyze;
right *before* the command that hangs.
Clarification: I meant to say: "put it into the script at the location right before
the command, that hangs".
Bye,
Chris.
On 11/30/2018 09:53 AM, John Smith wrote:
We have a long script of sql that we run, several thousand lines of sql.
If I execute the script from start to finish, somewhere in the middle of
it, one sql command will hang and take 2 to 3 hours. During this time,
"htop" shows 100% cpu usage with a p
On Fri, Nov 30, 2018 at 8:05 AM Chris Mair wrote:
>
> > We're kind of pulling out our hair here, any ideas?
>
> You might try issuing the command
>
>analyze;
>
> right *before* the command that hangs.
>
>
You might consider trying the "auto_explain" module (
https://www.postgresql.org/docs/cu
Ron writes:
> We have a seemingly identical problem in v9.6 on our big prod databases. It
> worked perfectly in 8.4 *and works perfectly in 9.6 our small staging
> servers*.
> A giant sql script that drops the oldest child tables from a large set of
> partitioned tables (by dropping all releva
On 11/30/2018 10:38 AM, Tom Lane wrote:
Ron writes:
We have a seemingly identical problem in v9.6 on our big prod databases. It
worked perfectly in 8.4 *and works perfectly in 9.6 our small staging servers*.
A giant sql script that drops the oldest child tables from a large set of
partitioned
On Fri, 30 Nov 2018 at 15:53, John Smith wrote:
> We have a long script of sql that we run, several thousand lines of sql. If I
> execute the script
> from start to finish, somewhere in the middle of it, one sql command will
> hang and take 2 to
> 3 hours. During this time, "htop" shows 100% cpu
Hi,
I have postgresql 9.4 with postgis extension installed (latest version,
2.4.5). I upgraded postgresql from 9.4 to 9.6.
After upgrading to 9.6 I get the following result
from PostGIS_full_version()
select PostGIS_full_version();
postgis_full_version
If you install the new version, and then use ‘ALTER EXTENSION UPDATE’ to update
the SQL-side bindings, everything should improve.
> On Nov 30, 2018, at 5:11 AM, Slavcho Trnkovski wrote:
>
> Hi,
>
> I have postgresql 9.4 with postgis extension installed (latest version,
> 2.4.5). I upgraded po
Thanks Chris and Steve for the analyze suggestion; That will be my next
test!
On Fri, Nov 30, 2018 at 11:27 AM Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
>
>
> On Fri, Nov 30, 2018 at 8:05 AM Chris Mair wrote:
>
>>
>> > We're kind of pulling out our hair here, any ideas?
>>
>> You m
Hello There,
We have postgres 9.6 with 3 slaves replicated in synchronous commit.
we recently migrated to to another cloud provider. Though we have the
same configuration for VMs and postgres, we are experiencing systemwide
slowness with writes to database.
I am more concerned about a scheduled
Have you benchmarked the new infrastructure's IO and network performance?
why did you switch providers? was it because of cost?
On 11/30/18 1:53 PM, Rene Romero Benavides wrote:
Have you benchmarked the new infrastructure's IO and network
performance? why did you switch providers? was it because of cost?
And have you proven to yourself that all the indices are in place, stats
are up-to-date? You didn't by any chance mi
On 11/29/18 7:31 AM, Adrian Klaver wrote:
Postgres 10.6
I am getting different output using:
pg_dump -d production -U postgres -s -t container -f cont.sql
vs
pg_restore -s -t container -f container.sql production_112818.out
In the docs:
https://www.postgresql.org/docs/10/app-pgrestore.
On 01/12/2018 04:33, Stephen Frost wrote:
Greetings,
* Chris Withers (ch...@withers.org) wrote:
On 28/11/2018 22:49, Stephen Frost wrote:
* Chris Withers (ch...@withers.org) wrote:
We have an app that deals with a lot of queries, and we've been slowly
seeing performance issues emerge. We take
25 matches
Mail list logo