Hi,
I've got
2014-12-28 14:33:23 GMT 553582643 24969 SELECT 53200 63/8298433
54a00a84.6189 1 %ERROR: out of shared memory
2014-12-28 14:33:23 GMT 553582643 24969 SELECT 53200 63/8298433
54a00a84.6189 2 %HINT: You might need to increase
max_pred_locks_per_transaction.
Is there any way to
On Tue, Jan 6, 2015 at 9:09 AM, Michael Heaney mhea...@jcvi.org wrote:
I'm fairly new to Postgres, and have a design issue for which an array of
integers might be a good solution. But I'd like to hear from the experts
before proceeding down this path.
Essentially, I'm trying to model the
On 1/6/2015 1:56 PM, Tim Smith wrote:
Hi Andy,
Yeah, the table scan was what worried me.
As for no indexes ? I just didn't put the create index statements
in my post ... ;-)
Tim
On 6 January 2015 at 18:35, Andy Colson a...@squeakycode.net wrote:
On 1/6/2015 12:02 PM, Tim Smith wrote:
Hi,
On 06 Jan 2015, at 19:02, Tim Smith randomdev4+postg...@gmail.com wrote:
create table app_sessions(
session_id char(64) unique not null,
user_id char(32) unique not null,
session_start bigint not null,
session_lastactive bigint not null
);
Just an observation: Are you sure that you don’t
On 01/06/2015 01:18 PM, Michael Heaney wrote:
On 1/6/2015 2:19 PM, Jeff Janes wrote:
On Tue, Jan 6, 2015 at 9:09 AM, Michael Heaney mhea...@jcvi.org
mailto:mhea...@jcvi.org wrote:
I'm fairly new to Postgres, and have a design issue for which an
array of integers might be a good
On 1/6/2015 2:19 PM, Jeff Janes wrote:
On Tue, Jan 6, 2015 at 9:09 AM, Michael Heaney mhea...@jcvi.org
mailto:mhea...@jcvi.org wrote:
I'm fairly new to Postgres, and have a design issue for which an
array of integers might be a good solution. But I'd like to hear
from the experts
Hi Michael,
I can't comment on the domain-specific stuff, but I recently used numeric
arrays for a project and it worked well. In my case we had one million
simulation results (floats) per scenario, so rather than reading one
million separate rows to compute a histogram, we stored everything in
Hi Andy,
Yeah, the table scan was what worried me.
As for no indexes ? I just didn't put the create index statements
in my post ... ;-)
Tim
On 6 January 2015 at 18:35, Andy Colson a...@squeakycode.net wrote:
On 1/6/2015 12:02 PM, Tim Smith wrote:
Hi,
I'm probably being incredibly stupid
On 1/6/2015 12:02 PM, Tim Smith wrote:
Hi,
I'm probably being incredibly stupid and missing something incredibly
simple but I've got a bit of query-writers block here !
create table app_sessions(
session_id char(64) unique not null,
user_id char(32) unique not null,
session_start bigint not
Andrey Lizenko lizenk...@gmail.com wrote:
2014-12-28 14:33:23 GMT 553582643 24969 SELECT 53200 63/8298433
54a00a84.6189 1 %ERROR: out of shared memory
2014-12-28 14:33:23 GMT 553582643 24969 SELECT 53200 63/8298433
54a00a84.6189 2 %HINT: You might need to increase
Hello,
I have been working on a module which launches background workers for a
list of databases provided by a configuration parameter(say m_databases).
This configuration parameter can be edited and reloaded.
It has a launcher which manages all the workers launched by the module.
The
On 6 Jan 2015 03:02, tuanhoanganh hatua...@gmail.com wrote:
Hello everybody
Does anyone user pg-pool II on real production ?
Yes we have a customer using it in load balancing mode and another one
using it with Watchdog for high availability.
How many slave do you have? and how many size of
Hi Guys.
First of all, BDR is cool, should have tried it earlier.
Environment: CentOS 6.5, PostgreSQL 9.4.0 with BDR from yum repository
Done the PostgreSQL 9.4 with BDR setup successfully by following the User
Guide and Admin Doc, but got a issue when tried to do postgresql service
restart on
I’m familiar with both PostgreSQL and Riak (1.4, not 2.0).
I know that Riak 2.0 now offers strong consistency. Have not yet seen what that
does to performance.
Big plusses for PostgreSQL:
- you can do both relational and NOSQL tasks (the Binary JSON in the latest
PostgreSQL).
-
On Jan 6, 2015 3:12 PM, Michael Heaney mhea...@jcvi.org wrote:
I'm fairly new to Postgres, and have a design issue for which an array of
integers might be a good solution. But I'd like to hear from the experts
before proceeding down this path.
Essentially, I'm trying to model the relationship
On 1/6/2015 12:02 PM, Tim Smith wrote:
Hi,
I'm probably being incredibly stupid and missing something incredibly
simple but I've got a bit of query-writers block here !
create table app_sessions(
session_id char(64) unique not null,
user_id char(32) unique not null,
session_start bigint not
A very popular design I see is often this:
- PostgreSQL for account, inventory, transactional; and all writes
- NoSQL (Redis, Riak, Mongo, etc) for read-only index postgres (almost
like a read-through cache) and assembled documents
On Jan 5, 2015, at 5:46 PM, Raymond Cote
On 01/06/2015 10:09 AM, Michael Heaney wrote:
I'm fairly new to Postgres, and have a design issue for which an array
of integers might be a good solution. But I'd like to hear from the
experts before proceeding down this path.
Essentially, I'm trying to model the relationship between a group
I'm fairly new to Postgres, and have a design issue for which an array
of integers might be a good solution. But I'd like to hear from the
experts before proceeding down this path.
Essentially, I'm trying to model the relationship between a group of
biological samples and their genes. Each
Hi,
I'm probably being incredibly stupid and missing something incredibly
simple but I've got a bit of query-writers block here !
create table app_sessions(
session_id char(64) unique not null,
user_id char(32) unique not null,
session_start bigint not null,
session_lastactive bigint not null
);
20 matches
Mail list logo