Hi, I have also reported a similar problem in the hackers mailing list, but
particularly on TRUNCATE TABLE.
https://www.postgresql.org/message-id/flat/D09B13F772D2274BB348A310EE3027C62FD6E6%40g01jpexmbkw24
The problem lies with the standby server’s replay as it does separate scanning
of the whol
Peter Eisentraut writes:
> On 17.07.18 02:13, Joshua D. Drake wrote:
>> On 07/16/2018 05:08 PM, Alvaro Herrera wrote:
>>>
>>> Sounds like wiki pages could solve need this pretty conveniently. If
>>> and when the content is mature enough and migrates to the tutorial main
>>> documentation pages
On Tuesday, July 17, 2018, Aaron Gray wrote:
>
> I am wanting to be able to have control over what files that ables are
> stored in. Basically I am looking to have literally tens of thousands of
> tables all of the same type and to be able to store these as separate files
> in a filing system.
>
On 07/17/2018 02:50 PM, Aaron Gray wrote:
Hi,
I am wanting to be able to have control over what files that ables are
stored in. Basically I am looking to have literally tens of thousands of
tables all of the same type and to be able to store these as separate
files in a filing system.
Becau
Hi,
I am wanting to be able to have control over what files that ables are
stored in. Basically I am looking to have literally tens of thousands of
tables all of the same type and to be able to store these as separate files
in a filing system.
--
Aaron Gray
Independent Open Source Software Engi
On Tue, Jul 17, 2018 at 4:30 PM, Christoph Moench-Tegeder <
c...@burggraben.net> wrote:
> ## Olivier Gautherot (oliv...@gautherot.net):
>
> > To: Christoph Moench-Tegeder
>
> I think you meant to hit List-Reply...
>
Ooops, my bad...
> > I just pulled the .tar.bz2 archive and compiled it with
Adrian Klaver writes:
> On 07/17/2018 12:34 PM, Márcio Antônio Sepp wrote:
>> I'm trying to compile PostgreSQL 11beta2 but this errors occur:
>> checking readline.h usability... no
> Looks like you need whatever is the FreeBSD equivalent of readline-dev(el).
AFAICT FreeBSD doesn't do things that
## Márcio Antônio Sepp (mar...@zyontecnologia.com.br):
> Im trying to compile PostgreSQL 11beta2 but this errors occur:
>
> root@srvbacula:/postgresql/postgresql-11beta2 # ./configure
Stop right here and try using the same configure command line
as the port (postgresql10-server, as there's no v
On 07/17/2018 12:34 PM, Márcio Antônio Sepp wrote:
Hi,
I’m trying to compile PostgreSQL 11beta2 but this errors occur:
checking readline.h usability... no
checking readline.h presence... no
checking for readline.h... no
checking readline/readline.h usability... no
checking readline/readl
Hi,
Im trying to compile PostgreSQL 11beta2 but this errors occur:
root@srvbacula:/postgresql/postgresql-11beta2 # ./configure
checking build system type... x86_64-unknown-freebsd11.1
checking host system type... x86_64-unknown-freebsd11.1
checking which template to use... freebsd
There was a recent commit for a similar performance problem, which will
appear in 9.6.10. But that was specifically for cases where there were
multiple dropped tables per transaction, and large shared_buffers.
I can't reproduce your single-drop-per-transaction problem. The replica
has no problem
We are running Postgres 9.6.9 on RHEL 6.9. We're using built-in streaming
replication, with a WAL archive for fallback purposes. No logical
replication.
We recently had a bug in our code accidentally create several hundred
thousand tables in a single database. A batch job started cleaning them up
On 07/17/2018 07:01 AM, Jean Claude wrote:
Hello Guys'
I have implement a pgpool-II cluster and the standby service want not to
add on the watchdog info..
Some issues for help?
Jul 17 09:55:59 test01 pgpool[2166]: [223-2] 2018-07-17 09:55:59: pid
2166: DETAIL: backend response with kind '
Hello Guys'
I have implement a pgpool-II cluster and the standby service want not to
add on the watchdog info..
Some issues for help?
[root@tes01 ~]# /usr/pgpool-10/bin/pcp_watchdog_info -p 9898 -U pgpool
Password:
2 YES test01.adm.test.ch:5432 Linux test01 test01.test.cacc.ch
test01.adm.test.ch
On 07/16/2018 04:56 PM, Joshua D. Drake wrote:
On 07/16/2018 04:33 PM, Adrian Klaver wrote:
I did it! Want to help? I think if we got together 5-7 people and came
up with a proposal we could submit to -www/-core and get some buy in.
Given the really discovered existence of the tutorial pag
On Tue, Jul 17, 2018 at 1:47 PM, Peter Eisentraut <
peter.eisentr...@2ndquadrant.com> wrote:
> On 17.07.18 02:13, Joshua D. Drake wrote:
> > On 07/16/2018 05:08 PM, Alvaro Herrera wrote:
> >>
> >> Sounds like wiki pages could solve need this pretty conveniently. If
> >> and when the content is ma
On 17.07.18 02:13, Joshua D. Drake wrote:
> On 07/16/2018 05:08 PM, Alvaro Herrera wrote:
>>
>> Sounds like wiki pages could solve need this pretty conveniently. If
>> and when the content is mature enough and migrates to the tutorial main
>> documentation pages, the wiki pages can be replaced wit
On 17.07.18 03:41, Igor Polishchuk wrote:
> We are trying to use logical decoding for detecting database changes.
> However, when we create a replication slot, the data processing pauses
> if there are still transactions running from before the slot creation.
> If I understand correctly, the slot i
you have your points, my friend.
On 07/17/2018 11:23 AM, Jehan-Guillaume (ioguix) de Rorthais wrote:
> On Tue, 17 Jul 2018 11:03:08 +0200
> Fabio Pardi wrote:
>
>> On 07/17/2018 10:21 AM, Jehan-Guillaume (ioguix) de Rorthais wrote:
>>> On Tue, 17 Jul 2018 10:11:50 +0200
>>
>>> ...and check th
Thanks, I'll look into it.
On Tue, Jul 17, 2018 at 3:42 PM Christoph Moench-Tegeder
wrote:
> ## ramsiddu007 (ramsiddu...@gmail.com):
>
> > If i remove first character it's run. That first
> > character is invisible, I have checked that *ascii* value, it is *65279*.
>
> That's not an ASCII-value
On Tue, Jul 17, 2018 at 11:17 AM, Guillaume Lelarge
wrote:
> 2018-07-17 2:35 GMT+02:00 Ravi Krishna :
>
>> Not sure I am following this. Did Google release this because PG backups
>> are not 100% reliable or the data corruption can occur due to hardware
>> failure.
>>
>> http://www.eweek.com/clo
On Tue, 17 Jul 2018 11:03:08 +0200
Fabio Pardi wrote:
> On 07/17/2018 10:21 AM, Jehan-Guillaume (ioguix) de Rorthais wrote:
> > On Tue, 17 Jul 2018 10:11:50 +0200
>
> > ...and check this one: https://github.com/OPMDG/check_pgactivity/
> >
> > It uses bloat queries for tables and btree indexes
2018-07-17 2:35 GMT+02:00 Ravi Krishna :
> Not sure I am following this. Did Google release this because PG backups
> are not 100% reliable or the data corruption can occur due to hardware
> failure.
>
> http://www.eweek.com/cloud/google-releases-open-source-
> tool-that-checks-postgres-backup-in
On 07/17/2018 10:21 AM, Jehan-Guillaume (ioguix) de Rorthais wrote:
> On Tue, 17 Jul 2018 10:11:50 +0200
> ...and check this one: https://github.com/OPMDG/check_pgactivity/
>
> It uses bloat queries for tables and btree indexes Adrien Nayrat was pointing
> earlier in this thread.
>
> In fact,
On Tue, 17 Jul 2018 10:11:50 +0200
Fabio Pardi wrote:
> If you monitor using nagios (or if you want to make a wrapper around it):
>
> https://bucardo.org/check_postgres/check_postgres.pl.html#bloat
...and check this one: https://github.com/OPMDG/check_pgactivity/
It uses bloat queries for tabl
If you monitor using nagios (or if you want to make a wrapper around it):
https://bucardo.org/check_postgres/check_postgres.pl.html#bloat
works like a charm.
regards,
fabio pardi
On 07/16/2018 05:16 PM, Alessandro Aste wrote:
> Hello, I am trying to put togheter a query to monitor the index
26 matches
Mail list logo
