Philipp Kraus wrote:
My PG database is connected to differend cluster nodes (MPI). Each
programm / process on each node are independed and run the SQL
select * from table where status = waiting
after that I update the row with the update statement (set status = working)
so in this case one
Le 2013-04-16 à 22:51, François Beausoleil a écrit :
Hi all!
I track Twitter followers in my database. I have the following table:
# \d persona_followers
Table public.persona_followers
Column|Type | Modifiers
Hi. I was promoting PostgreSQL to an AIX/Oracle shop yesterday, they are
looking to switch to open source to cut their licensing costs, and was
asked how large a database does PostgreSQL support? Is there an upper
bound on database size and if so, what it is?
Aleksey Tsalolikhin
On 04/17/2013 06:23 AM, Aleksey Tsalolikhin wrote:
Hi. I was promoting PostgreSQL to an AIX/Oracle shop yesterday, they
are looking to switch to open source to cut their licensing costs, and
was asked how large a database does PostgreSQL support? Is there an
upper bound on database size and if
On Wed, 17 Apr 2013 08:23:41 -0500, Aleksey Tsalolikhin
atsaloli.t...@gmail.com wrote:
Hi. I was promoting PostgreSQL to an AIX/Oracle shop yesterday, they are
looking to switch to open source to cut their licensing costs, and was
asked how large a database does PostgreSQL support? Is there
On Wed, Apr 17, 2013 at 06:23:41AM -0700, Aleksey Tsalolikhin wrote:
Hi. I was promoting PostgreSQL to an AIX/Oracle shop yesterday, they are
looking to switch to open source to cut their licensing costs, and was asked
how large a database does PostgreSQL support? Is there an upper bound on
Aleksey Tsalolikhin wrote:
Hi. I was promoting PostgreSQL to an AIX/Oracle shop yesterday, they are
looking to switch to open
source to cut their licensing costs, and was asked how large a database does
PostgreSQL support? Is
there an upper bound on database size and if so, what it is?
INSERT INTO persona_followers(service_id, follower_id, valid_at)
SELECT service_id, follower_id, NOW()
FROM (SELECT DISTINCT service_id, follower_id FROM import) AS import
WHERE NOT EXISTS(SELECT * FROM persona_followers WHERE import.service_id
= persona_followers.service_id AND
On 2013-04-17 09:18:13 +0200, Albe Laurenz said:
Philipp Kraus wrote:
My PG database is connected to differend cluster nodes (MPI). Each
programm / process on each node are independed and run the SQL
select * from table where status = waiting
after that I update the row with the update
On Tue, Apr 16, 2013 at 7:29 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
The autovacuum daemon, if enabled, will automatically issue ANALYZE
commands whenever the content of a table has changed sufficiently. However,
administrators might prefer to rely on manually-scheduled ANALYZE
On Tue, Apr 16, 2013 at 3:04 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Dale Fukami dale.fuk...@gmail.com writes:
I'm having a problem on a standby server (streaming replication) where a
table seems to exist but is not queryable. Essentially a select statement
(and drop/insert/etc) fails but
On 04/17/2013 07:49 AM, Moshe Jacobson wrote:
On Tue, Apr 16, 2013 at 7:29 PM, Adrian Klaver adrian.kla...@gmail.com
mailto:adrian.kla...@gmail.com wrote:
The autovacuum daemon, if enabled, will automatically issue ANALYZE
commands whenever the content of a table has changed
Dear All,
Can any one please help me to fix this issue, i am getting this error from
our application, currently Database is running on 9.2.
2013-04-17 11:37:25:151 - {ERROR} database.ConnectionManager Thread
[http-8080-1]; --- getConnection() Exception:
My experience, doing production and dev dba work on both postgresql
and oracle, is that either works well, as long as you partition
properly or even break things into silos. Oracle isn't magic pixie
dust that suddenly gets hardware with 250MB/s seq read arrays to read
at 1GB/s, etc.
With oracle
Dale Fukami dale.fuk...@gmail.com writes:
On Tue, Apr 16, 2013 at 3:04 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Either way, if it's working on the master, then you've had a replication
failure since the standby's files evidently don't match the master's.
What PG version is this (and which
On 19 March 2013 01:00, Tom Lane t...@sss.pgh.pa.us wrote:
Wasim Arif wasima...@gmail.com writes:
What is the road map for Postgres on the AIX platform? I understand that
the pg build farm contains an AIX 5.3 server; are there any plans to
upgrade to 6.1 and 7.1?
The reason there's an
On Wed, Apr 17, 2013 at 4:26 AM, François Beausoleil
franc...@teksol.infowrote:
Insert on public.persona_followers (cost=139261.12..20483497.65
rows=6256498 width=16) (actual time=4729255.535..4729255.535 rows=0 loops=1)
Buffers: shared hit=33135295 read=4776921
- Subquery Scan on
Thanks for all the great answers, folks, I'll pass this along.
Cheers!
Aleksey
On Wed, Apr 17, 2013 at 9:45 AM, Scott Marlowe scott.marl...@gmail.comwrote:
My experience, doing production and dev dba work on both postgresql
and oracle, is that either works well, as long as you partition
Thanks a lot.
I have compiled gsl with prefix=/usr and this is quite acceptable for us.
On Mon, Apr 15, 2013 at 2:30 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Yuriy Rusinov wrote:
I have to put some C-language functions onto postgresql server 9.2.
These functions are used GSL
On Tue, Apr 16, 2013 at 10:51 PM, François Beausoleil
franc...@teksol.infowrote:
INSERT INTO persona_followers(service_id, follower_id, valid_at)
SELECT service_id, follower_id, NOW()
FROM (SELECT DISTINCT service_id, follower_id FROM import) AS import
WHERE NOT EXISTS(SELECT * FROM
Hi Itsrhree
From the machine where is running the tomcat, do you check that you can
connect to postgresql server (remember check parameters of connection, user,
password, ip)?
Having this first step tested, then:
Do you have the correct connection pool configured on Catalina (Tomcat) and let
On 4/17/13, Scott Marlowe scott.marl...@gmail.com wrote:
My experience, doing production and dev dba work on both postgresql
and oracle, is that either works well, as long as you partition
properly or even break things into silos. Oracle isn't magic pixie
dust that suddenly gets hardware with
Hm ... there was a fix in 9.0.12 that might be relevant to this:
http://git.postgresql.org/gitweb/?p=postgresql.gita=commitdiffh=5840e3181b7e6c784fdb3aff708c4dcc2dfe551d
Whether that explains it or not, 9.0.5 is getting long in the tooth;
you really need to think about an update. Especially
Hi There,
I'm having a bit of an issue finding a C function to fetch the
configured server port from a C module.
We have written a C module to allow for remote clients to call a function
to run pg_dump/pg_restore remotely but create files locally on the db
server.
Currently it works fine if
On Wed, Apr 17, 2013 at 01:08:18PM -0600, Mike Roest wrote:
Hi There,
I'm having a bit of an issue finding a C function to fetch the configured
server port from a C module.
We have written a C module to allow for remote clients to call a function to
run pg_dump/pg_restore remotely but
On 4/17/2013 12:08 PM, Mike Roest wrote:
I could hard code the port in the module when we build it but it would
be nice to be able to change the configured postgres port and not have
to rebuild the module.
Anyone have any suggestions?
SHOW PORT;
?
works in 9.2, anyways.
--
john r
SHOW PORT;
test= SELECT setting FROM pg_settings WHERE name = 'port';
setting
-
5432
Both of these are from a query context. This is in a C module, I suppose I
could run a query but there has to be a direct C function to get this data.
On Wed, Apr 17, 2013 at 01:32:00PM -0600, Mike Roest wrote:
SHOW PORT;
test= SELECT setting FROM pg_settings WHERE name = 'port';
setting
-
5432
Both of these are from a query context. This is in a C module, I suppose I
could run a query
On Wed, Apr 17, 2013 at 12:53 PM, Michael Nolan htf...@gmail.com wrote:
On 4/17/13, Scott Marlowe scott.marl...@gmail.com wrote:
My experience, doing production and dev dba work on both postgresql
and oracle, is that either works well, as long as you partition
properly or even break things
Le 2013-04-17 à 14:15, Jeff Janes a écrit :
On Wed, Apr 17, 2013 at 4:26 AM, François Beausoleil franc...@teksol.info
wrote:
Insert on public.persona_followers (cost=139261.12..20483497.65
rows=6256498 width=16) (actual time=4729255.535..4729255.535 rows=0 loops=1)
Buffers:
I'm using psql to extract data from a redshift (based on postgres)
instance, but psql/libpq collects the result in memory before writing it to
a file and causes out of memory problems for large results. Using COPY TO
STDOUT or FETCH_COUNT isn't an option since redshift doesn't support those.
Perfect thanks Bruce that worked.
I just extern'd PostPortNumber in my module and everything seems to be
working.
--Mike
On Wed, Apr 17, 2013 at 1:19 PM, François Beausoleil
franc...@teksol.infowrote:
Le 2013-04-17 à 14:15, Jeff Janes a écrit :
It looks like 12% of the time is being spent figuring out what rows to
insert, and 88% actually doing the insertions.
So I think that index maintenance is killing
What am I missing here?
postgres= SELECT current_user;
current_user
--
carlos
(1 row)
postgres= CREATE DATABASE carlosdb;
ERROR: permission denied to create database
postgres= \du
List of roles
Role name | Attributes
Carlos Mennens carlos.menn...@gmail.com writes:
Shouldn't 'carlos' be a superuser based on him being a member of a
role which has createdb and superuser rights granted to it?
No. Superuserness is quite intentionally not inheritable.
It's perhaps a bit more debatable whether other role
35 matches
Mail list logo