Thanks to George and Adrian for their latest responses regarding a DELETE /
AUTOVACUUM / VACUUM approach, to recycling disk space allocated for rows in
a
postgres table, that is used to manage sessions (e.g. HTTP sessions with
visitor web browsers).
My comments are below. In them, I propose an
On 30/11/15 22:50, Steve Crawford wrote:
> Do you have any clients connected that are idle in transaction?
No, the backend database is a streaming replica. Also, as I said, the
backend process is in "idle" state not "idle in transaction".
backend_start| 2015-11-30 18:58:30.639962+00
xact_star
Do you have any clients connected that are idle in transaction?
Cheers,
Steve
On Mon, Nov 30, 2015 at 1:46 PM, Torsten Förtsch
wrote:
> Hi,
>
> I am not sure if this is the right place to ask this question. If not,
> please point me to it.
>
> I am trying out the new pgbouncer (latest git). "SH
Hi,
I am not sure if this is the right place to ask this question. If not,
please point me to it.
I am trying out the new pgbouncer (latest git). "SHOW SERVERS" is
telling me 2 connections in "active" state. Both show
connect_time=2015-11-30 18:58:30. Request_time is 19:01:35 and 20:56:36.
Both u
On 11/30/2015 01:32 PM, 2athep+5ud7717ssv...@guerrillamail.com wrote:
Newly installed postgresql 9.4.5
Microsoft Windows 2008 R2 Standard SP1, x64
Installed from postgresql-9.4.5-2-windows-x64.exe
from http://www.enterprisedb.com/products-services-training/pgdownload#windows
File version of
Newly installed postgresql 9.4.5
Microsoft Windows 2008 R2 Standard SP1, x64
Installed from postgresql-9.4.5-2-windows-x64.exe
from http://www.enterprisedb.com/products-services-training/pgdownload#windows
File version of psql.exe is p.4.5.15322
I have disabled passwords in pg_hba.conf, becau
On 11/30/2015 09:54 AM, anj patnaik wrote:
1) directory listing:
/opt/nfsDir/postgres/9.4/
/bin
/data
/etc
/pgAdmin3
I am working with a client who has a 9.1 database rapidly approaching XID
wraparound. They also have an exceedingly large pg_largeobject table (4217
GB) that has never been vacuumed. An attempt to vacuum this on a replica
has run for days and never succeeded. (Or more accurately, never been
allo
On Mon, Nov 30, 2015 at 04:51:15PM +, Benedikt Grundmann wrote:
> Are you able to compile from 9.4 git head and test that? It seems
> dumping inheriting constraints from parents has not worked properly for
> some time.
>
>
> Do I need to get the latest/head 9.2 or the latest/head
On Mon, Nov 30, 2015 at 4:29 PM, Bruce Momjian wrote:
> On Mon, Nov 30, 2015 at 08:08:50AM +, Benedikt Grundmann wrote:
> >
> >
> > On Sat, Nov 28, 2015 at 2:39 AM, Adrian Klaver <
> adrian.kla...@aklaver.com>
> > wrote:
> >
> > On 11/27/2015 06:07 PM, Tom Lane wrote:
> > > Adrian Kla
Thank you.
I think there is no native function that will solve this problem,
intarray extension can't order as in the example query.
I could write a new SQL function but I solved the problem with
subqueries and works fine.
I need order because I use nested trees.
To_left and to_right are the
On Mon, Nov 30, 2015 at 08:08:50AM +, Benedikt Grundmann wrote:
>
>
> On Sat, Nov 28, 2015 at 2:39 AM, Adrian Klaver
> wrote:
>
> On 11/27/2015 06:07 PM, Tom Lane wrote:
> > Adrian Klaver writes:
> >> On 11/27/2015 08:15 AM, Bruce Momjian wrote:
> >>> My guess is you are sh
On Tue, Nov 24, 2015 at 9:57 PM, 657985...@qq.com <657985...@qq.com> wrote:
> oh .thanks i understand . but i still have a question .
> [root@pg1 pgdata]# uname -a
> Linux pg1 3.10.0-123.9.3.el7.x86_64 #1 SMP Thu Nov 6 15:06:03 UTC 2014
> x86_64 x86_64 x86_64 GNU/Linux
> [root@pg1 pgdata]# cat /etc
On Sat, Nov 28, 2015 at 2:39 AM, Adrian Klaver
wrote:
> On 11/27/2015 06:07 PM, Tom Lane wrote:
> > Adrian Klaver writes:
> >> On 11/27/2015 08:15 AM, Bruce Momjian wrote:
> >>> My guess is you are sharing the constraint name "seqno_not_null" with
> >>> multiple tables. I think you are going to
14 matches
Mail list logo
