I had not run these commands on the master as I was only doing sql updates
~1mil of them
On Monday, January 21, 2013 at 18:11, bgd39h5...@sneakemail.com
(Nathan Clayton nathanclayton-at-gmail.com |pg-gts/Basic|) wrote:
I only wish. I work with a transactional system from the 70s on
a daily basis that decided to store something like a "work date" and
"work time". The date changes wh
Jeff Janes wrote:
> one hstore field can easily be equivalent to 50 text fields with
> an index on each one.
>
> I'm pretty sure that that is your bottleneck.
I agree that seems like the most likely cause. Each update to the
row holding the hstore column requires adding new index entries for
all
On Wednesday, January 23, 2013 09:10:40 AM Ian Harding wrote:
> The System:
>
> Linux beta 2.6.32-279.19.1.el6.x86_64 #1 SMP Wed Dec 19 07:05:20 UTC 2012
> x86_64 x86_64 x86_64 GNU/Linux
>
That looks like a CentOS 6 system.
Go to http://yum.postgresql.org/repopackages.php
Find the repo appropr
Problem: Some users (scripts actually) try to connect to a DB who's name is
derived from environmental variables. The DB doesn't exist (yet), and I want
them to connect to a different DB for the time being. Is there a way to define
an alias for the existing DB that = the db name that doesn't
Gauthier, Dave wrote:
> Problem: Some users (scripts actually) try to connect to a DB who's name is
> derived from environmental variables. The DB doesn't exist (yet), and I want
> them to connect to a different DB for the time being. Is there a way to
> define an alias for the existing DB th
On 01/23/2013 12:45 PM, Gauthier, Dave wrote:
Problem: Some users (scripts actually) try to connect to a DB who's
name is derived from environmental variables. The DB doesn't exist
(yet), and I want them to connect to a different DB for the time being.
Is there a way to define an alias for the
Nope. Think of it this way, a new DB is created on day 1 of every month. So
there's a DB called JAN, another called FEB, etc... . The DB name used in the
connect is picked up from the current date/time. But January is oevr and I
don't want to create the FEB DB until Feb 15th. In the meantim
On 01/23/2013 02:10 PM, Gauthier, Dave wrote:
Nope. Think of it this way, a new DB is created on day 1 of every month. So
there's a DB called JAN, another called FEB, etc... . The DB name used in the
connect is picked up from the current date/time. But January is oevr and I
don't want to c
On 1/23/2013 1:10 PM, Gauthier, Dave wrote:
Nope. Think of it this way, a new DB is created on day 1 of every month. So
there's a DB called JAN, another called FEB, etc... . The DB name used in the
connect is picked up from the current date/time. But January is oevr and I
don't want to cre
On 01/23/2013 01:16 PM, Rob Sargent wrote:
On 01/23/2013 02:10 PM, Gauthier, Dave wrote:
Nope. Think of it this way, a new DB is created on day 1 of every
month. So there's a DB called JAN, another called FEB, etc... . The
DB name used in the connect is picked up from the current date/time.
Then someone who wants to look at old JAN data will have the same problem :-(
If I recall, Oracle enables something like this. Multiple tnsfilenames (or
something like that). There was a connect layer on the server side that the
DBA had access to where you could do stuff like this.
>> propose
* I think it "should" use that index based on trying to follow that
exercise.
* The part about changing the collation was an idea in the course of trying
out different things.
** enable_seqscan* is off, and the *sharedmem* and *temp_buffers* are set
so high that most things happen in RAM.
I wonder
For each phase of a project, a new DB is created. The project phase is
identified in a linux environment variable (lets call it $PHASE). The DB name
that is used in the connect string of the perl/DBI scripts they run is derived
from that in the perl/DBI script, maybe something like this... $db
On Wed, Jan 23, 2013 at 10:08:05PM +, Gauthier, Dave wrote:
> For each phase of a project, a new DB is created. The project phase is
> identified in a linux environment variable (lets call it $PHASE). The DB
> name that is used in the connect string of the perl/DBI scripts they run is
> de
On 01/23/2013 02:08 PM, Gauthier, Dave wrote:
For each phase of a project, a new DB is created But in the meantime, I have to redirect them to P2_DB
without changing anything in the linux environment. I need to have the DB itself "know" that the
dbname "P3_DB" really = "P2_DB" for the time
Hi,
Oracle has a product called Oracle Workspace Manager:
http://www.oracle.com/technetwork/database/enterprise-edition/index-087067.html
Website says:
"Workspace Manager, a feature of Oracle Database, enables application
developers and DBAs to manage current, proposed and historical versions
On 01/23/2013 02:39 PM, Devrim GÜNDÜZ wrote:
Hi,
Oracle has a product called Oracle Workspace Manager:
http://www.oracle.com/technetwork/database/enterprise-edition/index-087067.html
Website says:
"Workspace Manager, a feature of Oracle Database, enables application
developers and DBAs to m
For a client who needs to learn how to query the db:
- No SQL knowledge at all; needs to start from square 1.
- Smart, capable person, who will be in this position for a long time, using
this db for a long time.
- No chance in hell this db will be moved off PG, so PG-centric is fine ;-)
--
Sc
Scott Ribe wrote on 23.01.2013 23:56:
For a client who needs to learn how to query the db:
- No SQL knowledge at all; needs to start from square 1.
- Smart, capable person, who will be in this position for a long time, using
this db for a long time.
- No chance in hell this db will be moved o
On 1/23/2013 2:56 PM, Scott Ribe wrote:
For a client who needs to learn how to query the db:
- No SQL knowledge at all; needs to start from square 1.
- Smart, capable person, who will be in this position for a long time, using
this db for a long time.
- No chance in hell this db will be moved
John R Pierce wrote on 24.01.2013 00:19:
- No SQL knowledge at all; needs to start from square 1.
- Smart, capable person, who will be in this position for a long
time, using this db for a long time.
- No chance in hell this db will be moved off PG, so PG-centric is
fine
I can't recommend an
On 01/23/2013 04:19 PM, John R Pierce wrote:
On 1/23/2013 2:56 PM, Scott Ribe wrote:
For a client who needs to learn how to query the db:
- No SQL knowledge at all; needs to start from square 1.
- Smart, capable person, who will be in this position for a long time,
using this db for a long tim
On Monday, January 21, 2013, Alexander Farber wrote:
> To make my question more concrete:
> if I'd like to round-robin 6 PostgreSQL connections
> from my Perl script - how should I change my code:
>
But what would that accomplish? If your server is constipated on the IO
channel, all 6 connection
On Monday, January 21, 2013, Alexander Farber wrote:
> Hello,
>
> I run a card game written in Perl on
> a CentOS 6.3 / 64 bit + PostgreSQL 8.4.13
> where quite a lot player statistics are written
> to the d/b (score, game results, moves, etc.)
>
> Here a player profile: http://preferans.de/DE1119
On Wednesday, January 23, 2013 09:39:43 PM Gauthier, Dave wrote:
> Then someone who wants to look at old JAN data will have the same problem
> :-(
>
> If I recall, Oracle enables something like this. Multiple tnsfilenames (or
> something like that). There was a connect layer on the server side t
I'm hoping this opportunity will be of interest to some of you on this list:
LISAsoft [0] has expanded our Australian/New Zealand Open Source Support
offerings to include dedicated Postgres commercial support, migrations
to Postgres, and training, through our partnership with EnterpriseDB
[1].
27 matches
Mail list logo
