On Wed, Apr 15, 2015 at 4:49 AM, Andreas Joseph Krogh
andr...@visena.com wrote:
In other words: Does vacuumlo cause diskspace used by pg_largeobject to be
freed to the OS (after eventually vacuumed by autovacuum)?
No.
But that shouldn't matter in your scenario: if you create more large
På onsdag 15. april 2015 kl. 15:50:36, skrev Adam Hooper a...@adamhooper.com
mailto:a...@adamhooper.com: On Wed, Apr 15, 2015 at 4:49 AM, Andreas Joseph
Krogh
andr...@visena.com wrote:
In other words: Does vacuumlo cause diskspace used by pg_largeobject to be
freed to the OS (after
On Wed, Apr 15, 2015 at 9:57 AM, Andreas Joseph Krogh
andr...@visena.com wrote:
På onsdag 15. april 2015 kl. 15:50:36, skrev Adam Hooper
a...@adamhooper.com:
On Wed, Apr 15, 2015 at 4:49 AM, Andreas Joseph Krogh
andr...@visena.com wrote:
In other words: Does vacuumlo cause diskspace
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Pawel Veselov
Sent: Tuesday, April 14, 2015 8:01 PM
To: Jim Nasby
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Help with slow table update
[skipped]
This is where using sets becomes
På onsdag 15. april 2015 kl. 16:05:22, skrev Adam Hooper a...@adamhooper.com
mailto:a...@adamhooper.com: On Wed, Apr 15, 2015 at 9:57 AM, Andreas Joseph
Krogh
andr...@visena.com wrote:
På onsdag 15. april 2015 kl. 15:50:36, skrev Adam Hooper
a...@adamhooper.com:
On Wed, Apr 15, 2015 at
[skipped]
This is where using sets becomes really tedious, as Postgres severely
lacks an upsert-like statement.
I don't think there are joins allowed in UPDATE statement, so I will need
to use WITH query, right?
Also, I'm not sure how LEFT JOIN will help me isolate and insert missed
Hi,
I have installed postgresql-9.4.0 version.
I have started the server from eclipse indigo version using Run
configurations.
There is a table in my database whose name is b. whenever I give a query
which is related to this table I get the error *The connection to the
server was lost.
On 04/15/2015 01:35 PM, Ravi Kiran wrote:
Hi,
I have installed postgresql-9.4.0 version.
I have started the server from eclipse indigo version using Run
configurations.
Have no idea what that means.
Some detail on exactly how you are making the connection would be
helpful including:
1)
Dear List,
I need to migrate my database from a 2.x to 3.x. Usually Im using
pg_basebackup , but this is not possible with different versions.
Pg_dump seems to be an option but it is slow like hell and I dont want
to stay offline all the time.
Is there another possibility to migrate a
On 15/04/2015 20:03, Filip Lyncker wrote:
Dear List,
I need to migrate my database from a 2.x to 3.x. Usually Im using
pg_basebackup , but this is not possible with different versions.
Pg_dump seems to be an option but it is slow like hell and I dont want
to stay offline all the time.
Is
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Filip Lyncker
Sent: Wednesday, April 15, 2015 3:03 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Best way to migrate a 200 GB database from PG 2.7 to 3.6
Dear
On 4/15/2015 2:03 PM, Filip Lyncker wrote:
Dear List,
I need to migrate my database from a 2.x to 3.x. Usually Im using
pg_basebackup , but this is not possible with different versions.
Pg_dump seems to be an option but it is slow like hell and I dont want
to stay offline all the time.
Is there
On 04/15/2015 12:14 PM, Andy Colson wrote:
Postgresql is on version 9. What do you mean version 2 or 3?
He probably means 9.2.7 to 9.3.6. Remember to a lot of people 9 means 9.
That said, pg_upgrade is the way to do this as long as you can have an
outage.
JD
--
Command Prompt, Inc. -
On Thu, 16 Apr 2015 02:05:34 +0530
Ravi Kiran ravi.kolanp...@gmail.com wrote:
I have installed postgresql-9.4.0 version.
I have started the server from eclipse indigo version using Run
configurations.
There is a table in my database whose name is b. whenever I give a query
which is
På onsdag 15. april 2015 kl. 04:43:47, skrev Venkata Balaji N nag1...@gmail.com
mailto:nag1...@gmail.com: I'm routinely vacuumlo'ing to reap orphan OIDs.
Is it necessary to manually vacuum pg_largobject or is it handled by autovacuum?
It is handled by autovacuum. What we do is, we schedule
På onsdag 15. april 2015 kl. 04:34:31, skrev Venkata Balaji N nag1...@gmail.com
mailto:nag1...@gmail.com: I'm planning to vacuum FULL a pg_largeobject
relation (after vacuumlo'ing it). The relation is 300GB large so I'm concerned
the operation will write full my pg_xlog directory which is on
16 matches
Mail list logo