Michael Paquier writes:
> On Thu, Mar 22, 2018 at 06:55:12PM -0400, Tom Lane wrote:
>> Anyway, it's clearly not very nice that postgres_fdw makes no attempt
>> to do a graceful shutdown of its remote connection. I don't know that
>> this rises to the level of a bug, exactly, but if somebody wante
On Thu, Mar 22, 2018 at 06:55:12PM -0400, Tom Lane wrote:
> Anyway, it's clearly not very nice that postgres_fdw makes no attempt
> to do a graceful shutdown of its remote connection. I don't know that
> this rises to the level of a bug, exactly, but if somebody wanted to
> send in a patch it'd pr
On Thu, Mar 22, 2018 at 2:24 PM, Jeremy Finzel wrote:
> I am running this on a san snapshot of our production system. I assume that
> this will give me a valid check for file-system-level corruption. I am
> going to kick it off and see if I find anything interesting.
It might. Note that SAN sna
On 03/21/2018 03:08 PM, Adrian Klaver wrote:
On 03/21/2018 01:59 PM, Stuart McGraw wrote:
On 03/21/2018 02:37 PM, Rob Sargent wrote:
Thanks, I forgot that the older repos also received the pg-10 update.
Unfortunately but no luck with Xenial either, slightly different
but similar conflicts.
My
Albrecht =?iso-8859-1?b?RHJl3w==?= writes:
> No messages are printed whilst the session is open. However, when I quit the
> session by typing “\q” /after/ entering the command above, the LOG message
> appears. It does not appear when I query tables from my_db exclusively,
> though, i.e. when
Thanks Tomas. We're currently building postgres from source. In order to
enable symbols, you want me to re-configure postres with --enable-debug
then run perf?
Regards,
On Thu, Mar 22, 2018 at 5:00 PM, Tomas Vondra
wrote:
>
>
> On 03/22/2018 11:33 AM, Alessandro Aste wrote:
> > Tomas, thank yo
On 03/22/2018 11:29 PM, Alessandro Aste wrote:
> Thanks Tomas. We're currently building postgres from source. In order to
> enable symbols, you want me to re-configure postres with --enable-debug
> then run perf?
>
Yes.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
Postg
On Thu, Mar 22, 2018 at 3:20 PM, Peter Geoghegan wrote:
> On Thu, Mar 22, 2018 at 12:27 PM, Jeremy Finzel wrote:
> > Thank you for the recommendation. I ran both amcheck functions on all 4
> > indexes of those 2 tables with heapallindexed = true, but no issues were
> > found.
>
> Probably would
On Thu, Mar 22, 2018 at 12:27 PM, Jeremy Finzel wrote:
> Thank you for the recommendation. I ran both amcheck functions on all 4
> indexes of those 2 tables with heapallindexed = true, but no issues were
> found.
Probably wouldn't hurt to run it against all indexes, if you can make
time for that
I admit I'm pretty surprised by this whole episode. I have no useful
advice to offer here.
--
Álvaro Herrerahttps://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
On Wed, Mar 21, 2018 at 4:29 PM, Peter Geoghegan wrote:
> On Wed, Mar 21, 2018 at 1:38 PM, Jeremy Finzel wrote:
> > A server restart and upgrade to 9.5.12 (at the same time), as expected,
> made
> > the issue go away. Still doesn't give us any answers as to what
> happened or
> > if it would ha
On 03/22/2018 11:08 AM, Albrecht Dreß wrote:
Hi Adrian:
Am 21.03.18 19:25 schrieb(en) Adrian Klaver:
Does it also happen when you open a psql session and do?:
psql>select * from ext_table limit 1;
No messages are printed whilst the session is open. However, when I
quit the session by typin
Hi Adrian:
Am 21.03.18 19:25 schrieb(en) Adrian Klaver:
Does it also happen when you open a psql session and do?:
psql>select * from ext_table limit 1;
No messages are printed whilst the session is open. However, when I quit the
session by typing “\q” /after/ entering the command above, the
On 03/22/2018 11:33 AM, Alessandro Aste wrote:
> Tomas, thank you. This machine is abare metal server running only a
> staging postgresql 10.3 instance. Nobody is using it beside me.
>
> I'm attaching 4 files.
>
> every_30_seconds_top_stats_during_query.txt - this is a caputure of
> the
The "Free" version doesn't do much. Just lets you connect to a DB,
create/edit and execute SQL.
oh hum.
On Thu, Mar 22, 2018 at 9:55 AM, Tim Clarke
wrote:
> On 22/03/18 11:53, Steven Hirsch wrote:
> > On Thu, 22 Mar 2018, Devart wrote:
> >
> >> /Devart announced the first release of dbForge Stud
On 22/03/18 11:53, Steven Hirsch wrote:
> On Thu, 22 Mar 2018, Devart wrote:
>
>> /Devart announced the first release of dbForge Studio for PostgreSQL
>> that
>> allows to manage and develop database objects in PostgreSQL. This new
>> IDE
>> offers many robust features like Code Completion, Object
Tomas, thank you. This machine is abare metal server running only a
staging postgresql 10.3 instance. Nobody is using it beside me.
I'm attaching 4 files.
every_30_seconds_top_stats_during_query.txt- this is a caputure of the
top command every 30 seconds(more or less) for 10+ minutes while
On 22/03/18 11:53, Steven Hirsch wrote:
On Thu, 22 Mar 2018, Devart wrote:
/Devart announced the first release of dbForge Studio for PostgreSQL that
allows to manage and develop database objects in PostgreSQL. This new IDE
offers many robust features like Code Completion, Object Explorer and
D
On Thu, 22 Mar 2018, Devart wrote:
/Devart announced the first release of dbForge Studio for PostgreSQL that
allows to manage and develop database objects in PostgreSQL. This new IDE
offers many robust features like Code Completion, Object Explorer and Data
Editor which help users create, develo
Thanks Rob,
The security policy in the example was reduced to the bare minimum, to
demonstrate the issue was with the existence of the policy, not what it did.
Obviously my real-application policy does much more, and uses other columns to
do both read & write checks.
Adding the write check as s
Hello Phil,
On Wed, 2018-03-21 at 15:26 +, HORDER Phil wrote:
> OK,
> Let's try again, with a full script, and including the bit that makes
> the difference…
>
> Hi,
> I’m trying to understand why I’m getting a deadlock issue, and how to
> work around it.
>
> At base, I think the problem i
> You mean Oracle 11g.
No 12c. Some of it may have started in 11g itself, but only in 12c they really
mastered it. I saw it as a developer, not as a DBA. I was never an oracle DBA.
/Devart announced the first release of dbForge Studio for PostgreSQL that
allows to manage and develop database objects in PostgreSQL. This new IDE
offers many robust features like Code Completion, Object Explorer and Data
Editor which help users create, develop and execute queries as well as edit
Chris,
At this point I'd write small piece of code to test if the url and failover
is working correctly. Sounds like you have a considerably sized stack
making it difficult to debug.
With a small piece of code it should become clear as to how things work or
don't as the case may be
Dave Cramer
d
Rakesh Kumar wrote:
> Only in Oracle 12c there are
> options to let the planner change existing plan by peeking into the parameter
> values (supplied in ? of prepare) and checking it against the distribution.
You mean Oracle 11g.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql
25 matches
Mail list logo
