ERR ORR wrote:
This is just to say that I upgraded from V9.2.6 to V9.3.2.
Same HW, same data, an astonishing performance increase.
Postgres is flying
It lies in the nature of a support mailing list that most of the feedback
you get is like we upgraded, and this and that is much slower now.
On Fri, Dec 27, 2013 at 12:11 AM, Steve Crawford
scrawf...@pinpointresearch.com wrote:
People who have attempted to install PGDG versions of PostgreSQL on recent
Ubuntu releases have run into the cascading problem of postgresql wanting
to destroy Ubuntu.
Based on the packaging:
postgresql
HI all,
I have a fairly complex python script which calls a number of ‘psql’
sessions via a subprocess to perform bulk load operations.
The bulk loads are generated on the fly, and are written directly to the
stdin of the subprocess.
I would like to rely on the ON_ERROR_STOP=1 functionality to
Hi,
Just to be curious, why is wal_writer_delay limited to 10s?
I am using postgresql in an embedded environment where every 10s
sensor values are logged and even with synchronous_commit = off and
wal_writer_delay=1 this burns quite a lot of nand cycles. For me
it wouldn't hurt loosing
So how are you moving the 9.0 directory?
Just using a mv command like below:
mv /usr/local/pgsql/data /usr/local/pgsql_90/data
Then I recreated the symlinks in /pg_tbspc to point to the new directory
path.
What does a listing for that directory look like after the move?
On 12/27/2013 06:50 AM, Joseph Kregloh wrote:
So how are you moving the 9.0 directory?
Just using a mv command like below:
mv /usr/local/pgsql/data /usr/local/pgsql_90/data
Then I recreated the symlinks in /pg_tbspc to point to the new directory
path.
Ah, now I see the problem, I
Postgres is going to /usr/local/pgsql/data/drupal_dbspace/ to look for
the 9.0 files instead of /usr/local/pgsql_90/data/drupal_dbspace/ and is
trying to copy them as 9.3 versions into the new default location which has
the same path. Since the new
On 12/27/2013 01:00 PM, Joseph Kregloh wrote:
Postgres is going to /usr/local/pgsql/data/drupal___dbspace/ to look
for the 9.0 files instead of
/usr/local/pgsql_90/data/__drupal_dbspace/ and is trying to copy
them as 9.3 versions into the new default location which has the
On Fri, Dec 27, 2013 at 7:30 AM, Tim Kane tim.k...@gmail.com wrote:
HI all,
I have a fairly complex python script which calls a number of ‘psql’
sessions via a subprocess to perform bulk load operations.
The bulk loads are generated on the fly, and are written directly to the
stdin of the
On 28/12/13 02:01, Clemens Eisserer wrote:
Hi,
Just to be curious, why is wal_writer_delay limited to 10s?
I am using postgresql in an embedded environment where every 10s
sensor values are logged and even with synchronous_commit = off and
wal_writer_delay=1 this burns quite a lot of nand
FYI, some testing showed that playing around with spclocation in
pg_tablespace is not recommended.
Do you happen to have more information about this? Because it would
actually solve all my problems by moving the user created tablespaces out
of the /data directory. But I would like more
On 12/27/2013 01:56 PM, Joseph Kregloh wrote:
FYI, some testing showed that playing around with spclocation in
pg_tablespace is not recommended.
Do you happen to have more information about this? Because it would
actually solve all my problems by moving the user created tablespaces
out
On 12/27/2013 01:00 PM, Joseph Kregloh wrote:
Postgres is going to /usr/local/pgsql/data/drupal___dbspace/ to look
for the 9.0 files instead of
/usr/local/pgsql_90/data/__drupal_dbspace/ and is trying to copy
them as 9.3 versions into the new default location which has the
On Friday, December 27, 2013, Joseph Kregloh wrote:
FYI, some testing showed that playing around with spclocation in
pg_tablespace is not recommended.
Do you happen to have more information about this? Because it would
actually solve all my problems by moving the user created tablespaces
On 12/27/2013 02:52 PM, Jeff Janes wrote:
On Friday, December 27, 2013, Joseph Kregloh wrote:
FYI, some testing showed that playing around with spclocation in
pg_tablespace is not recommended.
Do you happen to have more information about this? Because it would
actually
15 matches
Mail list logo