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].
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
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 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 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
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 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
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
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
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
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: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
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
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
* 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
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
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.
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 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
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 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
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
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
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
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 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
I had not run these commands on the master as I was only doing sql updates
~1mil of them
27 matches
Mail list logo
